Data360 DQ+

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

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  CONCATENATE function in SQL Node

    Posted 11-12-2019 07:24

    I am able to find "CONCATENATE" function in the list of functions available in the SQL Node (when I press Ctrl+Space)

    But when used, I get the following error:

    "{operationId:"sql.sql", message:"Undefined function: 'CONCATENATE'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'.; line 1 pos 7"}"



  • 2.  RE: CONCATENATE function in SQL Node

    Employee
    Posted 12-09-2019 14:17

    Hi Jayashree,

      The SQL node uses Spark SQL, so the equivalent to CONCATENATE is actually "concat".  

     

    Thanks,

    Jeff