atlas-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shwetha G S (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ATLAS-778) ALTER TABLE TOUCH is not modelled
Date Mon, 20 Jun 2016 09:44:05 GMT

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

Shwetha G S updated ATLAS-778:
------------------------------
    Issue Type: Sub-task  (was: Bug)
        Parent: ATLAS-492

> ALTER TABLE TOUCH is not modelled
> ---------------------------------
>
>                 Key: ATLAS-778
>                 URL: https://issues.apache.org/jira/browse/ATLAS-778
>             Project: Atlas
>          Issue Type: Sub-task
>    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)

Mime
View raw message