john zhao created HIVE-15012: -------------------------------- Summary: array_contains type error Key: HIVE-15012 URL: https://issues.apache.org/jira/browse/HIVE-15012 Project: Hive Issue Type: Bug Environment: Hive 2.1.0 Subversion git://jcamachguezrMBP/Users/jcamachorodriguez/src/workspaces/hive/HIVE-release2/hive -r 9265bc24d75ac945bde9ce1a0999fddd8f2aae29 Compiled by jcamachorodriguez on Fri Jun 17 01:03:25 BST 2016 >From source with checksum 1f896b8fae57fbd29b047d6d67b75f3c Reporter: john zhao
When I use array_contains in where like this: WHERE array_contains(array(38461L), aduserid) I got an error: FAILED: SemanticException [Error 10016]: Line 3:35 Argument type mismatch 'aduserid': "int" expected at function ARRAY_CONTAINS, but "bigint" is found -- This message was sent by Atlassian JIRA (v6.3.4#6332)