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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!