Sunday 15 January 2012

pentaho - Kettle '?' not working Table Input Step -


I want to get all the table names from the database and then get all the rows from the table. So I made a change like this:

  1. Get the table name: The database connection was added and the table name was stored in an output field called "Output".
  2. Table Input: Added the first step in the marked "Change the variable in the script" and "Execute data for each line" to "insert data from step" in the "SELECT * from?" is.
    I have read a lot of tutorials online, which includes
    My problem is that everywhere it says that I am "mine"? The parameter should be replaced with the but this is not the log here:

    2013/06/22 03:33:25 - Get the table name - start to make the run ...
    2013/06/22 03:33:25 - Postgrad 9.1.99 RO - Read: 9 table names with DB meta-data.
    2013/02/22 03:33:25 - Table Input.0 - Query Parameter Found = [stackexchange2]
    2013/06/22 03: 33: 25 - Table Input .0 - SQL Query: Select * From?
    2013/03/22 03:33:25 - Table Input .0 - Error (version 4.4.0-static, creation of 17588 from 2012) 11-21 16.02.21 by buildgue): Unexpected error
    2013 / 06/22 03:33:25 - Table Input.0 - Error (version 4.4.0-static, 2012-11-21 16.02 to 17588 creation) 21 by buildgue): org.pentaho.di.core.exception. KettleDatabaseException:
    2013/06/22 03:33:25 - Table Input.0 - Error (version 4.4.0-static, creation of 17588 from 2012) 11-21 16.02.21 by buildgue): In executing SQL An error occurred:
    2013/06/22 03:33:25 - Table input .0 - Error (version 4.4.0-static, creation of 17588 from 2012-11) -21 16.02.21 by buildgue): SELECT * from?
    2013/02/22 03:33:25 - Table Input 0 - Error (see SIN 4.4.0-static, 2012/01/01 from 16.02.21 build 17577 by BuildUn): Error: "$ 1" Syntax error on or near - status: 16
    2013-02-22 03:33: 25 - Table Input .0 - Error (Version 4.4.0-Fixed, 2012-11-21 16.02 by Building. 21 to 17588): I am using Kettle 4.4 spoon client downloaded

    UPDATE
    I Just want to do this work. I am now learning the tools, and it would be good to know how '?' Works.

    To solve your situation, I like working with jobs, please {kettle_intalation_folder_path } / Examples / Find Jobs / Process all the table processes / all the tables. KJB, because your case is the simplification of that example.

No comments:

Post a Comment