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

Data source preparation

Throughout the chapter, we will be working with CTools further to build a more interactive dashboard. We will use the nyse_stocks data (please refer to Appendix B, Hadoop Setup, for more details), but need to change its structure. The data source for the dashboard will be a PDI transformation.

Repopulating the nyse_stocks Hive table

Execute the following steps:

  1. Launch Spoon.
  2. Open the nyse_stock_transfer.ktr file from the chapter's code folder.
  3. Move NYSE-2000-2001.tsv.gz within the same folder with the transformation file.
  4. Run the transformation until it is finished. This process will produce the NYSE-2000-2001-convert.tsv.gz file.
  5. Launch your web browser and open Sandbox using the address http://192.168.1.122:8000.
  6. On the menu ...

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