Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: What could be a strategy to purge log tables?

  1. #1
    Join Date
    Sep 2011
    Posts
    190

    Question What could be a strategy to purge log tables?

    Aloha,

    Simply opening jobs and transformations in Spoon is getting slower and slower.

    What could be a strategy to purge to spoon/kettle logtables?

    Can I delete everything older than X days? If so, what column could be useful, enddate?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    4.2 only loads the last couple of entries from the log table... AND provides automatic cleanup.
    The log date is the actual end of the transformation. Depdate is the start.

  3. #3
    Join Date
    Sep 2011
    Posts
    190

    Default

    Thanks!

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.