[SQOOP-3453] Kite sdk issue with sqoop version 1.4.7

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.7
• Component/s: connectors/oracle
• External issue URL: https://issues.apache.org/jira/browse/SQOOP-3187
• Assignee: Unassigned
• Reporter: Saiyam Agarwal
• Created: 30/Oct/19 07:17
• Updated: 04/Nov/19 12:09

Description

 

Trying to run sqoop import command with sqoop version 1.4.7 and kite sdk version 1.1.0.

/usr/lib/sqoop/bin/sqoop import -Dmapreduce.map.memory.mb=2048 -Dmapred.fairscheduler.pool=sqoop-coop -Doraoop.timestamp.string=false --connect jdbc:oracle:thin:@abc.net:1521/coopdvm --username abc --password-file s3://abc/user/app.ab.core_etl/credentials/coopdvm_coop --target-dir 's3://abc/dev/temp/TEST_MEIS/T1/master/timestamp=20191017103331' --direct --as-parquetfile -z --map-column-java ID=Integer --query "select ID from TEST_MEIS.T1 where \$CONDITIONS" -m 1 --verbose

Failing with below issue:

App > 19/10/23 05:58:04 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.Launcher$AppClassLoader@642c39d2
App > 19/10/23 05:58:04 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@abc:1521/coopdvm/coop
App > 19/10/23 05:58:04 ERROR sqoop.Sqoop: Got exception running Sqoop: org.kitesdk.data.DatasetNotFoundException: Unknown dataset URI pattern: dataset:s3://abc/dev/temp/TEST_MEIS/T1/master/timestamp=20191017103331
App > Check that JARs for s3 datasets are on the classpath
App > org.kitesdk.data.DatasetNotFoundException: Unknown dataset URI pattern: dataset:s3://abc/dev/temp/TEST_MEIS/T1/master/timestamp=20191017103331
App > Check that JARs for s3 datasets are on the classpath
App > at org.kitesdk.data.spi.Registration.lookupDatasetUri(Registration.java:128)
App > at org.kitesdk.data.Datasets.exists(Datasets.java:624)
App > at org.kitesdk.data.Datasets.exists(Datasets.java:646)
App > at org.apache.sqoop.mapreduce.ParquetJob.configureImportJob(ParquetJob.java:118)

 Can anyone help in debugging or suggest any workaround?

 

 

Issue Links

• is duplicated by: SQOOP-3455 Sqoop job fails while importing to S3 as Parquet