[jira] [Updated] (CARBONDATA-1254) Post Alter Describe Formatted is listing deleted column in Sort_Colums
Locked
[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) |
«
Return to Apache CarbonData JIRA issues
|
1 view|%1 views
| Free forum by Nabble | Edit this page |