hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravi Shetye (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21066) unexpected SemanticException
Date Mon, 24 Dec 2018 22:14:00 GMT

     [ 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)

Mime
View raw message