hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13792) Show create table should not show stats info in the table properties
Date Thu, 19 May 2016 18:36:12 GMT

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

Aihua Xu updated HIVE-13792:
----------------------------
    Status: Patch Available  (was: Open)

Attached the patch-1: the patch will filter out the stats parameters from 'show create table'
command output since those should not be part of the create table parameters.

> Show create table should not show stats info in the table properties
> --------------------------------------------------------------------
>
>                 Key: HIVE-13792
>                 URL: https://issues.apache.org/jira/browse/HIVE-13792
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Planning
>    Affects Versions: 2.1.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-13792.1.patch
>
>
> From the test org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver_hbase_queries
failure, we are printing table stats in show create table parameters. This info should be
skipped since it would be incorrect when you just copy them to create a table. 
> {noformat}
> CREATE EXTERNAL TABLE `hbase_table_1_like`(
>   `key` int COMMENT 'It is a column key',
>   `value` string COMMENT 'It is the column string value')
> ROW FORMAT SERDE
>   'org.apache.hadoop.hive.hbase.HBaseSerDe'
> STORED BY
>   'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES (
>   'hbase.columns.mapping'='cf:string',
>   'serialization.format'='1')
> TBLPROPERTIES (
>   'COLUMN_STATS_ACCURATE'='{\"BASIC_STATS\":\"true\"}',
>   'hbase.table.name'='hbase_table_0',
>   'numFiles'='0',
>   'numRows'='0',
>   'rawDataSize'='0',
>   'totalSize'='0',
> {noformat}



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

Mime
View raw message