[IMPALA-11736] LOAD DATA statement with Ozone data can not load data from different bucket

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.2.0
• Fix Version/s: Impala 4.3.0
• Component/s: Frontend
• Labels: ozone
• Epic Link: Impala Ozone Phase 2
• Epic Color: ghx-label-12
• Assignee: Michael Smith
• Reporter: Michael Smith
• Created: 21/Nov/22 19:44
• Updated: 13/Dec/22 21:55
• Resolved: 07/Dec/22 15:54

Description

Attempt to load data from one bucket into a table stored in another bucket and you get an error:

$ ozone sh bucket create impala/tmp
$ ozone sh bucket create impala/foo
$ ozone fs -cp /impala/test-warehouse/tpch.nation/nation.tbl /impala/tmp
$ impala-shell
> create table nation like tpch.nation location 'ofs://localhost:9862/impala/foo/nation';
Query: create table nation like tpch.nation location 'ofs://localhost:9862/impala/foo/nation'
+-------------------------+
| summary                 |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.14s
> load data inpath 'ofs://localhost:9862/impala/tmp/nation.tbl' into table nation;
Query: load data inpath 'ofs://localhost:9862/impala/tmp/nation.tbl' into table nation
ERROR: IOException: Cannot rename a key to a different bucket

Issue Links

• causes: IMPALA-11794 TestLoadDataExternal.test_load is flaky