Revolving around the core of technology
You will need to fill out the following fields:
|Data Source Name/Description||This is a friendly name you want to apply to this Data Source.|
|Host Name||Enter the IP Address/Hostname of the machine where Apache Hive is running.|
|Port Number||Specify the port number of Apache Hive. By default, the port number is 10000.|
|Database Name||Select the Database from your project you want to connect to. The default database name is "Default"|
Once you specify your credentials, click the "Test Connect" button at the bottom. A new popup will show up, where you will need to specify your User Name and Password (if specified).
Once the username and password are specfied, click on OK. You will see a "Connection established" message popup if WinSQL is able to connect.
Now that we are successfully connected, we can begin running queries and modifying the database.
For example, I am adding a new vendor named Susan who has 100 spinach, 1000 broccoli, 500 lettuce and 200 carrots:
If I browse the data I can see that there is now a vendor:
Using your ODBC query tool you can interact with Hive easily. The benefit is that you also get the entire suite of your chosen tool as well as a much more informative interface.
Once you are connected to your Apache Hive in WinSQL, you will be able to see all of your tables and data within WinSQL. To begin importing data directly from Microsoft Excel, simply drag and drop the .xlsx file directly into your Tables section as seen here: