[jira] [Created] (HIVE-16620) show create table on partitioned view does not show partitioned on statement

["Anbu Cheeralan (JIRA)" <ji...@apache.org>]

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)