Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: INSERT INTO syntax Teradata

  1. #1

    Question INSERT INTO syntax Teradata

    Hi ,

    I have a transformation trying to load from a CSV file to
    a Teradata table.

    The SQL being generated looks like :

    INSERT INTO "db_name.tbl_name"(ID, END_DATE) VALUES ( ?, ?)

    This is illegal in Teradata, it should be either

    INSERT INTO "db_name"."tbl_name"(ID, END_DATE) VALUES ( ?, ?)

    or (no quotes :

    INSERT INTO db_name.tbl_name (ID, END_DATE) VALUES ( ?, ?)

    Is there a way to configure the SQL, or if not, any workarounds ?

    Thanks
    Last edited by andre_pentaho; 04-16-2008 at 05:48 PM.

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

    Default

    upgrade... In v3.0.2 that should have been fixed, and there are some options in the database connect dialog to direct the quoting.

    If it's not solved raise a JIRA at http://jira.pentaho.org/browse/PDI

    Regards,
    Sven

  3. #3

    Default INSERT INTO syntax Teradata

    Hi Sven,

    Thanks for your response.
    I am using version 3.0.2 build 538

    I will put in a JIRA.

    Thanks

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

    Default

    I very much doubt that this is a bug. You do need to specify

    Schemaname : db_name
    Tablename : tbl_name

    The quotes are probably generated because you put a dot (.) in a table-name.

    Matt

  5. #5

    Default

    Hi Sven, yes, specifying the database as the schema name corrected it.
    Thank you and sorry for the confusion.

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.