![]() ![]() # 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 |