Call SAP HANA function with table

How to run the HANA SQL function where an output table is required? Example function (from this tutorial): CREATE TYPE "TT_RESTAURANTS" AS TABLE ("node_id" INTEGER, "distance" INTEGER, "hops" BIGINT); CREATE OR REPLACE PROCEDURE "NEAREST_RESTAURANT"(IN startV INT, OUT res "TT_RESTAURANTS") LANGUAGE GRAPH READS SQL DATA AS BEGIN GRAPH g = Graph("SKIING"); VERTEX v_s = Vertex(:g, :startV); MULTISET<Vertex> rests = v IN Vertices(:g) WHERE :v."restaurant" == N'TRUE'; ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (INT "distance" = 0); ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (BIGINT "hops" = 0L); FOREACH rest in :rests { VERTEX v_rest = Vertex(:g, :rest....

November 11, 2021 ยท 1 min