![]() # The password for the client private key. This is used for two-way SSL authentication. # The file containing the client certificate in PEM format. # The realm part of the of the Hive Server 2 Kerberos service principal. # 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: # The fully qualified host name part of the of the Hive Server 2 Kerberos service principal. # The following is settings used when using Kerberos authentication (AuthMech 1 and 10) # Set the UID with the user name to use to access Hive when using AuthMech 2 to 8. # converts them into an equivalent from in HiveQL. # When this option is disabled (0), the driver transforms the queries emitted by an application and # application, so the native query is used. # When this option is enabled (1), the driver does not transform the queries emitted by an # Note for Hive Server 1 only Binary can be used. # The Thrift transport to use for the connection. ![]() # Note only No Authentication is supported when connecting to Hive Server 1. # The authentication mechanism to use for the connection. Set to 2 if you are connecting to Hive Server 2. # Set to 1 if you are connecting to Hive Server 1. # HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1). # The namespace on ZooKeeper under which Hive Server 2 znodes are added. # Note service discovery is not support when using Hive Server 1. # Set to 1 to do Hive Server 2 service discovery using ZooKeeper. # Set to 0 to when connecting directory to Hive Server 2 (No Service Discovery). # The name of the database schema to use when a schema is not explicitly specified in a query. # discovery mode as the port is specified in the HOST connection attribute. This is not required when using ZooKeeper as the service # When using ZooKeeper as the Service Discovery Mode, specify a comma-separated list of ZooKeeper # When using No Service Discovery, specify the IP address or host name of the Hive server. # Driver: The location where the ODBC driver is installed to.ĭriver=/opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib # This key is not necessary and is only to give a description of the data source.ĭescription=Hortonworks Hive ODBC Driver DSN Sample Hortonworks Hive DSN=Hortonworks Hive ODBC Driver # Specify any global ODBC configuration here such as ODBC tracing. I'm using the same version of OS X and Excel he's using. This is in an attempt to contact the sandbox. 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. Once there, the data source appears as a system DSN. 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. opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib (for architecture x86_64): Mach-O 64-bit dynamically linked shared library x86_64 opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib (for architecture i386): Mach-O dynamically linked shared library i386 opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib: Mach-O universal binary with 2 architectures SUCCESS: Loaded /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylibįile command also displays that its a shared library which supports i386 and x86_64 HW13382:~ srai$ file /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib HW13382:~ srai$ dltest /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib ![]() My version details: OSX El Capitan ~]# hadoop version
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |