[DRILL-1033] Tpch query09 fails with a verification failure

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 19/Jun/14 21:31
• Updated: 17/Apr/15 21:27
• Resolved: 15/Jul/14 18:54

Description

git.commit.id.abbrev=894037a
Build # : 26145

This query fails for a volume of 1 GB and 10GB with verification issues.
The total number of records returned match the expected number. However the contents do not match. Let me know if you want more information about the data/baselines used

Sample variation for 10GB volume :

*********************ACTUAL*********************
CHINA 1993 3928782.7530000005
IRAN 1994 3530144.0313999974
CHINA 1994 3456309.568900001
IRAN 1995 4076698.578900001
IRAQ 1992 3731546.0713999993
CHINA 1995 3369649.071999999
INDIA 1998 2491042.2729000007
IRAN 1996 4062439.517499999
IRAQ 1993 4298698.9248
CHINA 1996 4112591.2585999994

***************************EXPECTED*********************
IRAN 1995.0 3.483284650333E8 (1 time(s))
ARGENTINA 1994.0 3.549701593013E8 (1 time(s))
BRAZIL 1998.0 2.069814244412E8 (1 time(s))
FRANCE 1994.0 3.50087824318E8 (1 time(s))
UNITED KINGDOM 1998.0 2.035614862279E8 (1 time(s))
EGYPT 1992.0 3.490843079761E8 (1 time(s))
MOZAMBIQUE 1993.0 3.385115303458E8 (1 time(s))
IRAN 1993.0 3.484653974794E8 (1 time(s))
FRANCE 1995.0 3.491320397015E8 (1 time(s))
INDONESIA 1997.0 3.399028270854E8 (1 time(s))