I'm having the same problem. I followed the tutorial you linked, and the data source didn't show up in the Data Source Selection box until I moved the config files into /Library/ODBC. Once there, the data source appears as a system DSN. The data source test in iODBC Administrator reports "The connection DSN was tested successfully, and can be used at this time", but when I test it under Excel I get the same error Sean Sun is getting. This is in an attempt to contact the sandbox. I'm using the same version of OS X and Excel he's using. odbc.ini: [ODBC] # Specify any global ODBC configuration here such as ODBC tracing. [ODBC Data Sources] Sample Hortonworks Hive DSN=Hortonworks Hive ODBC Driver [Sample Hortonworks Hive DSN] # Description: DSN Description. # This key is not necessary and is only to give a description of the data source. Description=Hortonworks Hive ODBC Driver DSN # Driver: The location where the ODBC driver is installed to. Driver=/opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib # When using No Service Discovery, specify the IP address or host name of the Hive server. # When using ZooKeeper as the Service Discovery Mode, specify a comma-separated list of ZooKeeper # servers in the following format: # <zk_host1:zk_port1>,<zk_host2:zk_port2>,... #HOST=192.168.56.101 HOST=localhost # The TCP port Hive server is listening. This is not required when using ZooKeeper as the service # discovery mode as the port is specified in the HOST connection attribute. PORT=10000 # The name of the database schema to use when a schema is not explicitly specified in a query. Schema=default # Set to 0 to when connecting directory to Hive Server 2 (No Service Discovery). # Set to 1 to do Hive Server 2 service discovery using ZooKeeper. # Note service discovery is not support when using Hive Server 1. ServiceDiscoveryMode=0 # The namespace on ZooKeeper under which Hive Server 2 znodes are added. Required only when doing # HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1). ZKNamespace= # Set to 1 if you are connecting to Hive Server 1. Set to 2 if you are connecting to Hive Server 2. HiveServerType=2 # The authentication mechanism to use for the connection. # Set to 0 for No Authentication # Set to 1 for Kerberos # Set to 2 for User Name # Set to 3 for User Name and Password # Note only No Authentication is supported when connecting to Hive Server 1. AuthMech=2 # The Thrift transport to use for the connection. #Set to 0 for Binary #Set to 1 for SASL #Set to 2 for HTTP # Note for Hive Server 1 only Binary can be used. ThriftTransport=1 # When this option is enabled (1), the driver does not transform the queries emitted by an # application, so the native query is used. # When this option is disabled (0), the driver transforms the queries emitted by an application and # converts them into an equivalent from in HiveQL. UseNativeQuery=0 # Set the UID with the user name to use to access Hive when using AuthMech 2 to 8. UID=sandbox # The following is settings used when using Kerberos authentication (AuthMech 1 and 10) # The fully qualified host name part of the of the Hive Server 2 Kerberos service principal. # For example if the service principal name of you Hive Server 2 is: # hive/myhs2.mydomain.com@EXAMPLE.COM # Then set KrbHostFQDN to myhs2.mydomain.com KrbHostFQDN=[Hive Server 2 Host FQDN] # The service name part of the of the Hive Server 2 Kerberos service principal. # For example if the service principal name of you Hive Server 2 is: # hive/myhs2.mydomain.com@EXAMPLE.COM # Then set KrbServiceName to hive KrbServiceName=[Hive Server 2 Kerberos service name] # The realm part of the of the Hive Server 2 Kerberos service principal. # For example if the service principal name of you Hive Server 2 is: # hive/myhs2.mydomain.com@EXAMPLE.COM # Then set KrbRealm to EXAMPLE.COM KrbRealm=[Hive Server 2 Kerberos realm] # Set to 1 to enable SSL. Set to 0 to disable. SSL=0 # Set to 1 to enable two-way SSL. Set to 0 to disable. You must enable SSL in order to # use two-way SSL. TwoWaySSL=0 # The file containing the client certificate in PEM format. This is required when using two-way SSL. ClientCert= # The client private key. This is used for two-way SSL authentication. ClientPrivateKey= # The password for the client private key. Password is only required for password protected # client private key. ClientPrivateKeyPassword= odbcinst.ini: [ODBC Drivers] Hortonworks Hive ODBC Driver=Installed [Hortonworks Hive ODBC Driver] Description=Hortonworks Hive ODBC Driver Driver=/opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib hortonworks.hiveodbc.ini: [Driver] ErrorMessagesPath=/opt/hortonworks/hiveodbc/ErrorMessages/ LogLevel=0 LogPath= SwapFilePath=/tmp ... View more