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)
