Priyal Sachdeva created CARBONDATA-1037:
-------------------------------------------
Summary: Null pointer Exception is coming ,when we do select * from old 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: Null_Pointer_exception-Error.JPG, 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');
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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)