Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Why is DatabaseMetaData not used?

  1. #1
    Join Date
    Jul 2007

    Default Why is DatabaseMetaData not used?

    The table exists step currently fails on Teradata because reading a row it messes around with timestamp date conversion (different issue may report that in the future).

    While debugging I discovered that DatabaseMetaData is not used to get available tables etc. Is this intentionally.

    I temporarily fixed this by overriding getSQLTableExists in the Teradata meta informations

    public String getSQLTableExists(String tablename)
    return "show table " + tablename;

    since show table is much faster than retrieving data. However, I think in the long run the official JDBC call should be used. Would be willing to supply a patch if there is interest.



  2. #2
    Join Date
    May 2006


    Raise a tracker at under Pentaho Data Integration, and attach there your information.


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.