Unable to connect HBase using sqllinee-thin.py client

[#1]

I am trying to connect HBase using sqlline-thin.py and it hangs indefinitely..

/usr/hdp/2.5.3.0-37/phoenix/bin/sqlline-thin.py

I've enabled DEBUG logs for PQS and below is the snippet from error log.

17/06/30 12:48:16 DEBUG http.headers: http-outgoing-0 >> Authorization: Negotiate YIIFTgYGKwYBBQUCoIIFQjCCBT6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggUlBIIFIWCCBR0GCSqGSIb3EgECAgEAboIFDDCCBQigAwIBBaEDAgEOogcDBQAgAAAAo4IBa2GCAWcwggFjoAMCAQWhDRsLRVhBTVBMRS5DT02iKzApoAMCAQChIjAgGwRIVFRQGxhyYWtoaWRuLTIub3BlbnN0YWNrbG9jYWyjggEeMIIBGqADAgESoQMCAQGiggEMBIIBCD2LhZLvTAUwvX+CvbDO4unUsaTUvMO8l3wrLKkrqHH8CXq5thqyR+XipJQcflntuBcopP+rwTAAejjS8llpFYaZii+Y0OTJrP7kPYas3DHoHj7HiVNTxz7Ck6tz2r9v0E/Ri4N9YdkT0T6QRqQqinkNgrvSPXloE59ZZo30Hxw6CiMGE92Sb0Iv+kXVeYAc+ql90dURZnJbiNbz69VtKWGEDr1u2YQinyE2ejRSYAX4Po5ECznJxdlD4hs/DO80wCeHg3CMaLi+kNykD80tl+tfYXqyBXelV5nuctekCnNZSwvxUnT1TPFpaCJqBJh/Y+TInJrzkFqqQqVoV8u5rGi77H4B9xbob6SCA4IwggN+oAMCARKiggN1BIIDcUSAGUs4g3XXhYTcnsktLBoyyKXeQmqdc2n0MaEhn3c9FzlmoGnp3fInjBvqJUIGvdeMJVlD1VwnTZXitVy9+m21ELGqmje0A+zXKXQwHPYRqVOCkkGYTUvyCCjKoegFiUvyVnsj97Cs6hIiGArbvIdY4M7icZB9IyDWTlqgmZmnkxQ9WEaaCvbRyVxOB6jqnYIm6+iRfmF8Gxj2rN/oY3iQbFAhTrjryjidhWIhUvR1tW2uOSZRmnwXyOlBzUUC8JxfuBWZUcf0tuLCgrjiLNL9ihZNWQF7TYBS2BU3QhC1rD/gh0ct3PPr9BgyjP9ACvw5a1qADdcamDw9tHAgR686grQK8W9SMTLdOgEcJ63oC+iPv+I/j/Y9wEzsApqOqRLd/GVEVl7KwxiwENf5s1zHJAlxiwaydXdLJYRx25B9PKyN/x1/gFXwI2KRLRfYQIUj04Xf/deUorb2SKCVzWKeOsTNd+RrvcdC/FNuPTt61tvviw4zRhW3qoET10yG3KK1OhMXPJ8jFqwyyP5xKQSvUWAXtkltwbl9GhdoP5hu+28aaJc8dGk3q+GdfsnKzt71LGV75sigh7VqYxTGwZFyX/KtiPUIXqGWltUJ1cLbgy3/gOlpDMeQqN1DzuNDLgn0stDifWRePaIhXqP7i5lCuY2JRfx13YD9YQcBqpOz8HdSx7lVEhC1Xf27v4kmdLV5uM2RAuSJwmpUwRaPyui/F+A1QWeF2XG6as4aPr0ccjPYy3Jw4gLCo1neYgFDyNpZpG8LasBu6A0cABD8YMXH7wrHvT3ZN3+rBijLPynlnn+AS8Uh/q83qkWthncE34MFBbfCgElPVCvmCeWK6QJpKYovACZ68O5GstclXRxLPnZLrnN5ljNzvw6LVsG/rlh7SL8VXRLF7wrgE0M3eEYGw4J7C0Ps5i2lfOhuYJzq9JCCOmq0iHOd7Vg+TxtK1KdvjF6SDTNOR3mS8QwOTWsbOn1yD0osFHHeTzkhMog1b2QTd/oOdi6D435pso03AxuERLTV7q5C1EMOZ2Ch/oJh1V+jPU7O2OJuUH8Ti0euOCDZfYFKRQ+tAzcahVkhuF+RX0LO8h6CGhumA7vrJoqDknr/AFeB8Q1l1BvVyO1ZpZAEF7nj5m1d0YQIAgKTB+UmFWfp1kv7q3UgogS2thnk

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "POST / HTTP/1.1[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Content-Length: 104[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Content-Type: application/octet-stream[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Host: rakhidn-2.openstacklocal:8765[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Connection: Keep-Alive[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_131)[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Accept-Encoding: gzip,deflate[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "Authorization: Negotiate YIIFTgYGKwYBBQUCoIIFQjCCBT6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggUlBIIFIWCCBR0GCSqGSIb3EgECAgEAboIFDDCCBQigAwIBBaEDAgEOogcDBQAgAAAAo4IBa2GCAWcwggFjoAMCAQWhDRsLRVhBTVBMRS5DT02iKzApoAMCAQChIjAgGwRIVFRQGxhyYWtoaWRuLTIub3BlbnN0YWNrbG9jYWyjggEeMIIBGqADAgESoQMCAQGiggEMBIIBCD2LhZLvTAUwvX+CvbDO4unUsaTUvMO8l3wrLKkrqHH8CXq5thqyR+XipJQcflntuBcopP+rwTAAejjS8llpFYaZii+Y0OTJrP7kPYas3DHoHj7HiVNTxz7Ck6tz2r9v0E/Ri4N9YdkT0T6QRqQqinkNgrvSPXloE59ZZo30Hxw6CiMGE92Sb0Iv+kXVeYAc+ql90dURZnJbiNbz69VtKWGEDr1u2YQinyE2ejRSYAX4Po5ECznJxdlD4hs/DO80wCeHg3CMaLi+kNykD80tl+tfYXqyBXelV5nuctekCnNZSwvxUnT1TPFpaCJqBJh/Y+TInJrzkFqqQqVoV8u5rGi77H4B9xbob6SCA4IwggN+oAMCARKiggN1BIIDcUSAGUs4g3XXhYTcnsktLBoyyKXeQmqdc2n0MaEhn3c9FzlmoGnp3fInjBvqJUIGvdeMJVlD1VwnTZXitVy9+m21ELGqmje0A+zXKXQwHPYRqVOCkkGYTUvyCCjKoegFiUvyVnsj97Cs6hIiGArbvIdY4M7icZB9IyDWTlqgmZmnkxQ9WEaaCvbRyVxOB6jqnYIm6+iRfmF8Gxj2rN/oY3iQbFAhTrjryjidhWIhUvR1tW2uOSZRmnwXyOlBzUUC8JxfuBWZUcf0tuLCgrjiLNL9ihZNWQF7TYBS2BU3QhC1rD/gh0ct3PPr9BgyjP9ACvw5a1qADdcamDw9tHAgR686grQK8W9SMTLdOgEcJ63oC+iPv+I/j/Y9wEzsApqOqRLd/GVEVl7KwxiwENf5s1zHJAlxiwaydXdLJYRx25B9PKyN/x1/gFXwI2KRLRfYQIUj04Xf/deUorb2SKCVzWKeOsTNd+RrvcdC/FNuPTt61tvviw4zRhW3qoET10yG3KK1OhMXPJ8jFqwyyP5xKQSvUWAXtkltwbl9GhdoP5hu+28aaJc8dGk3q+GdfsnKzt71LGV75sigh7VqYxTGwZFyX/KtiPUIXqGWltUJ1cLbgy3/gOlpDMeQqN1DzuNDLgn0stDifWRePaIhXqP7i5lCuY2JRfx13YD9YQcBqpOz8HdSx7lVEhC1Xf27v4kmdLV5uM2RAuSJwmpUwRaPyui/F+A1QWeF2XG6as4aPr0ccjPYy3Jw4gLCo1neYgFDyNpZpG8LasBu6A0cABD8YMXH7wrHvT3ZN3+rBijLPynlnn+AS8Uh/q83qkWthncE34MFBbfCgElPVCvmCeWK6QJpKYovACZ68O5GstclXRxLPnZLrnN5ljNzvw6LVsG/rlh7SL8VXRLF7wrgE0M3eEYGw4J7C0Ps5i2lfOhuYJzq9JCCOmq0iHOd7Vg+TxtK1KdvjF6SDTNOR3mS8QwOTWsbOn1yD0osFHHeTzkhMog1b2QTd/oOdi6D435pso03AxuERLTV7q5C1EMOZ2Ch/oJh1V+jPU7O2OJuUH8Ti0euOCDZfYFKRQ+tAzcahVkhuF+RX0LO8h6CGhumA7vrJoqDknr/AFeB8Q1l1BvVyO1ZpZAEF7nj5m1d0YQIAgKTB+UmFWfp1kv7q3UgogS2thnk[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "[\r][\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "[\n]"

17/06/30 12:48:16 DEBUG http.wire: http-outgoing-0 >> "8org.apache.calcite.avatica.proto.Requests$ColumnsRequest[0x12],[0x1a][0x1]%"[0x1]%*$8ab7aedd-f341-4a8f-9345-8c78962f5dd8" .

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff} span.s1 {font-variant-ligatures: no-common-ligatures}

Traceback (most recent call last):

File "/usr/hdp/2.5.3.0-37/phoenix/bin/sqlline-thin.py", line 157, in <module>

exitcode = subprocess.call(java_cmd, shell=True)

File "/usr/lib64/python2.6/subprocess.py", line 481, in call

return p.wait()

File "/usr/lib64/python2.6/subprocess.py", line 1307, in wait

pid, sts = _eintr_retry_call(os.waitpid, self.pid, 0)

File "/usr/lib64/python2.6/subprocess.py", line 462, in _eintr_retry_call

return func(*args)

KeyboardInterrupt

[#2 · Accepted solution]

@rakanchi

hadoop proxy must be stopping the PQS connection. Please update the below configs in HDFS accordingly and try to connect to PQS using sqlline-thin client again.

hadoop.proxyuser.HTTP.hosts
hadoop.proxyuser.HTTP.groups

[#3]

What's the actual error that the client sees? Or, does the client hang?

[#4]

I've waited for 15 mins and it didn't progress after above errors. Thus I interrupted it using Ctrl+C.

[#5]

Please use jstack to capture a stacktrace from the thin client as well as the PQS instance your client is talking to.