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