Table 9.30. 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 -passwordEnter password:********[ { "statement":"select * from tungsten_alpha.trep_commit_seqno;","rc":0,"results": [ [ { "task_id":0, "seqno":1, "fragno":-1, "last_frag":"1", "source_id":"db1", "epoch_number":0, "eventid":"mysql-bin.000013:0000000000001171;93", "applied_latency":null, "update_timestamp":"2025-02-20 10:58:41.0", "shard_id":null, "extract_timestamp":"2025-02-20 10:58:41.0", "connection_id":183 } ] ], "error":null } ]select * from tungsten_nyc.trep_commit_seqno;