Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB