hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Owen O'Malley (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (HIVE-15113) SHOW CREATE TABLE on skewed table returns statement without skew definition
Date Wed, 26 Jul 2017 00:03:04 GMT

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

Owen O'Malley closed HIVE-15113.
--------------------------------

> 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
>            Assignee: Aihua Xu
>             Fix For: 2.2.0
>
>         Attachments: HIVE-15113.1.patch, HIVE-15113.2.patch
>
>
> 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.4.14#64029)

Mime
View raw message