Roquettor
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.
Basic usage
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
Options
Name | Description |
---|---|
url | Define JDBC URL to the Indexima cluster |
script | Set the queries scripts files to execute. |
threads | Define max concurrent connections. |
driverclass | Define the Driver Class to register. |
output | Define path to results directory. |
user | Define the user to authenticate. Default: empty |
password | Define the user's password. |
timeout | Timeout in seconds: if the query lasts more than x sec, roquettor will cancel the query |
results | boolean to retrieve results or not |
repeat | Repeat execution plan as many times as specified Default: 1 |
flushresults | Flush all query results to specified location Default: empty (no flushing results) |
Output
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