![]() ![]() When the Start Menu comes up, scroll down until you see the Administrative Tools folder. When connecting to a cluster that has Kerberos authentication enabled, fill in the Kerberos principal for the HiveServer2 or Impala service, for Click OK. Method 2: Open ODBC Data Source Administrator from Start Menu.The default port number is 21050 for an Impala node, or 10000 for an Apache Hive server.For Hive, always leave the Type field blank. For Impala, leave the Type field blank when connecting to an Impala node secured with Kerberos authentication, or enter HS2NoSASL for the Type field if the node is not secured by Kerberos.To connect to Impala, specify the details for any node in the cluster that is running the impalad daemon. Enter the hostname or IP address and the port number. Function of Windows ODBC manager User DSN: The storage takes place in the registry under: HKEYCURRENTUSERSoftwareODBCODBC.INI System DSN: The storage.The data source could be a Cloudera Impala server or an Apache Hive server. Fill in the fields with the the details of your data source.The Hive ODBC DSN Configuration dialog box appears. (This assumes you have first installed the driver per steps 1 and 2 above). Select the Cloudera ODBC Driver for Apache Hive and click Finish. ![]() In the ODBC Data Source Administrator window, click the System DSN tab, then click Add.(Note that on a 64-bit Windows system, you must select the 32-bit binary, not the 64-bit binary.) In the search results, double-click ODBC Administrator.If you do not find the administrator utility in its default location, type odbc administrator into the Search box of the Windows Start menu.On some systems, the 32-bit version of the ODBC administrator is located at %systemdrive%\Windows\SysWoW64\odbcad32.exe.After the driver is installed, find and run the ODBC Data Source Administrator.The license is accepted automatically when you install in silent mode. And the data is loaded into the element.For example, to install in the default location:ĬlouderaHiveODBCSetup_v2_00.exe /S /D="C:\Program Files (x86)\Hive ODBC" The Status is now listed as Download succeeded at date and time.Select Database pulldown and select the database file we created called GenericDatabase.Do this 32-bit Windows 7 (64-bit): Double-click the odbcad32.exe file in the C:WindowsSysWOW64 folder. Open the Database tab of the data element called Constant_Generic_Scalar. Configuring an ODBC client driver For FileMaker Pro.Open GoldSim example file: GenericDatabase.gsm.Enter Data Source Name as the same name as your database file. Click Ok.Locate and select the specific database file you wish to connect.within database section and locate your database file. ![]() Note, the selected driver in this example is for Microsoft Access. odbc.ini (begins with a period) would be located in the home directory of the user ID that.
0 Comments
Leave a Reply. |