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

DESC FORMATTED command is displaying wrong comment for sort_scope as global_sort

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.3.0
    • Component/s: sql
    • Labels:
      None
    • Environment:
      spark2.1

      Description

      I created a table using :

      CREATE TABLE uniqdata_dict_sort(CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION string, DOB timestamp, DOJ timestamp, 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('DICTIONARY_INCLUDE'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1', 'SORT_SCOPE'='GLOBAL_SORT');

      When I executed the following query:
      desc formatted uniqdata_dict_sort

      It shows the following output:
      0: jdbc:hive2://localhost:10000> desc formatted uniqdata_dict_sort;
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      col_name data_type comment

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

      cust_id int DICTIONARY, KEY COLUMN,null
      cust_name string DICTIONARY, KEY COLUMN,null
      active_emui_version string DICTIONARY, KEY COLUMN,null
      dob timestamp KEY COLUMN,null
      doj timestamp KEY COLUMN,null
      bigint_column1 bigint DICTIONARY, KEY COLUMN,null
      bigint_column2 bigint DICTIONARY, KEY COLUMN,null
      decimal_column1 decimal(30,10) DICTIONARY, KEY COLUMN,null
      decimal_column2 decimal(36,10) DICTIONARY, KEY COLUMN,null
      double_column1 double DICTIONARY, KEY COLUMN,null
      double_column2 double DICTIONARY, KEY COLUMN,null
      integer_column1 int DICTIONARY, KEY COLUMN,null
           
      ##Detailed Table Information    
      Database Name 28dec  
      Table Name uniqdata_dict_sort  
      CARBON Store Path hdfs://localhost:54311/opt/carbonStore  
      Comment    
      Table Block Size 1024 MB  
      Table Data Size 56526  
      Table Index Size 1961  
      Last Update Time 1514535819178  
      SORT_SCOPE global_sort LOCAL_SORT
      Streaming false  
      SORT_SCOPE global_sort LOCAL_SORT
           
      ##Detailed Column property    
      ADAPTIVE    
      SORT_COLUMNS cust_id,cust_name,active_emui_version,dob,doj,bigint_column1,bigint_column2,decimal_column1,decimal_column2,double_column1,double_column2,integer_column1  

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      29 rows selected (0.369 seconds)

      Here the comment parameter for sort_scope is displaying wrong value

        Attachments

          Activity

            People

            • Assignee:
              anubhavtarar anubhav tarar
              Reporter:
              geetikagupta Geetika Gupta
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: