You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Liang Chen (JIRA)" <ji...@apache.org> on 2017/05/09 02:30:04 UTC
[jira] [Resolved] (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 ]
Liang Chen resolved CARBONDATA-1037.
------------------------------------
Resolution: Fixed
Fix Version/s: (was: NONE)
1.1.0
> 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: 1.1.0
>
> Attachments: show_tables.JPG
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 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)