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

TalendSolutionExpert — Fri, 09 Feb 2024 18:22:49 GMT

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.

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

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

Problem Description

Root Cause

Solution