Since I'm using derby, I went to $DERBY_HOME/data and moved metastore_db to metastore_db_save and restarted derby. The next time I started Hive, the metastore_db was recreated.
On Wed, Sep 29, 2010 at 8:21 AM, Matt Tanquary <matt.tanqu...@gmail.com> wrote: > That sounded easier than said. The same problem that won't allow me to > select from the tables, won't allow me to drop them. How can I just > refresh the metadata? > > On Wed, Sep 29, 2010 at 8:00 AM, Matt Tanquary <matt.tanqu...@gmail.com> > wrote: >> Yes, I changed ports after creating certain tables (started using >> Derby). New tables created do not have this issue. I will simply drop >> and recreate the tables since I have that option in this case. >> >> Thanks for the comments! >> -M@ >> >> On Tue, Sep 28, 2010 at 8:54 PM, Adarsh Sharma <adarsh.sha...@orkash.com> >> wrote: >>> May these few things solve the error :- >>> 1. Check through web interface wheteher the namenode, jobtracker, >>> tasktracker are running or not. >>> 2. Resolve IP-host name binding to edit /etc/hosts file of all nodes. Insert >>> these lines >>> >>> IP-addresss hostname >>> e. g 192.122.0.111 node1 >>> >>> Thanks >>> >>> >>> >>> Matt Tanquary wrote: >>>> >>>> This worked at one time, but I now I'm having an issue: >>>> >>>> I have a basic python script for testing python/hive. The script just >>>> does a few simple things: >>>> >>>> -show tables >>>> -describe [a table] >>>> -select * from [a table] limit 15 >>>> >>>> The show tables and describe sections are functioning. However, when >>>> it gets to the select command, then the hive server begins to issue: >>>> >>>> 10/09/28 13:38:24 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 0 time(s). >>>> 10/09/28 13:38:25 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 1 time(s). >>>> 10/09/28 13:38:26 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 2 time(s). >>>> 10/09/28 13:38:27 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 3 time(s). >>>> 10/09/28 13:38:28 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 4 time(s). >>>> 10/09/28 13:38:29 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 5 time(s). >>>> 10/09/28 13:38:30 INFO ipc.Client: Retrying connect to server: >>>> .mysvr/15.6.84.51:8020. Already tried 6 time(s). >>>> 10/09/28 13:38:31 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 7 time(s). >>>> 10/09/28 13:38:32 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 8 time(s). >>>> 10/09/28 13:38:33 INFO ipc.Client: Retrying connect to server: >>>> mysvr/15.6.84.51:8020. Already tried 9 time(s). >>>> >>>> The problem I believe is the port that it's trying to connect to. My >>>> hdfs namenode is serviced on port 54310. >>>> >>>> I tried adding the following setting to hive-site.xml: >>>> <name>fs.default.name</name> <value>hdfs://mysvr:54310</value> >>>> >>>> Any other suggestions? >>>> >>>> Thanks! >>>> -M@ >>>> >>> >>> >> >> >> >> -- >> Have you thanked a teacher today? ---> http://www.liftateacher.org >> > > > > -- > Have you thanked a teacher today? ---> http://www.liftateacher.org > -- Have you thanked a teacher today? ---> http://www.liftateacher.org