Hi,
I have used the following code in DB2 configuration
{
"type": "jdbc",
"driver": "com.ibm.db2.jcc.DB2Driver",
"url": "jdbc:db2://localhost:50000/dbname",
"username": "username",
"password": "password",
"enabled": true
}
and copied the following jars in location
C:\apache-drill-1.5.0\jars\3rdpartydb2jcc.jardb2jcc_license_cisuz.jardb2jcc_license_cu.jar
but got the following error while executing SHOW DATABASE; command
C:\apache-drill-1.5.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Jul 08, 2016 5:58:44 PM org.glassfish.jersey.server.ApplicationHandler
initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
apache drill 1.5.0
"a little sql for your nosql"
0: jdbc:drill:zk=local> SHOW DATABASES;
Error: SYSTEM ERROR: NullPointerException: null key in entry:
null=org.apache.calcite.jdbc.SimpleCalciteSchema@c266fb9
[Error Id: b48c0738-a487-4eba-8745-dd934a84b07c on 9.124.209.27:31010]
(state=,code=0)
0: jdbc:drill:zk=local>
as the above implies got error while querying to the DB2 database.
Please help.
Thanks & Regards,Himan Jyoti Kalita
