impala-ruby AuthorizationException

[ddoubet]

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 <my_database.mytable>")

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]

@ddoubet this issue complete? same issue me

[maximus335]

@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