Yes, CBO is a client side property. You can disable at the beginning of query by specifying: set hive.cbo.enable=false; ... View more

If i understand your question, you want to connect to HiveServer2 using Zookeeper without having the client to worry about the transport mode. This is supported by the HiveServer2 feature - Zookeeper Service Discovery Mode. If you are using Ambari this is the default mode. With introduction of HIVE-11581, the JDBC url becomes very simple as none of the additional configuration parameters such as authentication mode, transport mode, or SSL parameters need to be specified, as they are retrieved from the ZooKeeper entries along with the hostname. JDBC URL: jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 The <zookeeper quorum> is the same as the value of hive.zookeeper.quorum configuration parameter in hive-site.xml/hivserver2-site.xml used by HiveServer2. Read more about it here. ... View more

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. Read more at https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-Authentication/SecurityConfiguration. I believe Tableau is making you select the authentication mode and not the transport mode. ... View more

For HDP 2.6, supported OS are Centos 6/7/ppc, SLES 11/12, Debian 6/7, Ubuntu 12/14/16 https://community.hortonworks.com/articles/93067/hdp-26ambari-25-ga.html ... View more