O'Reilly logo

Pentaho for Big Data Analytics by Feris Thia, Manoj R Patil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data to Hive

Before we begin the walkthrough, see Appendix A, Big Data Sets, to complete the Hive nyse_stocks data preparation and follow these steps:

  1. Launch Spoon if you have closed it.
  2. On the File menu, click on New and select Transformation.
  3. On the left-hand side panel, click on the View tab.
  4. Right-click on the Database connections node to show up a contextual menu and choose New.

The following screenshot shows you how to create a new database connection:

Importing data to Hive

When the Database Connection dialog appears, fill in the following configuration:

  • Connection Name: HIVE2
  • Connection Type: Hadoop Hive 2
  • Host Name: [your working IP address]
  • Database Name:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required