hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krisztian Kasa (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-22321) Setting default nulls last does not take effect when order direction is specified
Date Thu, 10 Oct 2019 12:21:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Krisztian Kasa updated HIVE-22321:
----------------------------------
    Description: 
{code:java}
SET hive.default.nulls.last=true;
SELECT * FROM t_test ORDER BY col1 ASC;
{code}
{code:java}
POSTHOOK: query: SELECT * FROM t_test ORDER BY col1 ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_test
#### A masked pattern was here ####
NULL
NULL
NULL
NULL
3
5
5
{code}
[https://github.com/apache/hive/blob/cb83da943c8919e2ab3751244de5c2879c8fda1d/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g#L2510]

 

cc. [~jcamachorodriguez]

  was:
{code}
SET hive.default.nulls.last=true;
SELECT * FROM t_test ORDER BY col1 ASC;
{code}
{code}
POSTHOOK: query: SELECT * FROM t_test ORDER BY col1 ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_test
#### A masked pattern was here ####
NULL
NULL
NULL
NULL
3
5
5
{code}

https://github.com/apache/hive/blob/cb83da943c8919e2ab3751244de5c2879c8fda1d/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g#L2510


> Setting default nulls last does not take effect when order direction is specified
> ---------------------------------------------------------------------------------
>
>                 Key: HIVE-22321
>                 URL: https://issues.apache.org/jira/browse/HIVE-22321
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>
> {code:java}
> SET hive.default.nulls.last=true;
> SELECT * FROM t_test ORDER BY col1 ASC;
> {code}
> {code:java}
> POSTHOOK: query: SELECT * FROM t_test ORDER BY col1 ASC
> POSTHOOK: type: QUERY
> POSTHOOK: Input: default@t_test
> #### A masked pattern was here ####
> NULL
> NULL
> NULL
> NULL
> 3
> 5
> 5
> {code}
> [https://github.com/apache/hive/blob/cb83da943c8919e2ab3751244de5c2879c8fda1d/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g#L2510]
>  
> cc. [~jcamachorodriguez]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message