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

[#1]

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.

[#2]

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

[#3]

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.

[#4]

I think you might have configured Load balancer between impala daemons.

[#5]

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