hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3928) import data to local files shoud keep the same sort order as the SELECT statement
Date Wed, 23 Jan 2013 05:18:12 GMT
caofangkun created HIVE-3928:
--------------------------------

             Summary: import data to local files shoud keep the same sort  order as the SELECT
statement
                 Key: HIVE-3928
                 URL: https://issues.apache.org/jira/browse/HIVE-3928
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.9.0
            Reporter: caofangkun
            Priority: Minor


Step one:
hive (default)> select * from src;
	35
48	
100	100
Step two: outpt data is sorted by src.key DESC
hive (default)> SELECT src.key, sum(substr(src.value,5))  FROM src GROUP BY src.key limit
5; 
	0.0
100	0.0
48	0.0

Step three :
hive (default)> insert overwrite local directory '/tmp/a' SELECT src.key, sum(substr(src.value,5))
 FROM src GROUP BY src.key limit 5 ;

the data in the output file is sored by src.key ASC ,but why?
hive (default)> !cat /tmp/a/000000_0;
48  0.0
100 0.0
    0.0



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message