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 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
Re: Find current db we r using in Hive
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
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 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
Re: Find current db we r using in Hive
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
Re: Find current db we r using in Hive
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