question Ambari transport mode set to binary, but must connect using SASL in Archives of Support Questions (Read Only)

Ambari transport mode set to binary, but must connect using SASL

orendain — Thu, 27 Apr 2017 02:54:21 GMT

I have "hive.server2.transport.mode" set to "binary", though when connecting to Hive via, for example, Tableau, I have to select "SASL" as the transport mode from within Tableau. Trying to connect with binary gives connection errors.

Is the "hive.server2.transport.mode" config not in effect, or is there something else at work that mat not seem intuitive?

Thanks!

Re: Ambari transport mode set to binary, but must connect using SASL

deepesh1 — Thu, 27 Apr 2017 11:16:52 GMT

hive.server2.transport.mode values are either binary or http.

hive.server2.authentication – Authentication mode, default NONE. Options are NONE (uses plain SASL), NOSASL, KERBEROS, LDAP, PAM and CUSTOM.

I believe Tableau is making you select the authentication mode and not the transport mode.