Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: sql query

  1. #1

    Default sql query

    hi !!

    i have a preoblem to execute a sql query with kettle:

    i have a table which contains many fields , i want to execute a query which counts a number of repetition of an element, then store the result (the count) in a field in another table.

    plz answer , i can go on without resolve this.
    Thanks.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Just put the SQL query you would use to group items in a table input and you're ok. Alternatively you can use a group by step, but if you should need regular groups the "group by" of your database engine is faster.

    Regards,
    Sven

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.