Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: UUID type conversion error:

  1. #1
    Join Date
    Feb 2017
    Posts
    4

    Default UUID type conversion error:

    ERROR: column "id" is of type uuid but expression is of type character varying

    In source DB column ''id" is of type string
    In destination DB column "id" is of type uuid
    We are trying to merge data from source to destination

    Pentaho 7.0 keeps throwing the following error:

    ERROR: column "id" is of type uuid but expression is of type character varying
    Hint: You will need to rewrite or cast the expression.

    To fix this issue ,we tried adding "stringtype = unspecified option in Database settings" in pentaho 7.0 version.Still the issue persists, shows the same error.
    Are there any other alternate solutions for type conversion?

  2. #2
    Join Date
    Feb 2017
    Posts
    4

    Default

    With "stringtype = unspecified option in Database settings" is working ,but issue is with null values.
    Tried to add step "Replace with null values" with default value as "00000000-0000-0000-0000-000000000000" but i want to insert as null value instead of default uuid value, can anybody help pls?

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    It's all in the way you are trying to set the value of the UUID target column, I guess.
    So long, and thanks for all the fish.

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.