Re: show tables in bin does not display the tables

2013-03-05 Thread Mark Grover
Sai, This is because you are using the default embedded derby database as metastore. When using the embedded derby metastore, the metadata is stored in a relative location. See the value of javax.jdo.option.ConnectionURL. By default, its value is jdbc:derby:;databaseName=metastore_db;create=true m

Re: show tables in bin does not display the tables

2013-03-05 Thread Sai Sai
Hello I have noticed when i execute the following command from hive shell in diff folders it behaves in diff ways and was wondering if this is right: show tables; from the bin folder under my hive install folder it just shows tab_name: myUser@ubuntu:~/work/hive-0.1