Tオプションだ!
-T, --type TYPE set query type (hive, pig, presto)
つまり例としては、こう。
$ td query -d example_db -T presto -w -r rset1 "select count(*) from table1"
見つけ方なんだけど、ドキュメントを読んでもよくわからなかったので、ヘルプ。
td query --help usage: $ td query [sql] example: $ td query -d example_db -w -r rset1 "select count(*) from table1" $ td query -d example_db -w -r rset1 -q query.txt description: Issue a query options: -d, --database DB_NAME use the database (required) -w, --wait wait for finishing the job -G, --vertical use vertical table to show results -o, --output PATH write result to the file -f, --format FORMAT format of the result to write to the file (tsv, csv, json, msgpack, and msgpack.gz) -r, --result RESULT_URL write result to the URL (see also result:create subcommand) It is suggested for this option to be used with the -x / --exclude option to suppress printing of the query result to stdout or -o / --output to dump the query result into a file. -u, --user NAME set user name for the result URL -p, --password ask password for the result URL -P, --priority PRIORITY set priority -R, --retry COUNT automatic retrying count -q, --query PATH use file instead of inline query -T, --type TYPE set query type (hive, pig, presto) --sampling DENOMINATOR OBSOLETE - enable random sampling to reduce records 1/DENOMINATOR -l, --limit ROWS limit the number of result rows shown when not outputting to file -c, --column-header output of the columns' header when the schema is available for the table (only applies to json, tsv and csv formats) -x, --exclude do not automatically retrieve the job result -O, --pool-name NAME specify resource pool by name --domain-key DOMAIN_KEY optional user-provided unique ID. You can include this ID with your `create` request to ensure idempotence