Symptom
When executing sqoop import command against SAP IQ , you could get the following error:
$ sqoop import --verbose --driver "com.sybase.jdbc4.jdbc.SybDriver" --connect jdbc:sybase:Tds:<host>:<port> --username <user> -P <password> --query "select * from test where \$CONDITIONS" --target-dir /tmp/sybtst -m 1
Warning: /opt/cloudera/parcels/CDH-5.10.1-1.cdh5.10.1.p0.10/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.10.1
DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager).
Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.
INFO manager.SqlManager: Using default fetchSize of 1000
INFO tool.CodeGenTool: Beginning code generation
DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : select * from test where (1 = 0)
DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
Exception in thread "main" java.lang.UnsatisfiedLinkError: no dbjdbc16 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)
at java.lang.Runtime.loadLibrary0(Runtime.java:849)
at java.lang.System.loadLibrary(System.java:1088)
at sybase.jdbc4.sqlanywhere.IDriver.try_load(IDriver.java:483)
at sybase.jdbc4.sqlanywhere.IDriver.<clinit>(IDriver.java:421)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at java.lang.Class.newInstance(Class.java:374)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:373)
....
Read more...
Environment
- SAP IQ 16 SP 11 PL 07
- Hadoop 2.6.0 (Cloudera)
- Sqoop 1.4.6
Product
SAP IQ 16.0
Keywords
Hive , Sybase , hortonworks , cloudera , import , export , list-files , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview