You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Michael Smith (Jira)" <ji...@apache.org> on 2022/11/21 19:45:00 UTC

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

Michael Smith created IMPALA-11736:
--------------------------------------

             Summary: LOAD DATA statement with Ozone data can not load data from different bucket
                 Key: IMPALA-11736
                 URL: https://issues.apache.org/jira/browse/IMPALA-11736
             Project: IMPALA
          Issue Type: Sub-task
          Components: Backend
    Affects Versions: Impala 4.2.0
            Reporter: Michael Smith


Attempt to load data from one bucket into a table stored in another bucket and you get an error:
{code}
$ 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
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org