[KYLIN-509] Order by on fact table not works correctly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v0.7.1
• Component/s: Query Engine
• Labels: github-import
• Assignee: liyang
• Reporter: Luke Han
• Created: 09/Jan/15 16:24
• Updated: 27/Apr/15 08:11
• Resolved: 27/Apr/15 08:11

Description

User reported one bug:
https://groups.google.com/forum/#!topic/kylin-olap/L_Z_0nYWUYo

1, normal sql
select * from nameid
CONTENT_ID CONTENT_NAME COUNT__
1002 ane
1001 joe
1000 tom
1000 tom1
1000 tom2

2, problem sql
select * from nameid order by content_id
CONTENT_ID CONTENT_NAME COUNT__
1000 tom2
1000 tom2
1000 tom2
1000 tom2
1000 tom2

---------------- Imported from GitHub ----------------
Url: https://github.com/KylinOLAP/Kylin/issues/363
Created by: lukehan
Labels: bug,
Assignee: binmahone
Created at: Wed Jan 07 23:24:15 CST 2015
State: open