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
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.
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.
exec $JAVACMD $DRILLOPTS $@
If there is any cleaner to specify jvm options required for JDBC driver , that would be great.