Posted by
Akash R Nilugal (Jira) on
Jun 30, 2017; 2:38pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-1254-Post-Alter-Describe-Formatted-is-listing-deleted-column-in-Sort-Colums-tp16891.html
ayushmantri created CARBONDATA-1254:
---------------------------------------
Summary: 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,{color:#d04437}*country *{color}| |
| | | |
| ##Column Group Information | | |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)