[CARBONDATA-3308] TimeSeries Datamap creation using select groupby from Bloom Datamap Fails with Null Pointer exception

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.5.2
• Component/s: data-query
• Environment: Spark 2.1
• Assignee: Unassigned
• Reporter: Chetan Bhat
• Created: 07/Mar/19 08:41
• Updated: 07/Mar/19 08:41

Description

Issue :

TimeSeries Datamap creation using select groupby from Bloom Datamap Fails with Null Pointer exception.

 Steps :

0: jdbc:hive2://10.18.98.225:22550/default> create table if not exists timeseries__datamap_test (id int,name string,salary float,dob date,doj timestamp,bonus double,status boolean,marks decimal(10,3)) STORED BY 'org.apache.carbondata.format';

---------+

Result

---------+

---------+

No rows selected (1.676 seconds)

0: jdbc:hive2://10.18.98.225:22550/default> create datamap dm_timeseries_bloom_test on table timeseries__datamap_test using 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS'='doj', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');

---------+

Result

---------+

---------+

No rows selected (0.603 seconds)

0: jdbc:hive2://10.18.98.225:22550/default> CREATE DATAMAP dm_datamap_timeseries1 ON TABLE timeseries_datamap_test USING "timeseries" DMPROPERTIES ('event_time'='doj','day_granularity'='1') AS SELECT  name, id,count(id),doj FROM timeseries_datamap_test GROUP BY name,id,doj;

Error: java.lang.NullPointerException (state=,code=0)