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

Altering the value of sort columns and unsetting the longStringColumns results in deletion of columns from table schema.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.1.0
    • core
    • None

    Description

      When we change the value of sortColumns by alter table query and then run unset for longStringColumn. it removes some columns from table schema.

      CREATE TABLE if not exists $longStringTable(id INT, name STRING, description STRING, address STRING, note STRING) STORED AS carbondataTBLPROPERTIES('sort_columns'='id,name');

      alter table long_string_table set tblproperties('sort_columns'='ID','sort_scope'='no_sort');

      alter table long_string_table unset tblproperties('long_string_columns');

      these queries will remove Name column from the schema because initially it was a sortColumn and after that value of sortColumns is changed.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            Karan980 Karan
            Votes:
            0 Vote for this issue
            Watchers:
            1 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 - 5h
                5h