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

DICTIONARY_EXCLUDE is not working with 'DATE' column

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0-incubating
    • Fix Version/s: 1.0.0-incubating
    • Component/s: core
    • Labels:
      None
    • Environment:
      Spark - 1.6 and Spark - 2.1

      Description

      I am trying to create a table with "DICTIONARY_EXCLUDE" and this property is not working for "DATE" Data Type.

      Query : CREATE TABLE uniqdata_date_dictionary (CUST_ID int,CUST_NAME string,ACTIVE_EMUI_VERSION string, DOB date, DOJ date, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES ("TABLE_BLOCKSIZE"= "256 MB","DICTIONARY_EXCLUDE"="DOB,DOJ");

      Expected Result : Table created.

      Actual Result : Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: DICTIONARY_EXCLUDE is unsupported for date data type column: dob (state=,code=0)

      But is is working fine, If I use 'TIMESTAMP' in place of 'DATE'.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mohdshahidkhan Mohammad Shahid Khan
                Reporter:
                anuragknoldus Anurag Srivastava
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m