Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Test Queries
CREATE TABLE temp (top ARRAY<STRING>); insert into temp values(array(cast('true' as VARCHAR(10)))); select array_contains(top,cast(true as VARCHAR(10))) from temp;
Exception
org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Argument type mismatch ''TRUE'': "varchar(10)" expected at function ARRAY_CONTAINS, but "string" is found at org.apache.hadoop.hive.ql.parse.type.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1473)
As per Allowed Implicit Conversions String and varchar are convertible. So we can modify this check and allow varchar <-> String conversion