You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Priyal Sachdeva (JIRA)" <ji...@apache.org> on 2017/05/08 12:37:04 UTC
[jira] [Updated] (CARBONDATA-1037) Select query is not returning
any data when we query on New Table after Alter Table rename operation
[ https://issues.apache.org/jira/browse/CARBONDATA-1037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Priyal Sachdeva updated CARBONDATA-1037:
----------------------------------------
Request participants: (was: )
Description:
create database Priyal;
Use Priyal;
Create Table
CREATE TABLE uniqdata111785 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='INTEGER_COLUMN1,CUST_ID');
Load Data into Table
LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
Select QUery Before ALter
select * from uniqdata111785 limit 10;
+----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
| CUST_ID | CUST_NAME | ACTIVE_EMUI_VERSION | DOB | DOJ | BIGINT_COLUMN1 | BIGINT_COLUMN2 | DECIMAL_COLUMN1 | DECIMAL_COLUMN2 | Double_COLUMN1 | Double_COLUMN2 | INTEGER_COLUMN1 |
+----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
| 10000 | CUST_NAME_01000 | ACTIVE_EMUI_VERSION_01000 | 1972-09-27 00:00:00.0 | 1972-09-27 00:00:00.0 | 123372037854 | -223372035854 | 12345679901.1234000000 | 22345679901.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1001 |
| 10001 | CUST_NAME_01001 | ACTIVE_EMUI_VERSION_01001 | 1972-09-28 00:00:00.0 | 1972-09-28 00:00:00.0 | 123372037855 | -223372035853 | 12345679902.1234000000 | 22345679902.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1002 |
| 10002 | CUST_NAME_01002 | ACTIVE_EMUI_VERSION_01002 | 1972-09-29 00:00:00.0 | 1972-09-29 00:00:00.0 | 123372037856 | -223372035852 | 12345679903.1234000000 | 22345679903.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1003 |
| 10003 | CUST_NAME_01003 | ACTIVE_EMUI_VERSION_01003 | 1972-09-30 00:00:00.0 | 1972-09-30 00:00:00.0 | 123372037857 | -223372035851 | 12345679904.1234000000 | 22345679904.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1004 |
| 10004 | CUST_NAME_01004 | ACTIVE_EMUI_VERSION_01004 | 1972-10-01 00:00:00.0 | 1972-10-01 00:00:00.0 | 123372037858 | -223372035850 | 12345679905.1234000000 | 22345679905.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1005 |
| 10005 | CUST_NAME_01005 | ACTIVE_EMUI_VERSION_01005 | 1972-10-02 00:00:00.0 | 1972-10-02 00:00:00.0 | 123372037859 | -223372035849 | 12345679906.1234000000 | 22345679906.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1006 |
| 10006 | CUST_NAME_01006 | ACTIVE_EMUI_VERSION_01006 | 1972-10-03 00:00:00.0 | 1972-10-03 00:00:00.0 | 123372037860 | -223372035848 | 12345679907.1234000000 | 22345679907.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1007 |
| 10007 | CUST_NAME_01007 | ACTIVE_EMUI_VERSION_01007 | 1972-10-04 00:00:00.0 | 1972-10-04 00:00:00.0 | 123372037861 | -223372035847 | 12345679908.1234000000 | 22345679908.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1008 |
| 10008 | CUST_NAME_01008 | ACTIVE_EMUI_VERSION_01008 | 1972-10-05 00:00:00.0 | 1972-10-05 00:00:00.0 | 123372037862 | -223372035846 | 12345679909.1234000000 | 22345679909.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1009 |
| 10009 | CUST_NAME_01009 | ACTIVE_EMUI_VERSION_01009 | 1972-10-06 00:00:00.0 | 1972-10-06 00:00:00.0 | 123372037863 | -223372035845 | 12345679910.1234000000 | 22345679910.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1010 |
+----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
Alter Table name
alter table Priyal.uniqdata111785 RENAME TO uniqdata1117856;
Select Query After Alter
0: jdbc:hive2://10.19.91.218:22550/default> select * from Priyal.uniqdata1117856 limit 100;
+----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
| CUST_ID | CUST_NAME | ACTIVE_EMUI_VERSION | DOB | DOJ | BIGINT_COLUMN1 | BIGINT_COLUMN2 | DECIMAL_COLUMN1 | DECIMAL_COLUMN2 | Double_COLUMN1 | Double_COLUMN2 | INTEGER_COLUMN1 |
+----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
+----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
Show tables;
0: jdbc:hive2://172.168.100.199:23040> show tables;
+-----------+------------------+--------------+--+
| database | tableName | isTemporary |
+-----------+------------------+--------------+--+
| priyal | uniqdata1117856 | false |
+-----------+------------------+--------------+--+
Expected Output: Query should return proper result set.
was:
create database Priyal;
Use Priyal;
Create Table
CREATE TABLE uniqdata111785 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='INTEGER_COLUMN1,CUST_ID');
Load Data into Table
LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
Alter Table name
alter table Priyal.uniqdata111785 RENAME TO uniqdata1117856;
Select query on Old Table
select * from Priyal.uniqdata111785 limit 10;
0: jdbc:hive2://172.168.100.199:23040> select * from Priyal.uniqdata111785 limit 10;
Error: java.lang.NullPointerException (state=,code=0)
Show tables;
0: jdbc:hive2://172.168.100.199:23040> show tables;
+-----------+------------------+--------------+--+
| database | tableName | isTemporary |
+-----------+------------------+--------------+--+
| priyal | uniqdata1117856 | false |
+-----------+------------------+--------------+--+
Expected Output: Table does not exist error message should come.
Summary: Select query is not returning any data when we query on New Table after Alter Table rename operation (was: Null pointer Exception is coming ,when we do select * from old table after Alter Table Rename Operation.)
> Select query is not returning any data when we query on New Table after Alter Table rename operation
> ----------------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-1037
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1037
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.1.0
> Environment: 3 node cluster SUSE 11 SP4
> Reporter: Priyal Sachdeva
> Fix For: NONE
>
> Attachments: show_tables.JPG
>
>
> create database Priyal;
> Use Priyal;
> Create Table
> CREATE TABLE uniqdata111785 (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES('DICTIONARY_INCLUDE'='INTEGER_COLUMN1,CUST_ID');
> Load Data into Table
> LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> LOAD DATA INPATH 'hdfs://hacluster/user/Priyal/2000_UniqData.csv' into table uniqdata111785 OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','BAD_RECORDS_LOGGER_ENABLE'='TRUE', 'BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1');
> Select QUery Before ALter
> select * from uniqdata111785 limit 10;
> +----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
> | CUST_ID | CUST_NAME | ACTIVE_EMUI_VERSION | DOB | DOJ | BIGINT_COLUMN1 | BIGINT_COLUMN2 | DECIMAL_COLUMN1 | DECIMAL_COLUMN2 | Double_COLUMN1 | Double_COLUMN2 | INTEGER_COLUMN1 |
> +----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
> | 10000 | CUST_NAME_01000 | ACTIVE_EMUI_VERSION_01000 | 1972-09-27 00:00:00.0 | 1972-09-27 00:00:00.0 | 123372037854 | -223372035854 | 12345679901.1234000000 | 22345679901.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1001 |
> | 10001 | CUST_NAME_01001 | ACTIVE_EMUI_VERSION_01001 | 1972-09-28 00:00:00.0 | 1972-09-28 00:00:00.0 | 123372037855 | -223372035853 | 12345679902.1234000000 | 22345679902.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1002 |
> | 10002 | CUST_NAME_01002 | ACTIVE_EMUI_VERSION_01002 | 1972-09-29 00:00:00.0 | 1972-09-29 00:00:00.0 | 123372037856 | -223372035852 | 12345679903.1234000000 | 22345679903.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1003 |
> | 10003 | CUST_NAME_01003 | ACTIVE_EMUI_VERSION_01003 | 1972-09-30 00:00:00.0 | 1972-09-30 00:00:00.0 | 123372037857 | -223372035851 | 12345679904.1234000000 | 22345679904.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1004 |
> | 10004 | CUST_NAME_01004 | ACTIVE_EMUI_VERSION_01004 | 1972-10-01 00:00:00.0 | 1972-10-01 00:00:00.0 | 123372037858 | -223372035850 | 12345679905.1234000000 | 22345679905.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1005 |
> | 10005 | CUST_NAME_01005 | ACTIVE_EMUI_VERSION_01005 | 1972-10-02 00:00:00.0 | 1972-10-02 00:00:00.0 | 123372037859 | -223372035849 | 12345679906.1234000000 | 22345679906.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1006 |
> | 10006 | CUST_NAME_01006 | ACTIVE_EMUI_VERSION_01006 | 1972-10-03 00:00:00.0 | 1972-10-03 00:00:00.0 | 123372037860 | -223372035848 | 12345679907.1234000000 | 22345679907.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1007 |
> | 10007 | CUST_NAME_01007 | ACTIVE_EMUI_VERSION_01007 | 1972-10-04 00:00:00.0 | 1972-10-04 00:00:00.0 | 123372037861 | -223372035847 | 12345679908.1234000000 | 22345679908.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1008 |
> | 10008 | CUST_NAME_01008 | ACTIVE_EMUI_VERSION_01008 | 1972-10-05 00:00:00.0 | 1972-10-05 00:00:00.0 | 123372037862 | -223372035846 | 12345679909.1234000000 | 22345679909.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1009 |
> | 10009 | CUST_NAME_01009 | ACTIVE_EMUI_VERSION_01009 | 1972-10-06 00:00:00.0 | 1972-10-06 00:00:00.0 | 123372037863 | -223372035845 | 12345679910.1234000000 | 22345679910.1234000000 | 1.12345674897976E10 | -1.12345674897976E10 | 1010 |
> +----------+------------------+----------------------------+------------------------+------------------------+-----------------+-----------------+-------------------------+-------------------------+----------------------+-----------------------+------------------+--+
> Alter Table name
> alter table Priyal.uniqdata111785 RENAME TO uniqdata1117856;
> Select Query After Alter
> 0: jdbc:hive2://10.19.91.218:22550/default> select * from Priyal.uniqdata1117856 limit 100;
> +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
> | CUST_ID | CUST_NAME | ACTIVE_EMUI_VERSION | DOB | DOJ | BIGINT_COLUMN1 | BIGINT_COLUMN2 | DECIMAL_COLUMN1 | DECIMAL_COLUMN2 | Double_COLUMN1 | Double_COLUMN2 | INTEGER_COLUMN1 |
> +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
> +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+
> Show tables;
> 0: jdbc:hive2://172.168.100.199:23040> show tables;
> +-----------+------------------+--------------+--+
> | database | tableName | isTemporary |
> +-----------+------------------+--------------+--+
> | priyal | uniqdata1117856 | false |
> +-----------+------------------+--------------+--+
> Expected Output: Query should return proper result set.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)