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