You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@atlas.apache.org by "Shwetha G S (JIRA)" <ji...@apache.org> on 2016/06/20 09:28:05 UTC

[jira] [Updated] (ATLAS-778) ALTER TABLE TOUCH is not modelled

     [ 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)