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.