Reply
Explorer
Posts: 23
Registered: ‎12-10-2018

Impala-shell: Not connected to Impala, could not execute queries.

[ Edited ]

Hi.

I run Impala-shell command 

impala-shell -i hdp01.***.***.ru:21051 -k -f /tmp/qql.sql

and catch such error:

Starting Impala Shell using Kerberos authentication
Using service name 'impala'
Error connecting: TTransportException, TSocket read 0 bytes
Not connected to Impala, could not execute queries.

That's all.

No logs. No special error description. Noghing. Just "not connected to Impala".

 

However, Impala works fine. In Hue i can exec queries.

And "host:port" is fine. If i set other combination of it, i get: 

Starting Impala Shell using Kerberos authentication
Using service name 'impala'
Error connecting: TTransportException, Could not connect to any.other.port.ru:21050

So, we can see, that server available. But Impala is not.

 

Why? And how to fix it?

I even can't google any solution by my error: "Error connecting: TTransportException, TSocket read 0 bytes" or "Not connected to Impala, could not execute queries."

 

Please, help me.

Highlighted
Posts: 49
Topics: 0
Kudos: 13
Solutions: 5
Registered: ‎07-30-2018

Re: Impala-shell: Not connected to Impala, could not execute queries.

Hi,

 

Impala uses 21000 port to transmit commands and receive results by impala-shell and some ODBC drivers. And 21050 to transmit commands and receive results by applications, such as Business Intelligence tools, using JDBC

 

Could you try as below

 

impala-shell -i hdp01.***.***.ru:21000 -k -f /tmp/qql.sql

 

Thanks

Jerry

Explorer
Posts: 23
Registered: ‎12-10-2018

Re: Impala-shell: Not connected to Impala, could not execute queries.

Hi, thnx. It was port-error.
But it's not 21000, it works on 23005 port. I don't know how and why - but it is.
Posts: 49
Topics: 0
Kudos: 13
Solutions: 5
Registered: ‎07-30-2018

Re: Impala-shell: Not connected to Impala, could not execute queries.

I think you might have configured Load balancer between impala daemons.
Explorer
Posts: 23
Registered: ‎12-10-2018

Re: Impala-shell: Not connected to Impala, could not execute queries.

yes, it is. Not me, sysadmin.
If i configed impala - i'd know correct port.