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