[CARBONDATA-150] Aggregate function with sub query using Order by is not working

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-incubating
• Fix Version/s: 0.1.0-incubating
• Component/s: data-query
• Environment: SUSE11SP3, standalone application with Spark 1.6.2 and Hadoop 2.7.2 version
• Assignee: Ravindra Pesala
• Reporter: Krishna Reddy
• Created: 08/Aug/16 08:13
• Updated: 17/Aug/16 10:56
• Resolved: 17/Aug/16 10:56

Description

Aggregate function with sub query using Order by is not working

1. Create a table
2. Load the data
3. query as below
select Min(imei) from (select imei from table1 order by imei) t;

Error: org.apache.spark.SparkException: Job aborted due to stage failure: Task 7 in stage 312.0 failed 4 times, most recent failure: Lost task 7.3 in stage 312.0 (TID 7266, BLR1000007847): java.lang.ClassCastException