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

CPorrot1602485748 — Sat, 16 Nov 2024 01:18:31 GMT

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.

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

Anonymous — Mon, 13 Jun 2022 12:57:39 GMT

Hi,

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

Thanks!

topic Sqoop Import - Hive Parquet Import Error - Unknown dataset URI pattern: in Talend Studio

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

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