hive-issues mailing list archives

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

     [ 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:
users@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)

Mime
View raw message