You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Wojciech Meler (JIRA)" <ji...@apache.org> on 2016/11/02 15:12:58 UTC

[jira] [Created] (HIVE-15113) SHOW CREATE TABLE on skewed table returns statement without skew definition

Wojciech Meler created HIVE-15113:
-------------------------------------

             Summary: SHOW CREATE TABLE on skewed table returns statement without skew definition
                 Key: HIVE-15113
                 URL: https://issues.apache.org/jira/browse/HIVE-15113
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.1.0
            Reporter: Wojciech Meler


CREATE TABLE IF NOT EXISTS testskew (key int, value STRING)
SKEWED BY (key) ON (1,5,6) STORED AS DIRECTORIES
STORED AS ORC;

SHOW CREATE TABLE testskew;

CREATE TABLE `testskew`(
2	  `key` int, 
3	  `value` string)
4	ROW FORMAT SERDE 
5	  'org.apache.hadoop.hive.ql.io.orc.OrcSerde' 
6	STORED AS INPUTFORMAT 
7	  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' 
8	OUTPUTFORMAT 
9	  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
10	LOCATION
11	  'hdfs://nameservice1/user/hive/warehouse/private_wmeler.db/testskew'
12	TBLPROPERTIES (
13	  'COLUMN_STATS_ACCURATE'='true', 
14	  'numFiles'='4', 
15	  'numRows'='19', 
16	  'rawDataSize'='1736', 
17	  'totalSize'='1184', 
18	  'transient_lastDdlTime'='1478098814')



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