You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tez.apache.org by "Jonathan Eagles (JIRA)" <ji...@apache.org> on 2019/03/05 17:12:00 UTC

[jira] [Resolved] (TEZ-4046) insert overwrite table without data

     [ https://issues.apache.org/jira/browse/TEZ-4046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Eagles resolved TEZ-4046.
----------------------------------
    Resolution: Cannot Reproduce

[~jipeng], closing this issue. Please direct questions as directed to the proper user lists.

> insert overwrite table without data
> -----------------------------------
>
>                 Key: TEZ-4046
>                 URL: https://issues.apache.org/jira/browse/TEZ-4046
>             Project: Apache Tez
>          Issue Type: Bug
>    Affects Versions: 0.8.4
>            Reporter: zengjipeng
>            Priority: Major
>
> use hive on tez.
> execute as below statement, the target table tmp.zjp_b have no data.
>  
> {code:java}
> create table tmp.zjp_a(a string,b string);
> insert into tmp.zjp_a select "a1","1,2,3";
> create table tmp.zjp_b(name string,age string) partitioned by(dt string);
> insert overwrite table tmp.zjp_b partition(dt='2019-02-26')
> select a,age from tmp.zjp_a lateral view explode(split(b,",")) tb as age where age='1'
> union all
> select a,age from tmp.zjp_a lateral view explode(split(b,",")) tb as age where age='2';
> {code}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)