Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: 3.0.0RC1: Changed Table Output Schema not visible

  1. #1

    Default 3.0.0RC1: Changed Table Output Schema not visible

    I needed to add a field to my target table. So I went into pgsql and dropped and recreated the table. I then went back into Database Explorer and did Refresh and selected my table and checked the Layout and it was still the old layout. How do I get it to pick up the new table layout?

    Gerry

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

    Default

    For performance reasons we cache the layout of tables. (queries actually)
    A "clear DB cache" button was added to the "Simple SQL editor" dialog and is also available upon right click on the database connection.

  3. #3

    Default

    Matt,
    That worked good. Didn't know where to look. I had even tried deleting the db conn and recreating it and still it was finding the old layout. Maybe the db cache should be cleared if the connection is deleted.

    Gerry

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.