cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ask a Question
arjun_kr
New Member
Member since: ‎08-01-2017
‎06-05-2020
Community Statistics
Posts 5
Solutions 0
Karma Given 0
Karma Received 0
Member Since ‎08-01-2017
Activity Feed
View All

Re: Apache Drill JDBC connection

by in All Apps and Add-ons
‎08-10-2017 06:04 PM
‎08-10-2017 06:04 PM
I had to set '-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunk_app_db_connect/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/splunk_app_db_connect/linux_x86_64/bin/command.sh' as below. export DRILL_OPTS="-Djava.security.auth.login.config=/opt/splunk/splunk/etc/apps/splunk_app_db_connect/login.conf" exec $JAVA_CMD $DRILL_OPTS $@ If there is any cleaner to specify jvm options required for JDBC driver , that would be great. ... View more

Re: Apache Drill JDBC connection

by in All Apps and Add-ons
‎08-10-2017 10:06 AM
‎08-10-2017 10:06 AM
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. ... View more

Apache Drill JDBC connection

by in All Apps and Add-ons
‎08-09-2017 09:38 PM
‎08-09-2017 09:38 PM
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 ... View more

Re: Apache Drill JDBC connector

by in All Apps and Add-ons
‎08-01-2017 07:14 PM
‎08-01-2017 07:14 PM
I was able to connect finally by creating directory ' DrillJDBC41-libs' in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers. The driver file name was 'DrillJDBC41.jar'. It was not clear from documentation regarding name to be used for dependent jar directory (Documentation says $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/-libs) ... View more

Apache Drill JDBC connector

by in All Apps and Add-ons
‎08-01-2017 01:04 AM
‎08-01-2017 01:04 AM
I was trying to setup apache drill jdbc driver using db connect (3.1.0) and splunk 6.6.2. I have multiple jars as dependency apart from driver class jar. It's failing with dependent class not found exception with dependent jars copied to $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/. Are there way to add these additional dependent jars ? I see below note in http://docs.splunk.com/Documentation/DBX/3.1.0/DeployDBX/Installdatabasedrivers . Do we have this option in 3.1.0 ? In DB Connect 3.0.0, the main JDBC JAR file and the extended JAR files must be installed in different folders. The path for the extended JAR file is $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/-libs. If you are using Spark SQL, or a Teradata or Oracle database, you must move dependent JAR files manually. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-05-2020 02:03 AM