Create Hive Database Connection

Create a Database Connection to Hive

If you already have a shared Hive Database Connection defined within PDI then this task may be skipped.

1. Start PDI on your desktop. Once it is running choose 'File' -> 'New' -> 'Job' from the menu system or click on the 'New file' icon on the toolbar and choose the 'Job' option.
   
   
2. Create a New Connection: In the View Palette right click on 'Database connections' and select 'New'.
   
   
   
3. Configure the Connection: In the Database Connections window enter the following:
   1. Connection Name: Enter 'Hive'
   2. Connection Type: Select 'Hadoop Hive'
   3. Host Name and Port Number: Your connection information. For local single node clusters use 'localhost' and port '10000'.
   4. Database Name: Enter 'Default'
      When you are done your window should look like:
      
      Click 'Test' to test the connection.
      If the test is successful click 'OK' to close the Database Connection window.