When executing a Job with a tHiveLoad component, the following error is observed in the Job log:
Error while compiling statement: FAILED: SemanticException [Error 10028]: Line 1:17 Path is not legal ''/user/talend/loader/X_CUSTOMER_FRMK_POC_1000_INSERT'': Move from: hdfs://HOSTNAME: 8020/user/talend/loader/X_CUSTOMER_FRMK_POC_1000_INSERT to: hdfs://ttspoc/user/hive/warehouse/giw_framework.db/talend_hive_test1 is not valid. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict.
Root Cause
The values for the Hadoop properties: default.fs.name and hive.metastore.warehouse.dir in the tHiveConnection component are incorrect.
Solution
In the tHiveConnection component, set the Hadoop properties default.fs.name and hive.metastore.warehouse.dir with the correct values. You can find the correct values in the *-site.xml files of the Hadoop cluster.
