Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Create automatic table

  1. #1

    Default Create automatic table

    In SqlServer i can create and insert data in this mode:

    SELECT
    c1,
    c2
    INTO
    t1
    FROM
    t2
    WHERE
    c3 = 0;

    In Oracle in this mode
    :

    CREATE TABLE t1 as
    SELECT c1, c2
    FROM t2;

    INSERT INTO t1(
    SELECT c1, c2
    INTO
    t1
    FROM
    t2
    WHERE
    c3 = 0);

    Is there a method to do this operation in standard mode with kettle 3.1.0?
    How can i create a dynamic table from a SQL select?

    Thanks in advance.

    Bye,
    Roberto



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

    Default

    Via exec sql it should normally work. (if you trigger it). Not really adviced.

    Regards,
    Sven

  3. #3

    Default Another solution...

    Via exec SQL? It 'not what I want to do!

    I want to use Spoon to be independent of the Oracle SQL code, SqlServer SQL code, ecc...


    Bye,
    Roberto





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

    Default

    Ah then no ... CTOS is not built in yet... no short term plans to build it in as it would not really fit PDI (it's not moving around rows).

    Regards,
    Sven

  5. #5

    Default So...

    So I understand what I'm working db and launch the code for SQL db(Oracle, SqlServer,...)?

    It 'the only solution?

    Or create static tables and run the tag insert / update!


    Thanks for your cooperation,
    Roberto

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

    Default

    Dear ,

    This sort of thing is technically possible. However, it is not advised in any way to follow this path.
    I know how to do it, but I refuse to tell anyone

    Take care,
    Matt

  7. #7

    Default No icon!

    I do not expect me this response from someone that I estimated very. I will find a solution with my team.

    Excuse me if I am wrong. With my post I wanted to stimulate interest on the subject.


    Regards,
    Roberto

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.