question Beeline : Hive property to print current database name in Support Questions

Beeline : Hive property to print current database name

dineshc — Wed, 23 Aug 2017 23:21:33 GMT

When using HiveCLI, if we

SET hive.cli.print.current.db = true;

Then the command prompt for Hive CLI displays the current database name until the end of the session as shown below:

hive mydb >

I tried using the same property in Beeline but had no effect. Is there a different way of achieving this in Beeline ?

Re: Beeline : Hive property to print current database name

jsensharma — Wed, 23 Aug 2017 23:24:45 GMT

@Dinesh Chitlangia

I did not try the following myswlf but looks promising:

In BeeLine in beeline mode use the --showDbInPrompt command line option instead.

As per: https://issues.apache.org/jira/browse/HIVE-13899

As per: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients

--showDbInPrompt=[true/false] : Display the current database name in prompt. Default is false.

Usage: beeline --showDbInPrompt=true

Re: Beeline : Hive property to print current database name

dineshc — Wed, 23 Aug 2017 23:57:34 GMT

@Jay SenSharma - Thank you for prompt response.

I see this only works for Beeline version 2.3.0 and latest.

I am currently using 1.2.1 and thus this will have no effect. However, I appreciate your help. I will try for a workaround for version 1.2.1, if nothing else works I will upgrade to 2.3.0 and accept your answer.

Re: Beeline : Hive property to print current database name

jsensharma — Thu, 24 Aug 2017 15:31:39 GMT

@Dinesh Chitlangia

Thank you. Yes, this flag is added later in beeline "--showDbInPrompt", Before that ( HIVE-14123 , fixed in 2.3.0) there was not option to display the database name.

Re: Beeline : Hive property to print current database name

ss05926 — Tue, 24 Sep 2019 02:59:16 GMT

yes, this works

beeline --showDbInPrompt=true -u "jdbc:hive2://...."

Thanks

Re: Beeline : Hive property to print current database name

ss05926 — Tue, 24 Sep 2019 03:01:15 GMT

and I see, yes, i am using 2.3.3

Re: Beeline : Hive property to print current database name

Shahmen — Tue, 24 Sep 2019 07:02:54 GMT

Thank you very much!