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) |
Free forum by Nabble | Edit this page |