[
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)
