You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "ayushmantri (JIRA)" <ji...@apache.org> on 2017/06/30 14:39:00 UTC
[jira] [Updated] (CARBONDATA-1254) Post Alter Describe Formatted is
listing deleted column in Sort_Colums
[ https://issues.apache.org/jira/browse/CARBONDATA-1254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ayushmantri updated CARBONDATA-1254:
------------------------------------
Description:
0: jdbc:hive2://172.168.100.196:22550/default> create table t3 (id string,country string,population string ) stored by 'carbondata';
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.474 seconds)
0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| col_name | data_type | comment |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| id | string | DICTIONARY, KEY COLUMN |
| country | string | DICTIONARY, KEY COLUMN |
| population | string | DICTIONARY, KEY COLUMN |
| | | |
| ##Detailed Table Information | | |
| Database Name: | default | |
| Table Name: | t3 | |
| CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
| Table Block Size : | 1024 MB | |
| | | |
| ##Detailed Column property | | |
| ADAPTIVE | | |
| SORT_COLUMNS | id,country,population | |
| | | |
| ##Column Group Information | | |
+---------------------------------------+-------------------------------------------------------------------------
0: jdbc:hive2://172.168.100.196:22550/default> alter table t3 drop columns ( country);
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.652 seconds)
0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| col_name | data_type | comment |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| id | string | DICTIONARY, KEY COLUMN |
| population | string | DICTIONARY, KEY COLUMN |
| | | |
| ##Detailed Table Information | | |
| Database Name: | default | |
| Table Name: | t3 | |
| CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
| Table Block Size : | 1024 MB | |
| | | |
| ##Detailed Column property | | |
| ADAPTIVE | | |
| SORT_COLUMNS | id,country | |
| | | |
| ##Column Group Information | | |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
was:
0: jdbc:hive2://172.168.100.196:22550/default> create table t3 (id string,country string,population string ) stored by 'carbondata';
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.474 seconds)
0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| col_name | data_type | comment |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| id | string | DICTIONARY, KEY COLUMN |
| country | string | DICTIONARY, KEY COLUMN |
| population | string | DICTIONARY, KEY COLUMN |
| | | |
| ##Detailed Table Information | | |
| Database Name: | default | |
| Table Name: | t3 | |
| CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
| Table Block Size : | 1024 MB | |
| | | |
| ##Detailed Column property | | |
| ADAPTIVE | | |
| SORT_COLUMNS | id,country,population | |
| | | |
| ##Column Group Information | | |
+---------------------------------------+-------------------------------------------------------------------------0: jdbc:hive2://172.168.100.196:22550/default> alter table t3 drop columns ( country);
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.652 seconds)
0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| col_name | data_type | comment |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
| id | string | DICTIONARY, KEY COLUMN |
| population | string | DICTIONARY, KEY COLUMN |
| | | |
| ##Detailed Table Information | | |
| Database Name: | default | |
| Table Name: | t3 | |
| CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
| Table Block Size : | 1024 MB | |
| | | |
| ##Detailed Column property | | |
| ADAPTIVE | | |
| SORT_COLUMNS | id,{color:#d04437}*country *{color}| |
| | | |
| ##Column Group Information | | |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> Post Alter Describe Formatted is listing deleted column in Sort_Colums
> -----------------------------------------------------------------------
>
> Key: CARBONDATA-1254
> URL: https://issues.apache.org/jira/browse/CARBONDATA-1254
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.1.0
> Environment: Single Node setup
> Reporter: ayushmantri
> Priority: Minor
>
> 0: jdbc:hive2://172.168.100.196:22550/default> create table t3 (id string,country string,population string ) stored by 'carbondata';
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.474 seconds)
> 0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | col_name | data_type | comment |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | id | string | DICTIONARY, KEY COLUMN |
> | country | string | DICTIONARY, KEY COLUMN |
> | population | string | DICTIONARY, KEY COLUMN |
> | | | |
> | ##Detailed Table Information | | |
> | Database Name: | default | |
> | Table Name: | t3 | |
> | CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
> | Table Block Size : | 1024 MB | |
> | | | |
> | ##Detailed Column property | | |
> | ADAPTIVE | | |
> | SORT_COLUMNS | id,country,population | |
> | | | |
> | ##Column Group Information | | |
> +---------------------------------------+-------------------------------------------------------------------------
> 0: jdbc:hive2://172.168.100.196:22550/default> alter table t3 drop columns ( country);
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.652 seconds)
> 0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | col_name | data_type | comment |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | id | string | DICTIONARY, KEY COLUMN |
> | population | string | DICTIONARY, KEY COLUMN |
> | | | |
> | ##Detailed Table Information | | |
> | Database Name: | default | |
> | Table Name: | t3 | |
> | CARBON Store Path: | hdfs://hacluster/user/hive/warehouse/carbon.store | |
> | Table Block Size : | 1024 MB | |
> | | | |
> | ##Detailed Column property | | |
> | ADAPTIVE | | |
> | SORT_COLUMNS | id,country | |
> | | | |
> | ##Column Group Information | | |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)