LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Type conversion from Teradata

    Employee
    Posted 05-13-2015 06:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    I'm pulling in some information from a Teradata db and getting an error message as follows:
    WARN: Untranslatable teradata type: 600
    Error Code: brain.node.TDCodes.cpp.52

    ERROR: Node execution terminated while opening i/o streams by error:
    Untranslatable teradata type: 600
    Error Code: lae.node.executionTerminated

    Teradata type 600 is BIGINT, which I suppose would be LONG in Lavastorm. Is there a way within the DBQuery node to convert the data type (since Lavastorm won't currently pull it in, or will I need to cast the data type within Teradata in order to pull it into Lavastorm?
    Thanks,
    Rebecca


  • 2.  RE: Type conversion from Teradata

    Employee
    Posted 05-13-2015 09:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    The solution to this is to use a cast expression in the SQL statement of the DBQuery node, for example,
    select
    serv_ord_days_to_complete_dur
    ,service_order_completed_date
    ,service_order_created_date
    ,cast(service_order_key as varchar (25)) as order_key
    from ndw_shared_views.service_order_fact

    I should probably have figured it out sooner - it's a much simpler solution than I was looking for!