[DRILL-502] Avg function against decimal data returns incorrect result from drill

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Krystal
• Created: 11/Apr/14 21:17
• Updated: 13/Jun/14 16:32
• Resolved: 12/Jun/14 16:47

Description

Ran the following sql query:
0: jdbc:drill:schema=dfs> select avg(gpa) from dfs.`student`;
------------

EXPR$0

------------

1.999

------------
1 row selected (0.22 seconds)

The same query against the same dataset from oracle, postgres and impala returns value of 2.49826.

Here is the schema of the student table:
message pig_schema {
optional int32 rownum;
optional binary name;
optional int32 age;
optional double gpa;
optional int64 studentnum;
optional binary create_time;
}

The same avg function against int data types returns correct result.