Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-2763

Create table with partition and no_inverted_index on long_string column is not blocked

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.4.1
    • 1.4.1
    • data-query
    • None
    • Spark 2.1, 2.2

    Description

      Steps :

      1. 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.

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              chetdb Chetan Bhat
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: