[
https://issues.apache.org/jira/browse/HIVE-13165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15168418#comment-15168418
]
Gopal V commented on HIVE-13165:
--------------------------------
FYI, what I meant was that without that optimization, even the withOrderBy will
fail.
> resultset which query sql add 'order by' or 'sort by' return is different
> from not add it
> ------------------------------------------------------------------------------------------
>
> Key: HIVE-13165
> URL: https://issues.apache.org/jira/browse/HIVE-13165
> Project: Hive
> Issue Type: Bug
> Components: Clients
> Affects Versions: 1.2.1
> Environment: hadoop 2.5.2 hive 1.2.1
> Reporter: chillon_m
> Assignee: Vaibhav Gumashta
> Attachments: Hql not order.png, Hql with order.png
>
>
> resultset which I execute query sql added 'order by' or 'sort by' is
> different from not add it .size of resultset and value of row is returned is
> different.
> with order:
> 0: jdbc:hive2://namenode:10000/default> with temp as (select msgType as
> type,id,msgData from messages where Num='41433141' and erNum='99841977')
> 0: jdbc:hive2://namenode:10000/default> select * from temp where id=163437
> order by id;
> INFO : Number of reduce tasks determined at compile time: 1
> INFO : In order to change the average load for a reducer (in bytes):
> INFO : set hive.exec.reducers.bytes.per.reducer=<number>
> INFO : In order to limit the maximum number of reducers:
> INFO : set hive.exec.reducers.max=<number>
> INFO : In order to set a constant number of reducers:
> INFO : set mapreduce.job.reduces=<number>
> WARN : Hadoop command-line option parsing not performed. Implement the Tool
> interface and execute your application with ToolRunner to remedy this.
> INFO : number of splits:1
> INFO : Submitting tokens for job: job_1456383638304_0008
> INFO : The url to track the job:
> http://namenode:8088/proxy/application_1456383638304_0008/
> INFO : Starting Job = job_1456383638304_0008, Tracking URL =
> http://namenode:8088/proxy/application_1456383638304_0008/
> INFO : Kill Command = /home/bigdata/hadoop-runtime/hadoop-2.5.2/bin/hadoop
> job -kill job_1456383638304_0008
> INFO : Hadoop job information for Stage-1: number of mappers: 0; number of
> reducers: 0
> INFO : 2016-02-26 11:06:55,493 Stage-1 map = 0%, reduce = 0%
> INFO : 2016-02-26 11:07:01,710 Stage-1 map = 100%, reduce = 0%
> INFO : 2016-02-26 11:07:04,815 Stage-1 map = 100%, reduce = 100%
> INFO : Ended Job = job_1456383638304_0008
> +------------+----------+---------------+--+
> | temp.type | temp.id | temp.msgdata |
> +------------+----------+---------------+--+
> | -1000 | 163437 | we come: |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> | NULL | NULL | NULL |
> +------------+----------+---------------+--+
> 11 rows selected (16.191 seconds)
> without order:
> 0: jdbc:hive2://namenode:10000/default> with temp as (select msgType as
> type,id,msgData from messages where Num='41433141' and erNum='99841977')
> 0: jdbc:hive2://namenode:10000/default> select * from temp where id=163437;
> +------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
> | temp.type | temp.id |
> temp.msgdata
> |
> +------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
> | -1000 | 163437 | we come:
> sadferqgb gtrhyj hytjyjuk nhmuykiluil
> hthnynmkukmhrj, |
> +------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
> 1 row selected (18.245 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
