Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: auto create table

  1. #1
    Join Date
    Dec 2005
    Posts
    6

    Default auto create table

    Hi,

    How can I export the create table statement to a file or stream?
    I would create (or alter) the table if not exists or different rather than push the "Get SQL" button every time.
    Is that possible with pan?

    Regards
    Gergo

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

    Default

    The "Get SQL" is for spoon only... the reason for not making putting it closer to the transformations is that the get SQL is not 100% correct in all cases. So if you would run it automatically you would have a chance of blowing away some things.

    It also doesn't do things like indexing and access rights e.g.

    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.