@Sami Ahmad Below steps will help you in setting up ODBC.. 1. Check on what Mode my Hiveserver2 is running, From Ambari -> Hive -> Conf check property value hive.server2.transport.mode If the above is set to binary, in that case, your Hiveserver2 is running on Binary Mode i.e based on above configs it should be port 10000, otherwise, if it is HTTP then your HS2 is running on PORT 10001 for HTTP Transport mode, set transport mode as HTTP and HTTP Path as cliservice If it is binary then set Thrift Transport mode to default SASL. 2. Test the connectivity between end Client and Hiveserver2 host by using ping or telnet on the port we got from above point. I would check FQDN of HS2 host from end client and set the same in Host for ODBC. 3. Check property hive.server2.authentication value, if it is None, you can set Authentication Mechanism in ODBC config as just Username and pass the end user otherwise if it is Kerberos, you can set Kerberos for it. In case of LDAP pass username/password with auth as username and password. 4. Test Connection to HS2. Let me know if it helps?
... View more
