Another alternative way, just say
Desc extended <table_name> There we can see the db name of the table — Sent from iPhone On Sun, Mar 10, 2013 at 1:02 AM, Mark Grover <grover.markgro...@gmail.com> wrote: > Created https://issues.apache.org/jira/browse/HIVE-4144 > On Fri, Mar 8, 2013 at 5:25 AM, Dean Wampler > <dean.wamp...@thinkbiganalytics.com> 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 <ramki.pa...@gmail.com> 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 <saigr...@yahoo.in> 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 >>