You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Aihua Xu (JIRA)" <ji...@apache.org> on 2016/05/19 18:25:12 UTC
[jira] [Updated] (HIVE-13792) Show create table should not show
stats info in the table properties
[ https://issues.apache.org/jira/browse/HIVE-13792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aihua Xu updated HIVE-13792:
----------------------------
Description:
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}
was:
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. And also the format for TBLPROPERTIES is not well formed.
{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}
> 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
>
> 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)