Roquettor is a basic command-line tool developped by Indexima that allows you to send queries in batch.
Download & Prerequisites
You can download the last version of Roquettor here.
Using Roquettor requires Java installed.
In order to use Roquettor, open a shell and execute
java -jar roquettor-1.3.jar .
Please find below an example of running Roquettor to send queries to an Indexima cluster.
The required parameters are described in the Options section.
java -jar roquettor-1.3.jar \ -url "jdbc:hive2://localhost:10000/default" \ -user "admin" \ -password "myPassword" \ -script "queries.sql" \ -threads 3
Define JDBC URL to the Indexima cluster
Set the queries scripts files to execute.
Define max concurrent connections.
Define the Driver Class to register.
Define path to results directory.
|user||Define the user to authenticate.|
Define the user's password.
Timeout in seconds: if the query lasts more than x sec, roquettor will cancel the query
boolean to retrieve results or not
|repeat||Repeat execution plan as many times as specified|
|flushresults||Flush all query results to specified location|
Default: empty (no flushing results)
Roquettor will generate a file with the list of queries executed, their timestamp and if the query is in error.
This file will be generated in the repository defined by the output parameter.
If the results parameter is true, the output file will also contains the number of results for each queries.
If the flushresults parameter contains folder location, Roquettor will dump the results of each query to this location.
Sample of output file
query,resultCount,startTime,endTime,elapsed,error "SELECT 123456789",0,1649855566069,1649855566151,82,NO