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

Post Alter Describe Formatted is listing deleted column in Sort_Colums

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.1.1
    • Component/s: data-query
    • Labels:
      None
    • Environment:
      Single Node setup

      Description

      0: jdbc:hive2://172.168.100.196:22550/default> create table t3 (id string,country string,population string ) stored by 'carbondata';
      ---------+

      Result

      ---------+
      ---------+
      No rows selected (0.474 seconds)
      0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      col_name data_type comment

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      id string DICTIONARY, KEY COLUMN
      country string DICTIONARY, KEY COLUMN
      population string DICTIONARY, KEY COLUMN
           
      ##Detailed Table Information    
      Database Name: default  
      Table Name: t3  
      CARBON Store Path: hdfs://hacluster/user/hive/warehouse/carbon.store  
      Table Block Size : 1024 MB  
           
      ##Detailed Column property    
      ADAPTIVE    
      SORT_COLUMNS id,country,population  
           
      ##Column Group Information    

      --------------------------------------------------------------------------------------------------------------

      0: jdbc:hive2://172.168.100.196:22550/default> alter table t3 drop columns ( country);
      ---------+

      Result

      ---------+
      ---------+
      No rows selected (0.652 seconds)
      0: jdbc:hive2://172.168.100.196:22550/default> desc formatted t3;
      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      col_name data_type comment

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      id string DICTIONARY, KEY COLUMN
      population string DICTIONARY, KEY COLUMN
           
      ##Detailed Table Information    
      Database Name: default  
      Table Name: t3  
      CARBON Store Path: hdfs://hacluster/user/hive/warehouse/carbon.store  
      Table Block Size : 1024 MB  
           
      ##Detailed Column property    
      ADAPTIVE    
      SORT_COLUMNS id,country  
           
      ##Column Group Information    

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ayush ayushmantri
                Reporter:
                ayush ayushmantri
              • 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 - 2h
                  2h