[IMPALA-9844] Ozone support for load data inpath

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.0.0
• Epic Color: ghx-label-12
• Assignee: Sahil Takiar
• Reporter: Sahil Takiar
• Created: 09/Jun/20 22:43
• Updated: 17/Jun/20 23:54
• Resolved: 17/Jun/20 23:54

Description

Currently, attempts to run load data inpath against Ozone tables fail:

default> CREATE EXTERNAL TABLE o3_tab1 (id INT, col_1 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE LOCATION 'o3fs://bucket1.volume1.ozone1/o3_tab1';
Query: CREATE EXTERNAL TABLE o3_tab1 (id INT, col_1 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE LOCATION 'o3fs://bucket1.volume1.ozone1/o3_tab1'
+-------------------------+
| summary                 |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.36s
default> load data inpath 'o3fs://bucket1.volume1.ozone1/file' into table ozone_test_table2;
Query: load data inpath 'o3fs://bucket1.volume1.ozone1/file' into table ozone_test_table2
ERROR: AnalysisException: INPATH location 'o3fs://bucket1.volume1.ozone1/file' must point to an HDFS, S3A, ADL or ABFS filesystem.