Again, make sure that you have deployed the driver files for this connection to all your QuerySurge Agents. Congratulations! You’ve created a QuerySurge Connection.Note: You must have an Agent running with the driver for this Connection deployed in order to test the Connection. If you entered a Test Query, you can click on Test Connection (A).A query of the type: "Select * from myhivetable limit 1" is suggested. You can provide an optional Test Query if you want to test your Connection.Required fields for your Connection Type are marked by an *. This includes the Server name or IP address, the port (the default Hive port will automatically populate), the database name and login credentials if required. Provide the connection information to Hive.Once you have collected this information, you are ready to click Next. Once you have selected your Data Source, the Wizard will tell you what information you are likely to need in order to create your Connection.Note: Check the Advanced Mode checkbox for access to advanced features. Click on the Add button at the bottom left of the page to launch the Add Connection Wizard.To configure a Connection, select Configuration > Connection in the Administrative View tree (at the left).Note: You can see how to deploy driver jar files to Agents here (Windows) and here (Linux). Awesome Titles Title Generator :Generate random addresses, name. ![]() If your distro and version are different, you'll need to find paths and files corresponding to your version on your Hive server. The spirit of xbox gamertag ip lookup the source from whence that jou Hepullicans have. usr/lib/hadoop/hadoop-common-X.X.X-cdhX.X.X.jar usr/lib/hive/lib/hive-jdbc-X.X.X-cdhX.X.X-standalone.jar usr/hdp/X.X.X.X-XXXX/hadoop/client/hadoop-common-X.X.X.X.X.X.X-XXXX.jarįor CDH distros ('X's refer to version and distro numbers): usr/hdp/X.X.X.X-XXXX/hive/lib/hive-jdbc-X.X.X-standalone.jar However, due to the possibility of version mismatches, we recommend that you copy your driver jar files from your Hive server to your QuerySurge Agent. Get the JDBC driver jars for your Hive distro from your Hive server (asterisks indicate distribution-specific notations):įor HDP distros ('X's refer to version numbers): Note: Hive drivers are bundled in the QuerySurge installer, so you can install a Hive driver from the Installer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |