[
https://issues.apache.org/jira/browse/HIVE-21066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravi Shetye updated HIVE-21066:
-------------------------------
Affects Version/s: (was: 3.0.0)
2.3.0
> 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
> 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)
