search

colinmarc / impala-ruby

an impala client for ruby
MIT License
34 stars 22 forks source link

Errors on Impala Query #3

Closed fion8828 closed 11 years ago

fion8828 commented 11 years ago

Hi All,

First time get in touch with Impala-ruby gem. I connected to Impala and try to SELECT * FROM tab2, it threw me errors. Here's what I typed in Ruby shell: irb(main):016:0> conn.query('select * from tab2') Here are the errors I got: IOError: closed stream from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/thrift-0.9.0/lib/thrift/transport/socket.rb:63:in write' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/thrift-0.9.0/lib/thrift/transport/buffered_transport.rb:101:inflush' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/thrift-0.9.0/lib/thrift/client.rb:41:in send_message' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/impala-0.1.5/lib/impala/protocol/beeswax_service.rb:23:insend_query' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/impala-0.1.5/lib/impala/protocol/beeswax_service.rb:18:in query' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/impala-0.1.5/lib/impala/connection.rb:86:insend_query' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/impala-0.1.5/lib/impala/connection.rb:62:in execute' from /opt/boxen/rbenv/versions/1.9.3-p392/lib/ruby/gems/1.9.1/gems/impala-0.1.5/lib/impala/connection.rb:52:inquery' from (irb):16 from /opt/boxen/rbenv/versions/1.9.3/bin/irb:12:in `

'

Anyone have idea on how to fix those errors? Thanks in advance.

Fiona

colinmarc commented 11 years ago

Hm, that's strange. What version of Impala are you running?

fion8828 commented 11 years ago

Hey, Thanks for your reply. I solved the problem. It's because I didn't open all the ports that are needed for impala. Now I could do query. oh yeah. :)

colinmarc commented 11 years ago

Awesome! Glad it worked out.