You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Akash R Nilugal (Jira)" <ji...@apache.org> on 2019/08/20 07:05:00 UTC
[jira] [Updated] (CARBONDATA-3494) Nullpointer exception in case of
drop table
[ 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)