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 > >