You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Peeyush Gupta (Jira)" <ji...@apache.org> on 2025/04/29 14:44:00 UTC

[jira] [Created] (ASTERIXDB-3603) Support transform functions

Peeyush Gupta created ASTERIXDB-3603:
----------------------------------------

             Summary: Support transform functions
                 Key: ASTERIXDB-3603
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3603
             Project: Apache AsterixDB
          Issue Type: Improvement
          Components: FUN - Functions
            Reporter: Peeyush Gupta


We should support a special type of functions that take a document as an argument and returns a transformed documnet.



CREATE TRANSFORM FUNCTION OrderTransform2 (ord)

{ SELECT orderno, custid, order_date, ship_date,

         (SELECT VALUE SUM(i.qty * i.price) FROM o.items as i)[0] AS total

  FROM [ord] AS o };



--
This message was sent by Atlassian Jira
(v8.20.10#820010)