All Apps and Add-ons
Highlighted

Apache Drill JDBC connection

New Member

I'm trying to setup Drill JDBC connectivity using db connect. When I connect using SQL Explorer, I'm able to see Catalog, Schema and Tables listed. The queries fired as part of schema selection are found in Drill logs. When I run queries from SQL editor ,it fails with below exception.I couldn't find any relevant messages from splunk/drill logs. Any tips to solve this issue ?

Exception : java.sql.SQLException: [MapR]DrillJDBCDriver Error setting/closing connection: :31010

0 Karma
Highlighted

Re: Apache Drill JDBC connection

Path Finder

See:
http://docs.splunk.com/Documentation/DBX/3.1.0/DeployDBX/Installdatabasedrivers

Be sure to create directory in $SPLUNKHOME/etc/apps/splunkappdbconnect/drivers.

0 Karma
Highlighted

Re: Apache Drill JDBC connection

New Member

I have added Drill jdbc drivers and connection is valid. As mentioned in question , it is able to retrieve schema/information in SQL explorer. But fails with queries on SQL editor.

0 Karma
Highlighted

Re: Apache Drill JDBC connection

New Member

I had to set '-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunkappdbconnect/login.conf' as jvm option in server setting for tables/schemas to get listed. Apparently,this jvm options is not getting in effect when queried from SQL editor. I was able to get it working by adding this option in '/opt/splunk/splunk/etc/apps/splunkappdbconnect/linuxx8664/bin/command.sh' as below.

export DRILLOPTS="-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunkappdbconnect/login.conf"
exec $JAVACMD $DRILLOPTS $@

If there is any cleaner to specify jvm options required for JDBC driver , that would be great.

0 Karma