[ https://issues.apache.org/jira/browse/HIVE-16620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anbu Cheeralan updated HIVE-16620: ---------------------------------- Description: 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} was: show create on partitioned view does not show the partitioned on clause. Here is an example. ```SQL 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 ``` This results in ``` CREATE VIEW `v1` AS select `t1`.`a`, `t1`.`b` from `default`.`t1` ``` I am expecting this to show create view v1 partitioned on (b) as select `t1`.`a`, `t1`.`b` from `default`.`t1` ``` > show create table 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)