[
https://issues.apache.org/jira/browse/HIVE-16620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anbu Cheeralan updated HIVE-16620:
----------------------------------
Summary: show create on partitioned view does not show "partitioned on"
statement (was: show create table on partitioned view does not show
partitioned on statement)
> show create on partitioned view does not show "partitioned on" statement
> ------------------------------------------------------------------------
>
> Key: HIVE-16620
> URL: https://issues.apache.org/jira/browse/HIVE-16620
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 2.1.0
> Reporter: Anbu Cheeralan
> Priority: Minor
>
> show create on partitioned view does not show the partitioned on clause.
> Here is an example.
> {code:borderStyle=solid}
> use default
> create table t1 (a int) partitioned by (b int)
> insert into t1 partition(b) values (5, 1)
> select * from t1
> create or replace view v1 partitioned on (b) as select * from t1
> explain dependency select * from v1 where b=1
> show create table v1
> {code}
> This results in
> {code:borderStyle=solid}
> CREATE VIEW `v1` AS select `t1`.`a`, `t1`.`b` from `default`.`t1`
> {code}
> I am expecting this to show
> {code:borderStyle=solid}
> create view v1 partitioned on (b) as select `t1`.`a`, `t1`.`b` from
> `default`.`t1`
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
