[HIVE-3928] import data to local files shoud keep the same sort order as the SELECT statement

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: caofangkun
• Created: 23/Jan/13 05:16
• Updated: 23/Jan/13 05:16

Description

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