Database Reference
In-Depth Information
Command option
Description
$ impala-shell -query
''select * from
table_name;'
-o filename or --output_file
filename
This option allows you to save the query output to
a file.
-B or --delimited
This option is use to produce comma-separated,
tab-separated, or other delimited text files as out-
put. The default delimiter is the TAB character
( \t ); however, it can be changed using the -out-
put_delimiter option and passing the desired
delimiter character.
-f query_file_name or
-query_file=query_file_name
Using this option you can pass a SQL query file
that includes all of the queries you want to pass
through impala-shell. An example of using this op-
tion is as follows:
$impala-shell -f
myqueryfile.sql
-p or --show_profiles
This option is similar to the SQL EXPLAIN state-
ment that provides a query-execution plan includ-
ing detailed query execution steps for every query
executed by the impala-shell
Search WWH ::




Custom Search