[jira] [Updated] (CARBONDATA-1037) Select query is not returning any data when we query on New Table after Alter Table rename operation
Locked
[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: ---------------------------------------- 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 on Old Table 0: jdbc:hive2://172.168.100.199:23040> 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 Table rename operation. 0: jdbc:hive2://172.168.100.199:23040> select * from priyal1.uniqdata1117856 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 | +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+ +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+ Show tables; 0: jdbc:hive2://172.168.100.199:23040> show tables; +-----------+------------------+--------------+--+ | database | tableName | isTemporary | +-----------+------------------+--------------+--+ | priyal | uniqdata1117856 | false | +-----------+------------------+--------------+--+ Expected Output: Select 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; 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. > 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 on Old Table > 0: jdbc:hive2://172.168.100.199:23040> 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 Table rename operation. > 0: jdbc:hive2://172.168.100.199:23040> select * from priyal1.uniqdata1117856 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 | > +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+ > +----------+------------+----------------------+------+------+-----------------+-----------------+------------------+------------------+-----------------+-----------------+------------------+--+ > Show tables; > 0: jdbc:hive2://172.168.100.199:23040> show tables; > +-----------+------------------+--------------+--+ > | database | tableName | isTemporary | > +-----------+------------------+--------------+--+ > | priyal | uniqdata1117856 | false | > +-----------+------------------+--------------+--+ > Expected Output: Select Query should return proper result set. -- This message was sent by Atlassian JIRA (v6.3.15#6346) |
«
Return to Apache CarbonData JIRA issues
|
1 view|%1 views
| Free forum by Nabble | Edit this page |