Executing a Job using a tHiveLoad component, results in a 'SemanticException [Error 10028]' error

Problem Description

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.

Version history
Revision #:
7 of 7
Last update:
‎04-13-2019 12:36 PM
Updated by: