I am trying to build pipeline using STREAMSETS which would be pushing records into HDFS and then hive Query will execute .
I running query load data inpath '/path/in/hdfc' into table table_name .getting the exception..
Failed to execute queries. Details : Failed to execute query 'load data inpath
'/tmp/out/*' into table smsc_data_main_nw_success'. Reason: java.sql.SQLException:
Error while processing statement: FAILED: Execution Error,
return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask.
Access denied: Unable to move source hdfs://hostname:8020/tmp/out/file_name.done to
Permission denied by sticky bit: user=anonymous,
I tried to these steps
hadoop fs -chmod g+w /user/hive/warehouse/test.db
but still facing the same issue.