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/08/06 08:20:00 UTC

[jira] [Resolved] (CARBONDATA-2763) Create table with partition and no_inverted_index on long_string column is not blocked

     [ https://issues.apache.org/jira/browse/CARBONDATA-2763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

xuchuanyin resolved CARBONDATA-2763.
------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.4.1

> Create table with partition and no_inverted_index on long_string column is not blocked
> --------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-2763
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2763
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>    Affects Versions: 1.4.1
>         Environment: Spark 2.1, 2.2
>            Reporter: Chetan Bhat
>            Priority: Minor
>             Fix For: 1.4.1
>
>
> Steps :
>  # Create table with partition using long_string column 
>  CREATE TABLE local_no_inverted_index(id int, name string, description string,address string, note string) STORED BY 'org.apache.carbondata.format' tblproperties('no_inverted_index'='note','long_string_columns'='note');
>  2. Create table with no_inverted_index 
>   CREATE TABLE local1_partition(id int,name string, description string,address string)  partitioned by (note string) STORED BY 'org.apache.carbondata.format' tblproperties('long_string_columns'='note');
>  
> Actual Output : The Create table with partition and no_inverted_index on long_string column is successful.
> 0: jdbc:hive2://10.18.98.101:22550/default> CREATE TABLE local_no_inverted_index(id int, name string, description string,address string, note string) STORED BY 'org.apache.carbondata.format' tblproperties('no_inverted_index'='note','long_string_columns'='note');
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (2.604 seconds)
> 0: jdbc:hive2://10.18.98.101:22550/default> CREATE TABLE local1_partition(id int,name string, description string,address string) partitioned by (note string) STORED BY 'org.apache.carbondata.format' tblproperties('long_string_columns'='note');
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (1.989 seconds)
> Expected Output - The Create table with partition and no_inverted_index on long_string column should be blocked.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)