The mode specifier determines what happens to the processed table when it reaches the output end of the pipeline. Only one of the following should be specified:
-write [-ofmt <out-format>] [-o <out-table>]
-o
flag is specified,
it's written
to the named file, otherwise it's streamed to standard output.
The output format is named using the -ofmt
flag;
if not supplied,
an attempt is made to guess the format from the destination name.
If neither -o
nor -ofmt
is specified,
it's written in formatted text format to standard output
(equivalent to -o - -ofmt text
).
-tosql <jdbc-url> [-user <username>]
[-password <password>]
-Djdbc.drivers
set as usual.
You can specify your SQL connection username and password or not -
you will be prompted on the terminal if they are required.
-stats
-meta
-count
If no mode specifier is given, -write
is assumed.