[
https://issues.apache.org/jira/browse/HIVE-27688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liang yu updated HIVE-27688:
----------------------------
Description:
I am using hive.version=3.1.3; hadoop.version=3.3.4.
Setting hive.load.data.owner to hive, and I used user ubd_by to execute sql.
When I try to insert *overwrite* to an {*}existing table partition{*}, I get
the exception that: Unable to move source /path/to/source to destination
/path/to/dest, which is a very regular error message, gives me no helpful
information.
{code:java}
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.Movelask.Unable to move source
hdfs://xl/user/ubd master/ubd_b_dwa.
db/dwa_m_user/month_id=xxx/prov_id=xx/.staging to destination
hdfs://xl/user/ubd master/ubd_b_dwa.
db/dwa_m_user/month_id=xxx/prov_id=xx/.staging {code}
But when I try to insert *into* an {*}existing table partition{*}, I get the
exception that: Unable to move source /path/to/source to destination
/path/to/dest as the file is not owned by hive and load data is also not ran as
hive. which gives me a very helpful error message that I should change the
hive.load.data.owner to hive.
{code:java}
FAILED: Execution Error, return code l from org.
apache.hadoop.hive.ql.metadata.HiveException: org.
apache.hadoop.hive.gl.exec.Movelask: Load Data failed for hdfs://xl/user/ubd
master/ubd_b_dwa. db/dwa_m_user/month_id=xxx/prov_id=xx/
hive-staging hive 2023-09-13 17-34-31 302 5892190500368248766-1/-ext-10000 as
the file is not owned by hive and load data is also not ran as hive{code}
was:
Setting hive.load.data.owner to hive.
When I try to insert *overwrite* to an {*}existing table partition{*}, I get
the exception that: Unable to move source /path/to/source to destination
/path/to/dest, which is a very regular error message, gives me no helpful
information.
{code:java}
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.Movelask.Unable to move source
hdfs://xl/user/ubd master/ubd_b_dwa.
db/dwa_m_user/month_id=xxx/prov_id=xx/.staging to destination
hdfs://xl/user/ubd master/ubd_b_dwa.
db/dwa_m_user/month_id=xxx/prov_id=xx/.staging {code}
But when I try to insert *into* an {*}existing table partition{*}, I get the
exception that: Unable to move source /path/to/source to destination
/path/to/dest as the file is not owned by hive and load data is also not ran as
hive. which gives me a very helpful error message that I should change the
hive.load.data.owner to hive.
{code:java}
FAILED: Execution Error, return code l from org.
apache.hadoop.hive.ql.metadata.HiveException: org.
apache.hadoop.hive.gl.exec.Movelask: Load Data failed for hdfs://xl/user/ubd
master/ubd_b_dwa. db/dwa_m_user/month_id=xxx/prov_id=xx/
hive-staging hive 2023-09-13 17-34-31 302 5892190500368248766-1/-ext-10000 as
the file is not owned by hive and load data is also not ran as hive{code}
> hive MoveTask cannot show the correct exception message
> -------------------------------------------------------
>
> Key: HIVE-27688
> URL: https://issues.apache.org/jira/browse/HIVE-27688
> Project: Hive
> Issue Type: Bug
> Reporter: liang yu
> Assignee: liang yu
> Priority: Major
> Attachments: image-2023-09-13-17-39-27-864.png,
> image-2023-09-13-17-40-02-981.png
>
>
> I am using hive.version=3.1.3; hadoop.version=3.3.4.
> Setting hive.load.data.owner to hive, and I used user ubd_by to execute sql.
> When I try to insert *overwrite* to an {*}existing table partition{*}, I get
> the exception that: Unable to move source /path/to/source to destination
> /path/to/dest, which is a very regular error message, gives me no helpful
> information.
>
> {code:java}
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.Movelask.Unable to move source
> hdfs://xl/user/ubd master/ubd_b_dwa.
> db/dwa_m_user/month_id=xxx/prov_id=xx/.staging to destination
> hdfs://xl/user/ubd master/ubd_b_dwa.
> db/dwa_m_user/month_id=xxx/prov_id=xx/.staging {code}
>
> But when I try to insert *into* an {*}existing table partition{*}, I get the
> exception that: Unable to move source /path/to/source to destination
> /path/to/dest as the file is not owned by hive and load data is also not ran
> as hive. which gives me a very helpful error message that I should change the
> hive.load.data.owner to hive.
>
> {code:java}
> FAILED: Execution Error, return code l from org.
> apache.hadoop.hive.ql.metadata.HiveException: org.
> apache.hadoop.hive.gl.exec.Movelask: Load Data failed for hdfs://xl/user/ubd
> master/ubd_b_dwa. db/dwa_m_user/month_id=xxx/prov_id=xx/
> hive-staging hive 2023-09-13 17-34-31 302 5892190500368248766-1/-ext-10000 as
> the file is not owned by hive and load data is also not ran as hive{code}
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
