tHiveLoad giving Error Failed execution return code 1 from MoveTask
I have Talend connecting to Hive and creating a table for me. I am trying to use tHiveLoad to load a Textfile output from a relational DB to my Hive Table. tHiveLoad gives me: Java.sql.SQLexecution: Error while processing statement: Failed: Execution Error: return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask The Hiveserver2 is running as user hive. For security reasons I am not allowed to log in as the hive User. My cluster log id has been granted privileges to create DB and tables. The Hive log shows: Unable to move source hdfs://blah/blah.txt to destination hdfs://foo/foo.txt The directory for the destination is: 775 and owned by hive:hive. Again, I am not allowed to connect with the hive account. Is there a way to make tHiveLoad work ? Thanks.
Was able to change the file permissions for source to 777 and get the destination directory to be 777 as well. Still getting this error. What I get in the log is: Exception in component tHiveLoad_1 org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException : Line 1:17 Path is not legal ''/tmp/AccountExternalTmp.txt'': Move from: hdfs://actualHostName/tmp/AccountExternalTmp.txt to: hdfs://nameservice1/user/hive/warehouse/salesforce_grabenstein.db/account_external is not valid. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict. The nameservice1 is not part of my job. I have put in the actual host name for that in all places I could find. Thanks.