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

DESC formatted command displays sort scope twice

    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 this command:

      CREATE TABLE uniqdata_29(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';

      when I executed desc formatted uniqdata_29

      It shows the following output:

      0: jdbc:hive2://localhost:10000> desc formatted uniqdata_29;
      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      col_name data_type comment

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

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

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

      Here sort_scope is displayed twice

        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:

                Time Tracking

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