[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15300883#comment-15300883
]
Sergio Peña commented on HIVE-13797:
I committed this to master.
Thanks [~vihangk1] for your contribution.
And thanks [~leftylev] for your review too.
> 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
> Fix For: 2.2.0
>
> Attachments: HIVE-13797.01.patch, HIVE-13797.02.patch,
> HIVE-13797.04.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
>-uthe JDBC URL to connect to
>-r reconnect to last saved connect url (in
> conjunction with !save)
>-nthe username to connect as
>-pthe password to connect as
>-dthe driver class to use
>-i script file for initialization
>-e query that should be executed
>-f script file that should be executed
>-w (or) --password-file the password file to read
> password from
>--hiveconf property=value Use value for given property
>--hivevar name=valuehive 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=MAXCOLWIDTHthe 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:1 username password
> 2. beeline -n username -p password -u
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15298720#comment-15298720
]
Sergio Peña commented on HIVE-13797:
Thanks [~vihangk1]
The patch looks simple
+1
I'll wait for tests before doing the commit.
> 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,
> HIVE-13797.04.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
>-uthe JDBC URL to connect to
>-r reconnect to last saved connect url (in
> conjunction with !save)
>-nthe username to connect as
>-pthe password to connect as
>-dthe driver class to use
>-i script file for initialization
>-e query that should be executed
>-f script file that should be executed
>-w (or) --password-file the password file to read
> password from
>--hiveconf property=value Use value for given property
>--hivevar name=valuehive 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=MAXCOLWIDTHthe 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:1 username password
> 2. beeline -n username -p password -u jdbc:hive2://hs2.local:10012
> {code}
--
This message
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15298719#comment-15298719
]
Vihang Karajgaonkar commented on HIVE-13797:
-r option was missing .. adding it back again.
{noformat}
./beeline --help
Usage: java org.apache.hive.cli.beeline.BeeLine
-uthe JDBC URL to connect to
-r reconnect to last saved connect url (in
conjunction with !save)
-nthe username to connect as
-pthe password to connect as
-dthe driver class to use
-i script file for initialization
-e query that should be executed
-f script file that should be executed
-w (or) --password-file the password file to read password
from
--hiveconf property=value Use value for given property
--hivevar name=valuehive 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=MAXCOLWIDTHthe 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. Connect using simple authentication to HiveServer2 on localhost:1
$ beeline -u jdbc:hive2://localhost:1 username password
2. Connect using simple authentication to HiveServer2 on hs.local:1
using -n for username and -p for password
$ beeline -n username -p password -u jdbc:hive2://hs2.local:10012
3. Connect using Kerberos authentication with hive/localh...@mydomain.com
as HiveServer2 principal
$ beeline -u
"jdbc:hive2://hs2.local:10013/default;principal=hive/localh...@mydomain.com
4. Connect using SSL connection to HiveServer2 on localhost at 1
$ beeline
jdbc:hive2://localhost:1/default;ssl=true;sslTrustStore=/usr/local/truststore;trustStorePassword=mytruststorepassword
5. Connect using LDAP authentication
$ beeline -u jdbc:hive2://hs2.local:10013/default
{noformat}
> Provide a connection string example in beeline
> --
>
> Key: HIVE-13797
> URL:
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15298689#comment-15298689
]
Vihang Karajgaonkar commented on HIVE-13797:
Adding new lines after each example which we removed by mistake.
{noformat}
./beeline --help
Usage: java org.apache.hive.cli.beeline.BeeLine
-uthe JDBC URL to connect to
-nthe username to connect as
-pthe password to connect as
-dthe driver class to use
-i script file for initialization
-e query that should be executed
-f script file that should be executed
-w (or) --password-file the password file to read password
from
--hiveconf property=value Use value for given property
--hivevar name=valuehive 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=MAXCOLWIDTHthe 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. Connect using simple authentication to HiveServer2 on localhost:1
$ beeline -u jdbc:hive2://localhost:1 username password
2. Connect using simple authentication to HiveServer2 on hs.local:1
using -n for username and -p for password
$ beeline -n username -p password -u jdbc:hive2://hs2.local:10012
3. Connect using Kerberos authentication with hive/localh...@mydomain.com
as HiveServer2 principal
$ beeline -u
"jdbc:hive2://hs2.local:10013/default;principal=hive/localh...@mydomain.com
4. Connect using SSL connection to HiveServer2 on localhost at 1
$ beeline
jdbc:hive2://localhost:1/default;ssl=true;sslTrustStore=/usr/local/truststore;trustStorePassword=mytruststorepassword
5. Connect using LDAP authentication
$ beeline -u jdbc:hive2://hs2.local:10013/default
{noformat}
> Provide a connection string example in beeline
> --
>
> Key: HIVE-13797
> URL: https://issues.apache.org/jira/browse/HIVE-13797
> Project: Hive
>
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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
>-uthe JDBC URL to connect to
>-r reconnect to last saved connect url (in
> conjunction with !save)
>-nthe username to connect as
>-pthe password to connect as
>-dthe driver class to use
>-i script file for initialization
>-e query that should be executed
>-f script file that should be executed
>-w (or) --password-file the password file to read
> password from
>--hiveconf property=value Use value for given property
>--hivevar name=valuehive 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=MAXCOLWIDTHthe 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:1 username password
> 2. beeline -n username -p password -u jdbc:hive2://hs2.local:10012
> {code}
--
This message was sent by
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15297415#comment-15297415
]
Vihang Karajgaonkar commented on HIVE-13797:
{noformat}
./beeline --help
Usage: java org.apache.hive.cli.beeline.BeeLine
-uthe JDBC URL to connect to
-nthe username to connect as
-pthe password to connect as
-dthe driver class to use
-i script file for initialization
-e query that should be executed
-f script file that should be executed
-w (or) --password-file the password file to read password
from
--hiveconf property=value Use value for given property
--hivevar name=valuehive 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=MAXCOLWIDTHthe 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. Connect using simple authentication to HiveServer2 on localhost:1
$ beeline -u jdbc:hive2://localhost:1 username password
2. Connect using simple authentication to HiveServer2 on hs.local:1
using -n for username and -p for password
$ beeline -n username -p password -u jdbc:hive2://hs2.local:10012
3. Connect using Kerberos authentication with hive/localh...@mydomain.com
as HiveServer2 principal
$ beeline -u
"jdbc:hive2://hs2.local:10013/default;principal=hive/localh...@mydomain.com
4. Connect using SSL connection to HiveServer2 on localhost at 1
$ beeline
jdbc:hive2://localhost:1/default;ssl=true;sslTrustStore=/usr/local/truststore;trustStorePassword=mytruststorepassword
5. Connect using LDAP authentication
$ beeline -u jdbc:hive2://hs2.local:10013/default
{noformat}
Thanks [~leftylev] for the review. Incorporated your suggestions and uploaded
the updated patch HIVE-13797.02.patch again.
> Provide a connection string example in beeline
> --
>
> Key: HIVE-13797
> URL:
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15295761#comment-15295761
]
Hive QA commented on HIVE-13797:
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12805339/HIVE-13797.01.patch
{color:red}ERROR:{color} -1 due to no test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 66 failed/errored test(s), 10028 tests
executed
*Failed tests:*
{noformat}
TestHWISessionManager - did not produce a TEST-*.xml file
TestMiniTezCliDriver-dynpart_sort_optimization2.q-tez_dynpart_hashjoin_3.q-orc_vectorization_ppd.q-and-12-more
- did not produce a TEST-*.xml file
TestMiniTezCliDriver-smb_cache.q-transform_ppr2.q-vector_outer_join0.q-and-5-more
- did not produce a TEST-*.xml file
TestSparkCliDriver-groupby10.q-groupby4_noskew.q-union5.q-and-12-more - did not
produce a TEST-*.xml file
TestSparkCliDriver-mapreduce2.q-groupby7_noskew.q-vectorization_5.q-and-12-more
- did not produce a TEST-*.xml file
TestSparkCliDriver-table_access_keys_stats.q-bucketsortoptimize_insert_4.q-runtime_skewjoin_mapjoin_spark.q-and-12-more
- did not produce a TEST-*.xml file
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_ivyDownload
org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver_hbase_queries
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket4
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket5
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_bucket6
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_constprog_partitioner
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_disable_merge_for_bucketing
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_map_operators
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_num_buckets
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_infer_bucket_sort_reducers_power_two
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_list_bucket_dml_10
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_orc_merge1
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_orc_merge2
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_orc_merge9
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_orc_merge_diff_fs
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_reduce_deduplicate
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_vector_outer_join1
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_vector_outer_join2
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_vector_outer_join3
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_vector_outer_join4
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_vector_outer_join5
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_complex_all
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_auto_join21
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_auto_join28
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby6
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_groupby7_map
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_join5
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_multi_insert
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_stats10
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_stats8
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_union4
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vectorization_12
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vectorization_4
org.apache.hadoop.hive.llap.daemon.impl.TestTaskExecutorService.testPreemptionQueueComparator
org.apache.hadoop.hive.llap.tez.TestConverters.testFragmentSpecToTaskSpec
org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskCommunicator.testFinishableStateUpdateFailure
org.apache.hadoop.hive.metastore.TestAuthzApiEmbedAuthorizerInRemote.org.apache.hadoop.hive.metastore.TestAuthzApiEmbedAuthorizerInRemote
org.apache.hadoop.hive.metastore.TestFilterHooks.org.apache.hadoop.hive.metastore.TestFilterHooks
org.apache.hadoop.hive.metastore.TestHiveMetaStoreGetMetaConf.org.apache.hadoop.hive.metastore.TestHiveMetaStoreGetMetaConf
org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs.org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs
org.apache.hadoop.hive.metastore.TestHiveMetaStoreStatsMerge.testStatsMerge
org.apache.hadoop.hive.metastore.TestMetaStoreEndFunctionListener.testEndFunctionListener
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15294702#comment-15294702
]
Lefty Leverenz commented on HIVE-13797:
---
This is a great idea!
Capitalization nits: "HiveServer2" in the text for #1, 2, 3, 4 and "Kerberos"
for #3.
> 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
>-uthe JDBC URL to connect to
>-r reconnect to last saved connect url (in
> conjunction with !save)
>-nthe username to connect as
>-pthe password to connect as
>-dthe driver class to use
>-i script file for initialization
>-e query that should be executed
>-f script file that should be executed
>-w (or) --password-file the password file to read
> password from
>--hiveconf property=value Use value for given property
>--hivevar name=valuehive 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=MAXCOLWIDTHthe 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:1 username password
> 2. beeline -n username -p password -u jdbc:hive2://hs2.local:10012
> {code}
--
This message was sent by
[jira] [Commented] (HIVE-13797) Provide a connection string example in beeline
[
https://issues.apache.org/jira/browse/HIVE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15294507#comment-15294507
]
Vihang Karajgaonkar commented on HIVE-13797:
Here is sample output with the latest patch.
{noformat}
$ ./beeline --help
Usage: java org.apache.hive.cli.beeline.BeeLine
-uthe JDBC URL to connect to
-nthe username to connect as
-pthe password to connect as
-dthe driver class to use
-i script file for initialization
-e query that should be executed
-f script file that should be executed
-w (or) --password-file the password file to read password
from
--hiveconf property=value Use value for given property
--hivevar name=valuehive 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=MAXCOLWIDTHthe 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. Connect using simple authentication to Hiveserver2 on localhost:1
$ beeline -u jdbc:hive2://localhost:1 username password
2. Connect using simple authentication to Hiveserver2 on hs.local:1
using -n for username and -p for password
$ beeline -n username -p password -u jdbc:hive2://hs2.local:10012
3. Connect using kerberos authentication with hive/localh...@mydomain.com
as Hiveserver2 principal
$ beeline -u
"jdbc:hive2://hs2.local:10013/default;principal=hive/localh...@mydomain.com
4. Connect using SSL connection to hiveserver2 on localhost at 1
$ beeline
jdbc:hive2://localhost:1/default;ssl=true;sslTrustStore=/usr/local/truststore;trustStorePassword=mytruststorepassword
5. Connect using LDAP authentication
$ beeline -u jdbc:hive2://hs2.local:10013/default
{noformat}
> Provide a connection string example in beeline
> --
>
> Key: HIVE-13797
> URL: https://issues.apache.org/jira/browse/HIVE-13797
> Project: Hive
>
