Jdbc.rb

require 'java'
require 'hive_metastore.jar'
require 'hive_service.jar'
require 'ImpalaJDBC41.jar'
require 'libfb303-0.9.0.jar'
require 'libthrift-0.9.0.jar'
require 'log4j-1.2.14.jar'
require 'ql.jar'
require 'slf4j-api-1.5.11.jar'
require 'slf4j-log4j12-1.5.11.jar'
require 'TCLIServiceClient.jar'
require 'lib/jdbc'
 
Java::com.cloudera.impala.jdbc41.Driver
url = CONFIG['IMPALA']['uri']
conn = java.sql.DriverManager.get_connection(url, CONFIG['IMPALA']['user'], CONFIG['IMPALA']['password'])
statement = conn.create_statement
q = 'SELECT VERSION()'
rs = statement.execute_query(q)
puts resultset_to_hash rs
statement.close
conn.close