carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ayushmantri (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-1254) Post Alter Describe Formatted is listing deleted column in Sort_Colums
Date Fri, 30 Jun 2017 14:38:00 GMT
ayushmantri created CARBONDATA-1254:
---------------------------------------

             Summary: Post Alter Describe Formatted is listing deleted column in Sort_Colums

                 Key: CARBONDATA-1254
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1254
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.1.0
         Environment: Single Node setup
            Reporter: ayushmantri
            Priority: Minor


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,{color:#d04437}*country                     
                                                  *{color}|                              
                                            |
|                                       |                                                
                                  |                                                      
                    |
| ##Column Group Information            |                                                
                                  |                                                      
                    |
+---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message