hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13165) resultset which query sql add 'order by' or 'sort by' return is different from not add it
Date Fri, 26 Feb 2016 04:24:18 GMT

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

Gopal V commented on HIVE-13165:
--------------------------------

[~chillon_m]: that looks like a simple new line error (the conversion=none should trigger
it for both cases).

If turning off FetchTask reproduces the issue for both cases, then {{set hive.query.result.fileformat=
SequenceFile;}} (default in hive-2.1.0). 

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

Mime
View raw message