Does mode support UDF with bigquery?

Hi there,

I have a query works well in bigquery, but mode is throwing error:

Syntax error: Unclosed triple-quoted string literal

here is the query. Am I missing anything?

#standardSQL

CREATE TEMP FUNCTION JsonArray(input STRING)
    RETURNS ARRAY<STRING>
    LANGUAGE js AS """
    return JSON.parse(input);
""";
SELECT JsonArray('["x","y","z"]')

Thanks,

Stone

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Stone Zhong , This is currently a known issue in Mode.  We've filed it with the development team and will let you know when we think we have a fix for this issue.  Thanks!

    Reply Like
  • Thank you Donna for the prompt response.

    Regards,

    Stone

    Reply Like
  • Is UDF something that works nowadays? 

    Reply Like
reply to topic
Like Follow
  • 4 mths agoLast active
  • 3Replies
  • 347Views
  • 4 Following

Create A New Discussion

Share your thoughts