[jira] [Updated] (HIVE-27688) hive MoveTask cannot show the correct exception message
[
https://issues.apache.org/jira/browse/HIVE-27688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-27688:
--
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
> 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-1 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)
[jira] [Updated] (HIVE-27688) hive MoveTask cannot show the correct exception message
[
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-1 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-1 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-1 as
> the file is not owned by hive and load data is also not ran as hive{code}
>
>
>
--
This message was
[jira] [Updated] (HIVE-27688) hive MoveTask cannot show the correct exception message
[
https://issues.apache.org/jira/browse/HIVE-27688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liang yu updated HIVE-27688:
Description:
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-1 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.
!image-2023-09-13-17-40-02-981.png!
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.
!image-2023-09-13-17-39-27-864.png!
> 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
>
>
> 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-1 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)
[jira] [Updated] (HIVE-27688) hive MoveTask cannot show the correct exception message
[ https://issues.apache.org/jira/browse/HIVE-27688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liang yu updated HIVE-27688: Attachment: image-2023-09-13-17-40-02-981.png image-2023-09-13-17-39-27-864.png image-2023-09-13-17-38-58-508.png Description: 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. !image-2023-09-13-17-40-02-981.png! 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. !image-2023-09-13-17-39-27-864.png! 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. 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. > 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 > > > 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. > !image-2023-09-13-17-40-02-981.png! > > 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. > !image-2023-09-13-17-39-27-864.png! -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27688) hive MoveTask cannot show the correct exception message
[ https://issues.apache.org/jira/browse/HIVE-27688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liang yu updated HIVE-27688: Attachment: (was: image-2023-09-13-17-38-58-508.png) > 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 > > > 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. > !image-2023-09-13-17-40-02-981.png! > > 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. > !image-2023-09-13-17-39-27-864.png! -- This message was sent by Atlassian Jira (v8.20.10#820010)
