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 15:45:00 UTC
[jira] [Assigned] (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 reassigned CARBONDATA-1254:
---------------------------------------
Assignee: ayushmantri
> 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
> Assignee: 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)