Anbu Cheeralan created HIVE-16620:
-------------------------------------
Summary: 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.
```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`
```
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
