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

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.0
    • Component/s: core
    • Labels:
      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

            • Assignee:
              Unassigned
              Reporter:
              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