Table 9.31. query Common Options
| Option | Description |
|---|---|
-conf PATH | Configuration file that contains values for connection properties (url, user and password) |
-file PATH | File containing the SQL commands to run. If missing, read SQL commands from STDIN |
-password | Prompt for password |
-url JDBCURL | JDBC url of the database to connect to |
-user USER | User used to connect to the database |
The query command line tool can be used to issue SQL statements against a database.
The queries can either be entered via STDIN, or read in from a text file
The following example shows a SELECT statement issued via STDIN
shell> query -url "jdbc:mysql:thin://db2:13306/" -user tungsten -password
Enter password: ********
select * from tungsten_nyc.trep_commit_seqno;
[
{
"statement":"select * from tungsten_nyc.trep_commit_seqno;","rc":0,"results":
[
[
{
"task_id":0,
"seqno":1,
"fragno":0,
"last_frag":"1",
"source_id":"db1",
"epoch_number":1,
"eventid":"mysql-bin.000002:0000000000000879;-1",
"applied_latency":0,
"update_timestamp":"2019-06-28 10:44:20.0",
"shard_id":"tungsten_nyc",
"extract_timestamp":"2019-06-28 10:44:19.0"
}
]
],
"error":null
}
]