[jira] [Commented] (HIVE-14871) Window PARTITION BY clause throw "ParseException line ?:? missing ) at '?' near"

["Makoto (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-14871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16585432#comment-16585432 ] 

Makoto commented on HIVE-14871:
-------------------------------

My customers tried to connect to Hive with SQL created by SPSS, but the same phenomenon occurred.
Is this a bug? Specification?

> Window PARTITION BY clause throw "ParseException line ?:? missing ) at '?' near"
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-14871
>                 URL: https://issues.apache.org/jira/browse/HIVE-14871
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.1.0
>            Reporter: Sahil Takiar
>            Priority: Major
>
> Queries such as:
> {code}
> SELECT
> LEAD(True, 54) OVER (PARTITION BY (a1.smallint_col_18) / (a1.decimal0101_col_25)) AS boolean_col
> FROM table_10 a1;
> {code}
> throw the exception:
> {code}
> Error: Error while compiling statement: FAILED: ParseException line 2:55 missing ) at '/' near ')'
> line 2:80 missing EOF at ')' near ')' (state=42000,code=40000)
> {code}
> While the following queries succeed:
> {code}
> SELECT
> LEAD(True, 54) OVER (PARTITION BY (a1.smallint_col_18 / a1.decimal0101_col_25)) AS boolean_col
> FROM table_10 a1;
> {code}
> {code}
> SELECT
> LEAD(True, 54) OVER (PARTITION BY (a1.smallint_col_18 / a1.decimal0101_col_25) ORDER BY (a1.smallint_col_18) / (a1.decimal0101_col_25) DESC) AS boolean_col
> FROM table_10 a1;
> {code}
> Seems to be a Hive bug, seems to be related to the extra parenthesis around the a1.smallint_col_18. Hive probably thinks that whatever is inside the () contains the entire clause for PARTITION BY and it fails to parse anything after that.
> My guess is that there is an issue with the Antlr code for the PARTITION BY clause.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)