search

colinmarc / impala-ruby

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

impala-ruby AuthorizationException #25

Open ddoubet opened 6 years ago

ddoubet commented 6 years ago

I am trying to connect a ruby application to Impala and I am having the following issues.

Can connect and can run the commands "SHOW DATABASES", "SHOW CURRENT ROLES" but no other commands will run successfully.

Versions Used: impala-ruby 0.5.1 and all dependencies Impala 2.9 on CDH 5.12

Example use case:

conn = Impala.connect('HOST_NAME', 21000, {sasl: {:username=>"username", :password=>"password"}})

conn.query("SELECT * from ")

Error:

<Impala::Protocol::Beeswax::BeeswaxException message:"AuthorizationException: User '[PLAIN]' does not have privileges to execute 'SELECT' on: mydatabase.mytable\n", log_context:"", handle:<Impala::Protocol::Beeswax::QueryHandle id:"", log_context:"">, errorCode:0, SQLState:"42000">

I have Sentry enabled but privileges are set correctly and I am able to connect and runs commands using the impala-shell, Hue and the Impala Python library impyla. Kerberos is not enabled.

Thanks

osujin commented 3 years ago

@ddoubet this issue complete? same issue me

maximus335 commented 3 years ago

@ddoubet this issue complete? same issue me

You need manky patch in the here https://github.com/colinmarc/impala-ruby/blob/master/lib/impala/sasl_transport.rb#L46 remove [PLAN] substring