执行hive sql任务时报错:
FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://ShareSdkHadoop/user/hive/warehouse/dm_di_master.db. Error encountered near token 'TOK_TMP_FILE'
报错原因:操作线上库,当前的测试用户没有线上库的写入权限
解决办法:
调用shell脚本时,在hive前加上HADOOP_USER_NAME=dba 执行即可
如: HADOOP_USER_NAME=dba hive -v -e " sql “