[jira] [Updated] (CARBONDATA-3494) Nullpointer exception in case of drop table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Updated] (CARBONDATA-3494) Nullpointer exception in case of drop table

Akash R Nilugal (Jira)

     [ https://issues.apache.org/jira/browse/CARBONDATA-3494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akash R Nilugal updated CARBONDATA-3494:
----------------------------------------
    Description:
Drop table is failing with nullpointer in below scenario with datamap



CREATE TABLE datamap_test (id int,name string,salary float,dob date)STORED BY 'carbondata' TBLPROPERTIES('SORT_COLUMNS'='id','table_page_size_inmb'='1');
CREATE DATAMAP dm_datamap_test2 ON TABLE datamap_test USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'salary,name', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
show datamap on table datamap_test;
CREATE TABLE datamap_test_1 (id int,name string,salary float,dob date)STORED BY 'carbondata' TBLPROPERTIES('SORT_COLUMNS'='id');
CREATE DATAMAP dm_datamap_test_1_2 ON TABLE datamap_test_1 USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'salary,name', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
CREATE DATAMAP dm_datamap_test3 ON TABLE datamap_test_1 USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'dob', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
show datamap on table datamap_test_1;
LOAD DATA INPATH 'hdfs://hacluster/chetan/datamap_test.csv' into table datamap_test_1 OPTIONS('DELIMITER'=',', 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='id,name,salary,dob');
explain select * from datamap_test_1 where name='NAME1';
explain select * from datamap_test_1 where id=1;
select * from datamap_test_1 where dob='1988-01-12';
drop table if exists datamap_test;
drop table if exists datamap_test_1;


  was:
Drop table is failing with nullpointer in below scenario with datamap




> Nullpointer exception in case of drop table
> -------------------------------------------
>
>                 Key: CARBONDATA-3494
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3494
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Akash R Nilugal
>            Assignee: Akash R Nilugal
>            Priority: Major
>
> Drop table is failing with nullpointer in below scenario with datamap
> CREATE TABLE datamap_test (id int,name string,salary float,dob date)STORED BY 'carbondata' TBLPROPERTIES('SORT_COLUMNS'='id','table_page_size_inmb'='1');
> CREATE DATAMAP dm_datamap_test2 ON TABLE datamap_test USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'salary,name', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
> show datamap on table datamap_test;
> CREATE TABLE datamap_test_1 (id int,name string,salary float,dob date)STORED BY 'carbondata' TBLPROPERTIES('SORT_COLUMNS'='id');
> CREATE DATAMAP dm_datamap_test_1_2 ON TABLE datamap_test_1 USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'salary,name', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
> CREATE DATAMAP dm_datamap_test3 ON TABLE datamap_test_1 USING 'bloomfilter' DMPROPERTIES ('INDEX_COLUMNS' = 'dob', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true');
> show datamap on table datamap_test_1;
> LOAD DATA INPATH 'hdfs://hacluster/chetan/datamap_test.csv' into table datamap_test_1 OPTIONS('DELIMITER'=',', 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='id,name,salary,dob');
> explain select * from datamap_test_1 where name='NAME1';
> explain select * from datamap_test_1 where id=1;
> select * from datamap_test_1 where dob='1988-01-12';
> drop table if exists datamap_test;
> drop table if exists datamap_test_1;



--
This message was sent by Atlassian Jira
(v8.3.2#803003)