Hi,  I have a imapala cluster with kerberos and HA proxy, and everything works fine when I connect using impyla. But when I do a  (after a kinit)  impala-shell -k connect myHaproxy:21051; I get : Error: Unable to communicate with impalad service. This service may not be an impalad instance. Check host:port and try again. Traceback (most recent call last): File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/bin/../lib/impala-shell/impala_shell.py", line 1554, in <module> shell.cmdloop(intro) File "/usr/lib/python2.7/cmd.py", line 142, in cmdloop stop = self.onecmd(line) File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/bin/../lib/impala-shell/impala_shell.py", line 563, in onecmd return cmd.Cmd.onecmd(self, line) File "/usr/lib/python2.7/cmd.py", line 221, in onecmd return func(arg) File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/bin/../lib/impala-shell/impala_shell.py", line 717, in do_connect self._connect() File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/bin/../lib/impala-shell/impala_shell.py", line 764, in _connect result = self.imp_client.connect() File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/lib/impala-shell/lib/impala_client.py", line 245, in connect result = self.ping_impala_service() File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/lib/impala-shell/lib/impala_client.py", line 250, in ping_impala_service return self.imp_service.PingImpalaService() File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/lib/impala-shell/gen-py/ImpalaService/ImpalaService.py", line 223, in PingImpalaService return self.recv_PingImpalaService() File "/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/lib/impala-shell/gen-py/ImpalaService/ImpalaService.py", line 238, in recv_PingImpalaService raise x thrift.Thrift.TApplicationException: Invalid method name: 'PingImpalaService' any idea why? thanks ... View more

Hi,  using impala 2.7(8) with cdh5.10.1 here.  I am trying a simple query :  `select distinct(date_col_partition) from table_1` and it is taking 20 sec.  But When I do a set DISABLE_CODEGEN=true; It take only less than a second.    here is the profle gist: https://gist.github.com/anonymous/1a5faa3a10d4495f7b8abc3c964457db   Any idea of what is going wrong?   thanks ... View more

Hi,   quick question on performance, if I have 2 tables, the first one with columns "a,b" and the second one with columns "c,d" and I create a view like the following :  CREATE VIEW my_view AS ( select a,b,null,null from table_1 union select null,null,c,d from table_2) Now if I do a simple query like : select a from my_view Will the query only read from table 1 or the entire table_2 will also be scanned?  (I am mainly worried about disk reads)   Thanks ... View more