hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zhaolong (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-23586) load data overwrite into bucket table failed
Date Tue, 02 Jun 2020 01:15:00 GMT

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

zhaolong updated HIVE-23586:
----------------------------
    Description: 
load data overwrite into bucket table is failed if filename is not like 000000_0, but insert
new data in the table.

 

for example:

CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string) PARTITIONED BY
(logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row format delimited fields terminated
by '|' STORED AS textfile;
 load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2 partition
(logdate='20200508');
 !image-2020-06-01-21-40-21-726.png!
 load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2 partition
(logdate='20200508');// should overwrite but insert new data
 !image-2020-06-01-21-41-28-732.png!

  was:
load data overwrite into bucket table is failed if filename is not like 000000_0, but insert
new data in the table.

 

for example:


CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string) PARTITIONED BY
(logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row format delimited fields terminated
by '|' STORED AS textfile;
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2 partition
(logdate='20200508');
!image-2020-06-01-21-40-21-726.png!
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2 partition
(logdate='20200508');// should overwrite buf insert new data
!image-2020-06-01-21-41-28-732.png!


> load data overwrite into bucket table failed
> --------------------------------------------
>
>                 Key: HIVE-23586
>                 URL: https://issues.apache.org/jira/browse/HIVE-23586
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0, 3.1.2
>            Reporter: zhaolong
>            Priority: Critical
>         Attachments: image-2020-06-01-21-40-21-726.png, image-2020-06-01-21-41-28-732.png
>
>
> load data overwrite into bucket table is failed if filename is not like 000000_0, but
insert new data in the table.
>  
> for example:
> CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string) PARTITIONED
BY (logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row format delimited fields terminated
by '|' STORED AS textfile;
>  load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2
partition (logdate='20200508');
>  !image-2020-06-01-21-40-21-726.png!
>  load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2
partition (logdate='20200508');// should overwrite but insert new data
>  !image-2020-06-01-21-41-28-732.png!



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message