hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
Date Tue, 24 May 2016 03:31:12 GMT

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

Lefty Leverenz commented on HIVE-13797:
---------------------------------------

Thanks for the changes, [~vihangk1]!  I can't give you a technical +1, but it looks good to
me.

> 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, HIVE-13797.02.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