Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Truncate table cascade with kettle v3.0.0.GA

  1. #1
    Join Date
    Mar 2007
    Posts
    216

    Smile Truncate table cascade with kettle v3.0.0.GA

    Hi,

    Is it possible to truncate cascade table in Spoon v3.0.0.GA ?
    In PDI v3.0.0.GA, in a transformation, in a step Table Output, you can tick the box Truncate Table.
    Doing so will empty the table before doing the insert.
    My transformation stops with an error like "cannot truncate a table which have a constraint / which is referenced by a foreign key"
    The SQL TRUNCATE can be writtent like this : TRUNCATE mytable CASCADE to bypass this problem.
    Doing so will empty the table and all other tables depending on it.
    I wonder if there is a way to add the CASCADE option in Spoon.

    a+,=)
    -=Clément=-
    Last edited by clement; 11-20-2007 at 12:26 PM.

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

    Default

    Currently not... and it sounds dangerous

    Regards,
    Sven

  3. #3
    Join Date
    Mar 2007
    Posts
    216

    Talking

    Hi,

    Quote Originally Posted by sboden View Post
    Currently not... and it sounds dangerous

    Regards,
    Sven
    Thanks, you're probably right
    I deleted all FK constraints as they are not critical for now.

    a+, =)
    -=Clément=-

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.