在使用 Cloudera 的 Impala 官方 Docker 镜像时，执行 LOAD DATA 命令迁移数据可能会遇到权限问题。错误提示 Impala 对 HDFS 路径没有写权限。解决方案包括更改文件的所有者/组，或将数据移动到 /user/hive/warehouse 目录，并确保该路径对 hive/impala 用户具有读写权限。
Issue:
While you are using Impala Official docker image "cloudera/quickstart", following exception might be thrown while executing LOAD DATA command to do data migration.
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]
Reason: (https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-SQL-Unable-to-LOAD-DATA-from-HDFS-path-due-to-WRITE/m-p/5194
最低0.47元/天 解锁文章
1134
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
