[IMPALA-162] Inconsistent result from order by limit query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.6
• Fix Version/s: Impala 1.0.1
• Assignee: Nong Li
• Reporter: Alan Choi
• Created: 21/Mar/13 16:56
• Updated: 20/Dec/15 00:04
• Resolved: 06/May/13 22:24

Description

As reported in the user group, the following query has inconsistent result:

SELECT auto_discount / revenue as discount_percent FROM sales_fact_ order by discount_percent desc limit 10

Sometimes the result is

inf
inf
inf
inf
inf
inf
inf
inf
inf
0

and sometimes it is

inf
inf
inf
inf
inf
inf
inf
inf
inf
-nan

and occasionally it is

-nan
-nan
-nan
-nan
-nan
-nan
-nan
-nan
-nan
-nan

Will update the JIRA once we have the sample data and schema.