[HIVE-13792] Show create table should not show stats info in the table properties

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.3.0
• Component/s: Query Planning
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 19/May/16 17:30
• Updated: 21/Jul/17 17:45
• Resolved: 29/May/16 00:43

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.

PREHOOK: query: SHOW CREATE TABLE hbase_table_1_like
PREHOOK: type: SHOW_CREATETABLE
PREHOOK: Input: default@hbase_table_1_like
POSTHOOK: query: SHOW CREATE TABLE hbase_table_1_like
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@hbase_table_1_like

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',