[ https://issues.apache.org/jira/browse/HIVE-21066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Lavati reassigned HIVE-21066: ----------------------------------- Assignee: David Lavati (was: David Lavati) > unexpected SemanticException > ---------------------------- > > Key: HIVE-21066 > URL: https://issues.apache.org/jira/browse/HIVE-21066 > Project: Hive > Issue Type: Bug > Affects Versions: 2.3.0 > Reporter: Ravi Shetye > Assignee: David Lavati > Priority: Major > > *WORKS* > {noformat} > 0: jdbc:hive2://localhost:10000> select c1=c1 from (select "a" as c1) t1; > +-------+ > | _c0 | > +-------+ > | true | > +-------+ > {noformat} > {noformat} > 0: jdbc:hive2://localhost:10000> select c1 in ("a","b") a from (select "a" c1 > )t1 ; > +-------+ > | a | > +-------+ > | true | > +-------+ > {noformat} > {noformat} > 0: jdbc:hive2://localhost:10000> select true in (true) a from (select "a" c1 > )t1; > +-------+ > | a | > +-------+ > | true | > +-------+ > {noformat} > *DOES NOT WORK* > {noformat} > 0: jdbc:hive2://localhost:10000> select c1=c1 in (true) a from (select "a" c1 > )t1 ; > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments 'true': The arguments for IN should be the same type! Types > are: {string IN (boolean)} (state=42000,code=40000) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)