Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Pentaho Erase tables

  1. #1
    Join Date
    Jan 2018
    Posts
    2

    Default Pentaho Erase tables

    Good day

    I have to erase all the tables with contain in the name "borr" , i do a table input for adquire all the table names, but i dont know how to do a job to erase all the tables with those names.


    Please help me

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Do you want to delete the data in the tables, or delete (drop) the tables themselves?

  3. #3
    Join Date
    Jan 2018
    Posts
    2

    Default

    I want to drop the tables

  4. #4
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    You could use the "Execute SQL Row" step with "drop table ?" as the script to run, and define the column containing your table names from your stream as the parameter. Be sure to select "Execute for each row"

Tags for this Thread

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.