hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vihang Karajgaonkar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
Date Fri, 20 May 2016 21:25:13 GMT

    [ https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15294260#comment-15294260
] 

Vihang Karajgaonkar commented on HIVE-13797:
--------------------------------------------

Sample output after the patch.

{noformat}
$ ./beeline --help
Usage: java org.apache.hive.cli.beeline.BeeLine 
   -u <database url>               the JDBC URL to connect to
   -r                              reconnect to last saved connect url (in conjunction with
!save)
   -n <username>                   the username to connect as
   -p <password>                   the password to connect as
   -d <driver class>               the driver class to use
   -i <init file>                  script file for initialization
   -e <query>                      query that should be executed
   -f <exec file>                  script file that should be executed
   -w (or) --password-file <password file>  the password file to read password from
   --hiveconf property=value       Use value for given property
   --hivevar name=value            hive variable name and value
                                   This is Hive specific settings in which variables
                                   can be set at session level and referenced in Hive
                                   commands or queries.
   --color=[true/false]            control whether color is used for display
   --showHeader=[true/false]       show column names in query results
   --headerInterval=ROWS;          the interval between which heades are displayed
   --fastConnect=[true/false]      skip building table/column list for tab-completion
   --autoCommit=[true/false]       enable/disable automatic transaction commit
   --verbose=[true/false]          show verbose error messages and debug info
   --showWarnings=[true/false]     display connection warnings
   --showNestedErrs=[true/false]   display nested errors
   --numberFormat=[pattern]        format numbers using DecimalFormat pattern
   --force=[true/false]            continue running script even after errors
   --maxWidth=MAXWIDTH             the maximum width of the terminal
   --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
   --silent=[true/false]           be more silent
   --autosave=[true/false]         automatically save preferences
   --outputformat=[table/vertical/csv2/tsv2/dsv/csv/tsv]  format mode for result display
                                   Note that csv, and tsv are deprecated - use csv2, tsv2
instead
   --incremental=[true/false]      Defaults to false. When set to false, the entire result
set
                                   is fetched and buffered before being displayed, yielding
optimal
                                   display column sizing. When set to true, result rows are
displayed
                                   immediately as they are fetched, yielding lower latency
and
                                   memory usage at the price of extra display column padding.
                                   Setting --incremental=true is recommended if you encounter
an OutOfMemory
                                   on the client side (due to the fetched result set size
being large).
   --truncateTable=[true/false]    truncate table column when it exceeds length
   --delimiterForDSV=DELIMITER     specify the delimiter for delimiter-separated values output
format (default: |)
   --isolation=LEVEL               set the transaction isolation level
   --nullemptystring=[true/false]  set to true to get historic behavior of printing null as
empty string
   --addlocaldriverjar=DRIVERJARNAME Add driver jar file in the beeline client side
   --addlocaldrivername=DRIVERNAME Add drvier name needs to be supported in the beeline client
side
   --showConnectedUrl=[true/false] Prompt HiveServer2s URI to which this beeline connected.
                                   Only works for HiveServer2 cluster mode.
   --help                          display this message
 
   Example:
    1. beeline -u jdbc:hive2://localhost:10000 username password
    2. beeline -n username -p password -u jdbc:hive2://hs2.local:10012
    3. beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/HiveServer2Host@your-domain.com"
 
{noformat}

> Provide a connection string example in beeline
> ----------------------------------------------
>
>                 Key: HIVE-13797
>                 URL: https://issues.apache.org/jira/browse/HIVE-13797
>             Project: Hive
>          Issue Type: Improvement
>          Components: Beeline
>    Affects Versions: 2.0.0
>            Reporter: Vihang Karajgaonkar
>            Assignee: Vihang Karajgaonkar
>            Priority: Minor
>         Attachments: HIVE-13797.01.patch
>
>
> It would save a bunch of googling if we could provide some examples of connection strings
directly to beeline help message
> Eg:
> {code}
> ./bin/beeline --help
> Usage: java org.apache.hive.cli.beeline.BeeLine 
>    -u <database url>               the JDBC URL to connect to
>    -r                              reconnect to last saved connect url (in conjunction
with !save)
>    -n <username>                   the username to connect as
>    -p <password>                   the password to connect as
>    -d <driver class>               the driver class to use
>    -i <init file>                  script file for initialization
>    -e <query>                      query that should be executed
>    -f <exec file>                  script file that should be executed
>    -w (or) --password-file <password file>  the password file to read password
from
>    --hiveconf property=value       Use value for given property
>    --hivevar name=value            hive variable name and value
>                                    This is Hive specific settings in which variables
>                                    can be set at session level and referenced in Hive
>                                    commands or queries.
>    --color=[true/false]            control whether color is used for display
>    --showHeader=[true/false]       show column names in query results
>    --headerInterval=ROWS;          the interval between which heades are displayed
>    --fastConnect=[true/false]      skip building table/column list for tab-completion
>    --autoCommit=[true/false]       enable/disable automatic transaction commit
>    --verbose=[true/false]          show verbose error messages and debug info
>    --showWarnings=[true/false]     display connection warnings
>    --showNestedErrs=[true/false]   display nested errors
>    --numberFormat=[pattern]        format numbers using DecimalFormat pattern
>    --force=[true/false]            continue running script even after errors
>    --maxWidth=MAXWIDTH             the maximum width of the terminal
>    --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
>    --silent=[true/false]           be more silent
>    --autosave=[true/false]         automatically save preferences
>    --outputformat=[table/vertical/csv2/tsv2/dsv/csv/tsv]  format mode for result display
>                                    Note that csv, and tsv are deprecated - use csv2,
tsv2 instead
>    --incremental=[true/false]      Defaults to false. When set to false, the entire result
set
>                                    is fetched and buffered before being displayed, yielding
optimal
>                                    display column sizing. When set to true, result rows
are displayed
>                                    immediately as they are fetched, yielding lower latency
and
>                                    memory usage at the price of extra display column
padding.
>                                    Setting --incremental=true is recommended if you encounter
an OutOfMemory
>                                    on the client side (due to the fetched result set
size being large).
>    --truncateTable=[true/false]    truncate table column when it exceeds length
>    --delimiterForDSV=DELIMITER     specify the delimiter for delimiter-separated values
output format (default: |)
>    --isolation=LEVEL               set the transaction isolation level
>    --nullemptystring=[true/false]  set to true to get historic behavior of printing null
as empty string
>    --addlocaldriverjar=DRIVERJARNAME Add driver jar file in the beeline client side
>    --addlocaldrivername=DRIVERNAME Add drvier name needs to be supported in the beeline
client side
>    --showConnectedUrl=[true/false] Prompt HiveServer2s URI to which this beeline connected.
>                                    Only works for HiveServer2 cluster mode.
>    --help                          display this message
>  
>    Example:
>     1. beeline -u jdbc:hive2://localhost:10000 username password
>     2. beeline -n username -p password -u jdbc:hive2://hs2.local:10012
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message