Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: print query

  1. #1
    Join Date
    Jan 2010
    Posts
    27

    Question print query

    Is it possible to print as log the query I do in a Table input step?
    I'm not sure variables are replaced as I expected.

    Thanks

    Gisella
    Last edited by bronzett; 07-13-2010 at 04:01 AM.

  2. #2
    Join Date
    Feb 2008
    Posts
    107

    Default

    I thought changing the logging level to 'row-level' would have this effect, but it seems that it does not.

    If you are using MySQL, you can change the server options file to log every query executed on the server - see http://dev.mysql.com/doc/refman/5.1/en/query-log.html for details. If you're using another DB, there may be a similar option.

    Cheers,
    Paul

  3. #3
    Join Date
    Jul 2008
    Posts
    18

    Default

    Ciao Gisella,
    have you tried to put logging to a more detailed level?

    If you're trying to print out the parameters that are passed to a table input, you should see something like (I put it to "Basso livello (molto dettagliato)"):

    Table input 2 2.0 - Query parameters found = [103], [France]

    It's not the full query but a simple find/replace inside a SQL window will work.

    Stefano

  4. #4
    Join Date
    Jan 2010
    Posts
    27

    Default

    Thank you Stefano/Paul.

    I'm going to set the log level as you suggest.
    But I need to trace the sql in a log file not only for debugging purpose.

    Thanks again


    Gisella

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.