[IMPALA-4861] READ_WRITE warning thrown for source URI on CREATE TABLE LIKE PARQUET

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.10.0
• Component/s: Frontend
• Labels: newbie
• Assignee: Pranay Singh
• Reporter: Greg Rahn
• Created: 01/Feb/17 22:20
• Updated: 15/Aug/17 21:04
• Resolved: 15/Aug/17 21:04

Description

Impala is throwing a READ_WRITE warning on the source path when doing CREATE TABLE LIKE PARQUET. Clearly this is a bunk warning as only READ is necessary on the source URI.

$ hdfs dfs -ls /user/grahn
drwxr-xr-x   - grahn  supergroup          0 2017-02-01 14:07 /user/grahn/t

$ hdfs dfs -cp /tmp/bd4c4faf1485bea9-9c684da200000000_1368173239_data.0.parq /user/grahn/t

[impala:21000] > create table ctas
               > like parquet
               > '/user/grahn/t/bd4c4faf1485bea9-9c684da200000000_1368173239_data.0.parq';

WARNINGS: Impala does not have READ_WRITE access to path 'hdfs://impala:8020/user/grahn/t'

[impala:21000] > desc ctas;
Query: describe ctas
+------+-----------+-----------------------------+
| name | type      | comment                     |
+------+-----------+-----------------------------+
| _c0  | timestamp | Inferred from Parquet file. |
+------+-----------+-----------------------------+