[ 
https://issues.apache.org/jira/browse/ATLAS-778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shwetha G S updated ATLAS-778:
------------------------------
    Fix Version/s:     (was: 0.7-incubating)

> ALTER TABLE TOUCH is not modelled
> ---------------------------------
>
>                 Key: ATLAS-778
>                 URL: https://issues.apache.org/jira/browse/ATLAS-778
>             Project: Atlas
>          Issue Type: Bug
>    Affects Versions: 0.7-incubating
>            Reporter: Ayub Khan
>
> ALTER TABLE TOUCH is not modelled.
> ALTER TABLE TOUCH changes metadata of hive table(like create time, 
> transient_lastDdlTime). No entity update message is sent to atlas when table 
> touch command is fired.
> {noformat}
> 0: jdbc:hive2://localhost:10000/default> describe formatted tg2;
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> |           col_name            |                            data_type        
>                     |        comment        |
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> | # col_name                    | data_type                                   
>                     | comment               |
> |                               | NULL                                        
>                     | NULL                  |
> | abc                           | string                                      
>                     |                       |
> |                               | NULL                                        
>                     | NULL                  |
> | # Detailed Table Information  | NULL                                        
>                     | NULL                  |
> | Database:                     | db2sdbxnpqone                               
>                     | NULL                  |
> | Owner:                        | apathan                                     
>                     | NULL                  |
> | CreateTime:                   | Wed May 11 23:19:55 IST 2016                
>                     | NULL                  |
> | LastAccessTime:               | UNKNOWN                                     
>                     | NULL                  |
> | Protect Mode:                 | None                                        
>                     | NULL                  |
> | Retention:                    | 0                                           
>                     | NULL                  |
> | Location:                     | 
> hdfs://localhost:9000/user/hive/warehouse/db2sdbxnpqone.db/tg2  | NULL        
>           |
> | Table Type:                   | MANAGED_TABLE                               
>                     | NULL                  |
> | Table Parameters:             | NULL                                        
>                     | NULL                  |
> |                               | transient_lastDdlTime                       
>                     | 1462988995            |
> |                               | NULL                                        
>                     | NULL                  |
> | # Storage Information         | NULL                                        
>                     | NULL                  |
> | SerDe Library:                | 
> org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe              | NULL        
>           |
> | InputFormat:                  | org.apache.hadoop.mapred.TextInputFormat    
>                     | NULL                  |
> | OutputFormat:                 | 
> org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat      | NULL        
>           |
> | Compressed:                   | No                                          
>                     | NULL                  |
> | Num Buckets:                  | -1                                          
>                     | NULL                  |
> | Bucket Columns:               | []                                          
>                     | NULL                  |
> | Sort Columns:                 | []                                          
>                     | NULL                  |
> | Storage Desc Params:          | NULL                                        
>                     | NULL                  |
> |                               | serialization.format                        
>                     | 1                     |
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> 26 rows selected (0.113 seconds)
> 0: jdbc:hive2://localhost:10000/default> alter table tg2 touch;
> No rows affected (0.173 seconds)
> 0: jdbc:hive2://localhost:10000/default> describe formatted tg2;
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> |           col_name            |                            data_type        
>                     |        comment        |
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> | # col_name                    | data_type                                   
>                     | comment               |
> |                               | NULL                                        
>                     | NULL                  |
> | abc                           | string                                      
>                     |                       |
> |                               | NULL                                        
>                     | NULL                  |
> | # Detailed Table Information  | NULL                                        
>                     | NULL                  |
> | Database:                     | db2sdbxnpqone                               
>                     | NULL                  |
> | Owner:                        | apathan                                     
>                     | NULL                  |
> | CreateTime:                   | Wed May 11 23:19:55 IST 2016                
>                     | NULL                  |
> | LastAccessTime:               | UNKNOWN                                     
>                     | NULL                  |
> | Protect Mode:                 | None                                        
>                     | NULL                  |
> | Retention:                    | 0                                           
>                     | NULL                  |
> | Location:                     | 
> hdfs://localhost:9000/user/hive/warehouse/db2sdbxnpqone.db/tg2  | NULL        
>           |
> | Table Type:                   | MANAGED_TABLE                               
>                     | NULL                  |
> | Table Parameters:             | NULL                                        
>                     | NULL                  |
> |                               | COLUMN_STATS_ACCURATE                       
>                     | false                 |
> |                               | numFiles                                    
>                     | 0                     |
> |                               | numRows                                     
>                     | -1                    |
> |                               | rawDataSize                                 
>                     | -1                    |
> |                               | totalSize                                   
>                     | 0                     |
> |                               | transient_lastDdlTime                       
>                     | 1462989060            |
> |                               | NULL                                        
>                     | NULL                  |
> | # Storage Information         | NULL                                        
>                     | NULL                  |
> | SerDe Library:                | 
> org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe              | NULL        
>           |
> | InputFormat:                  | org.apache.hadoop.mapred.TextInputFormat    
>                     | NULL                  |
> | OutputFormat:                 | 
> org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat      | NULL        
>           |
> | Compressed:                   | No                                          
>                     | NULL                  |
> | Num Buckets:                  | -1                                          
>                     | NULL                  |
> | Bucket Columns:               | []                                          
>                     | NULL                  |
> | Sort Columns:                 | []                                          
>                     | NULL                  |
> | Storage Desc Params:          | NULL                                        
>                     | NULL                  |
> |                               | serialization.format                        
>                     | 1                     |
> +-------------------------------+-----------------------------------------------------------------+-----------------------+--+
> 31 rows selected (0.105 seconds)
> 0: jdbc:hive2://localhost:10000/default>
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to