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

Long string column displayed as string in describe formatted

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.4.1
    • 1.4.1
    • data-query
    • None

    Description

      Steps :

      User creates a table with long string column and executes the describe formatted table command.

      0: jdbc:hive2://10.18.98.101:22550/default> create table t2(c1 string, c2 string) stored by 'carbondata' tblproperties('long_string_columns' = 'c2');
      ---------+

      Result

      ---------+
      ---------+
      No rows selected (3.034 seconds)

      0: jdbc:hive2://10.18.98.101:22550/default> desc formatted t2;

      Actual Output : The describe formatted displays the c2 column as string instead of long string.

      0: jdbc:hive2://10.18.98.101:22550/default> desc formatted t2;
      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      col_name data_type comment

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

      c1 string KEY COLUMN,null

      | c2 | string | KEY COLUMN,null |

           
      ##Detailed Table Information    
      Database Name default  
      Table Name t2  
      CARBON Store Path hdfs://hacluster/user/hive/warehouse/carbon.store/default/t2  
      Comment    
      Table Block Size 1024 MB  
      Table Data Size 0  
      Table Index Size 0  
      Last Update Time 0  
      SORT_SCOPE LOCAL_SORT LOCAL_SORT
      CACHE_LEVEL BLOCK  
      Streaming false  
      Local Dictionary Enabled true  
      Local Dictionary Threshold 10000  
      Local Dictionary Include c1,c2  
           
      ##Detailed Column property    
      ADAPTIVE    
      SORT_COLUMNS c1  

      -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      22 rows selected (2.847 seconds)

       

      Expected Output : The describe formatted should display the c2 column as long string.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              chetdb Chetan Bhat
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: