Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
CPorrot1602485748
Contributor
Contributor

Sqoop Import - Hive Parquet Import Error - Unknown dataset URI pattern:

Good morning. I have an issue attempting to activate and test the direct hive import feature.

Talend version: 7.2

Cloudera version: 6.1.1

Hive version: 2.1.1-cdh6.1.1

Kerberos: yes

I am testing for a client an evolution of a sqoop import job. The client currently imports its data in Parquet file, using the Java API mode of the tSqoopImport component, and for the next step we want to create/fill the hive table at the same time.

Here is the error I get when executing the job:

```

[ERROR]: org.apache.sqoop.Sqoop - Got exception running Sqoop: org.kitesdk.data.DatasetNotFoundException: Unknown dataset URI pattern: dataset:hive:/dev_ingestion/test_import_direct

Check that JARs for hive datasets are on the classpath

```

The database and its table exist. I have tried everything I tried changing the parameters to put the database name into the hive.table parameter. I also tried to add the path to Cloudera's hadoop and hive libraries (/opt/cloudera/parcels/CDH/lib) to the classpath in the execution tab. Both had no effect.

You will find attached all the relevant screenshots

Thank you in advance for your answer and advice.

Labels (3)
1 Reply
Anonymous
Not applicable

Hi,

 

Thank you for writing to us. This is resolved in 7.3 version with the latest patch in place.

 

Thanks!