You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "caofangkun (JIRA)" <ji...@apache.org> on 2013/01/23 06:18:12 UTC
[jira] [Created] (HIVE-3928) import data to local files shoud keep
the same sort order as the SELECT statement
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