Data360 DQ+

 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