Member since
03-07-2017
2
Posts
0
Kudos Received
0
Solutions
03-08-2017
07:31 PM
Thank u so much!! It's working now.
... View more
03-07-2017
10:34 PM
Hi all, I'm using Impala Official docker image "cloudera/quickstart". I can upload a TEXT-formatted file to a HDFS location. However, when I executed LOAD DATA command to do data migration, I received following error: [Simba]ImpalaJDBCDriver ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Unable to LOAD DATA from hdfs://quickstart.cloudera:8020/user/customer.tbl.1 because Impala does not have WRITE permissions on its parent directory hdfs://quickstart.cloudera:8020/user ), Query: load data inpath '/user/customer.tbl.1' overwrite into table my_table. [SQL State=HY000, DB Errorcode=500051] My sql is : load data inpath '/user/customer.tbl.1' overwrite into table my_table Is there anyone know what is going on? Thanks for any help!
... View more
Labels:
- Labels:
-
Apache Impala
-
HDFS