[ https://issues.apache.org/jira/browse/CARBONDATA-2028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
kumar vishal resolved CARBONDATA-2028. -------------------------------------- Resolution: Fixed Fix Version/s: 1.3.0 > Select Query failed with preagg having timeseries and normal agg table > together > ------------------------------------------------------------------------------- > > Key: CARBONDATA-2028 > URL: https://issues.apache.org/jira/browse/CARBONDATA-2028 > Project: CarbonData > Issue Type: Bug > Reporter: Babulal > Assignee: Babulal > Priority: Major > Fix For: 1.3.0 > > Time Spent: 2h 10m > Remaining Estimate: 0h > > sql("drop table if exists maintabletime") > sql("create table maintabletime(year int,month int,name string,salary > int,dob timestamp) stored by 'carbondata' > tblproperties('sort_scope'='Global_sort','table_blocksize'='23','sort_columns'='month,year,name')") > sql("insert into maintabletime select 10,11,'babu',12,'2014-01-01 00:00:00'") > sql("create datamap agg0 on table maintabletime using 'preaggregate' as > select dob,name from maintabletime group by dob,name") > sql("create datamap agg1 on table maintabletime using 'preaggregate' > DMPROPERTIES ('timeseries.eventTime'='dob', > 'timeseries.hierarchy'='hour=1,day=1,month=1,year=1') as select dob,name from > maintabletime group by dob,name") > val df = sql("select timeseries(dob,'year') from maintabletime group by > timeseries(dob,'year')") > > > *Exception* > Exception in thread "main" org.apache.spark.sql.AnalysisException: Column > does not exists in Pre Aggregate table; > at > org.apache.spark.sql.hive.CarbonPreAggregateQueryRules.getChildAttributeReference(CarbonPreAggregateRules.scala:719) > at > org.apache.spark.sql.hive.CarbonPreAggregateQueryRules$$anonfun$19$$anonfun$4.applyOrElse(CarbonPreAggregateRules.scala:855) -- This message was sent by Atlassian JIRA (v7.6.3#76005)