Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Re: Find current db we r using in Hive


+
Sai Sai 2013-03-08, 05:43
+
Ramki Palle 2013-03-08, 06:36
Copy link to this message
-
Re: Find current db we r using in Hive
It's odd that there is no such command. The trick Ramki mentioned is the
only one I know of. Two points about it, though:

1. It only works on Hive v0.8+.
2. I've seen a few cases where the prompt did NOT change when first used,
but starting working a little later! I have no idea why and of course, it
happened while teaching a class where I'm supposed to be the expert ;)

dean

On Fri, Mar 8, 2013 at 12:36 AM, Ramki Palle <[EMAIL PROTECTED]> wrote:

> Sai,
>
> I do not think there is any command to show the current db in Hive. One
> alternative for you is to set a property so that the current database is
> shown as part of the prompt:
>
> set hive.cli.print.current.db=true;
>
> This one shows your current db as part of your hive prompt.
>
> Regards,
> Ramki.
>
>
> On Fri, Mar 8, 2013 at 11:13 AM, Sai Sai <[EMAIL PROTECTED]> wrote:
>
>> Just wondering if there is any command in Hive which will show us the
>> current db we r using similar to pwd in Unix.
>> Thanks
>> Sai
>>
>>
>
--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330
+
Mark Grover 2013-03-09, 19:32
+
Nagarjuna Kanamarlapudi 2013-03-09, 21:41