[
https://issues.apache.org/jira/browse/HIVE-23586?focusedWorklogId=439935&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-439935
]
ASF GitHub Bot logged work on HIVE-23586:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 02/Jun/20 06:47
Start Date: 02/Jun/20 06:47
Worklog Time Spent: 10m
Work Description: fsilent opened a new pull request #1048:
URL: https://github.com/apache/hive/pull/1048
load data overwrite into bucket table is failed if filename is not like
000000_0, but insert new data in the table. this is fixed by modify insert sql
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 439935)
Remaining Estimate: 0h
Time Spent: 10m
> 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
> Assignee: zhaolong
> Priority: Critical
> Attachments: HIVE-23586.01.patch, image-2020-06-01-21-40-21-726.png,
> image-2020-06-01-21-41-28-732.png
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
