hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anbu Cheeralan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-16620) show create table on partitioned view does not show partitioned on statement
Date Tue, 09 May 2017 15:53:04 GMT

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

Mime
View raw message