rbhive icon indicating copy to clipboard operation
rbhive copied to clipboard

Problems sending query to server

Open edersonm opened this issue 9 years ago • 2 comments

I'm facing some issues with RBHive to connect to Hive 1.1(CDH 5.5).

When connecting using the following:

 :server: localhost
:port: 10000
:options:
  :hive_version: 13
  :transport: :sasl
  :sasl_params:
    :username: test
    :password: tttt

I'm receiving: org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT... on Hiveserver logs and "No operation state found for handles - has the session been closed?" on client side I opened RbHive gem code and the return for


 response = @client.GetOperationStatus(
        Hive2::Thrift::TGetOperationStatusReq.new(operationHandle: prepare_operation_handle(handles))
      )

is nil.

Does anyone know a workaround for this?

Thanks in advance!

Question also on stackoverflow: http://stackoverflow.com/questions/36484318/rbhive-problems-sending-query-to-server

edersonm avatar Apr 07 '16 21:04 edersonm

I think you are messing up with the Hive Versions. Your call refers to hive2 and in your setup you mention you are using hive 1.1

dariusgm avatar Apr 21 '16 14:04 dariusgm

actually, it relates to Hive Server 2.

edersonm avatar May 11 '16 21:05 edersonm