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

Switch to Threaded View
Hive, mail # user - Re: Find current db we r using in Hive


Copy link to this message
-
Re: Find current db we r using in Hive
Mark Grover 2013-03-09, 19:32
Created https://issues.apache.org/jira/browse/HIVE-4144

On Fri, Mar 8, 2013 at 5:25 AM, Dean Wampler
<[EMAIL PROTECTED]> wrote:
> 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
>