You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "xuchuanyin (JIRA)" <ji...@apache.org> on 2018/07/20 07:10:00 UTC
[jira] [Commented] (CARBONDATA-2762) Long string column displayed
as string in describe formatted
[ https://issues.apache.org/jira/browse/CARBONDATA-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16550318#comment-16550318 ]
xuchuanyin commented on CARBONDATA-2762:
----------------------------------------
Hi，we will display the long_string_columns property in desc
> Long string column displayed as string in describe formatted
> ------------------------------------------------------------
>
> Key: CARBONDATA-2762
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2762
> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.4.1
> Reporter: Chetan Bhat
> Priority: Minor
>
> Steps :
> User creates a table with long string column and executes the describe formatted table command.
> 0: jdbc:hive2://10.18.98.101:22550/default> create table t2(c1 string, c2 string) stored by 'carbondata' tblproperties('long_string_columns' = 'c2');
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (3.034 seconds)
> 0: jdbc:hive2://10.18.98.101:22550/default> desc formatted t2;
> Actual Output : The describe formatted displays the c2 column as string instead of long string.
> 0: jdbc:hive2://10.18.98.101:22550/default> desc formatted t2;
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | col_name | data_type | comment |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | c1 | string | KEY COLUMN,null |
> *| c2 | string | KEY COLUMN,null |*
> | | | |
> | ##Detailed Table Information | | |
> | Database Name | default | |
> | Table Name | t2 | |
> | CARBON Store Path | hdfs://hacluster/user/hive/warehouse/carbon.store/default/t2 | |
> | Comment | | |
> | Table Block Size | 1024 MB | |
> | Table Data Size | 0 | |
> | Table Index Size | 0 | |
> | Last Update Time | 0 | |
> | SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
> | CACHE_LEVEL | BLOCK | |
> | Streaming | false | |
> | Local Dictionary Enabled | true | |
> | Local Dictionary Threshold | 10000 | |
> | Local Dictionary Include | c1,c2 | |
> | | | |
> | ##Detailed Column property | | |
> | ADAPTIVE | | |
> | SORT_COLUMNS | c1 | |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> 22 rows selected (2.847 seconds)
>
> Expected Output : The describe formatted should display the c2 column as long string.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)