[HIVE-15012] array_contains type error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved

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

• Assignee: Unassigned
• Reporter: john zhao
• Created: 19/Oct/16 06:53
• Updated: 19/Oct/16 06:53

Description

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