Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Can not load Null to Datetime field

  1. #1
    Join Date
    Feb 2011
    Posts
    1

    Default Can not load Null to Datetime field

    HI,

    I am getting a trouble loading Null value to a datetime field. If all the rows have data then it loads fine. But if some records are null then it gives and error saying, Conversion error ' string value can't converted to datetime field' Please help . i am fairly new to Pentaho. Please include what transformation I should use and how to get around with this problem.
    Appreciate help in advance

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I would use a Filter Rows and remove any record where the date is null.
    Alternatively, you can replace NULLs with a dumb date, such as 1900/01/01.

    Mick

  3. #3
    Join Date
    Nov 2008
    Posts
    143

    Default

    The downside in adopting a dumb date would be adapting your system to ignore it.
    It's been recently posted something about a parameter that makes kettle treat '' != NULL. Maybe you wanna try that, too.

    BTW, are you loading data from your DB to a step, or from a step to DB?
    If you're loading from DB to step, I'd take it as a problem. If you're saving it to DB, then what Mick and I said, should help.

    Cheers,

    Renato

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.