Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Change Date format through metadata injection

  1. #1
    Join Date
    Apr 2009
    Posts
    12

    Default Change Date format through metadata injection

    I'm trying to copy some 100+ tables from MySQL (table input SELECT *) to Snowflake (SF Bulk Loader). When trying to copy data across these the timestamp fields needs to be converted from YYYY/MM/DD HH:MM:SS --> YYYY-MM-DD HH:MM:SS for snowflake to accept them. Problem is that I don't know a priori which fields have timestamps and I want to avoid mapping each table manually.

    So I'm wondering if anyone knows a way of using meta-data injection to identify which are the inbound timestamp fields and apply a Format of YYYY-MM-DD HH:MM:SS to them automatically?

    thx, sebastian

  2. #2
    Join Date
    Apr 2009
    Posts
    12

    Default

    I was able to solve this one on my own by setting a different default timestamp format in kettle.properties:

    KETTLE_DEFAULT_TIMESTAMP_FORMAT=yyyy-MM-dd HH:mm:ss

    so no need to use metadata-injection for this.

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.