[
https://issues.apache.org/jira/browse/CARBONDATA-1037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Kapoor reassigned CARBONDATA-1037:
----------------------------------------
Assignee: Kunal Kapoor
> 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
> Assignee: Kunal Kapoor
> 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 priyal.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)
