-
Spark Queries
Querying with SQL Querying Mixed-Format table by merge on read Query on change store Querying with DataFrames Querying with SQL Querying Mixed-Format table by merge on read ... -
User defined functions
Users may add custom functions to AGE. When using Cypher functions, all function calls with a Cypher query use the default namespace of: ag_catalog . However if a user wants to us... -
SKIP
Introduction Skip first three rows Return middle two rows Using an expression with SKIP to return a subset of the rows SKIP defines from which record to start including the r... -
Object
clone values eqProps keys omit pick pickAll project prop props clone {*} → {*} Parameters valueThe object or array to clone Returns * A deeply cloned copy of val... -
Scalar Functions
id start_id end_id type properties head last length size startNode endNode timestamp toBoolean toFloat toInteger coalesce id id() returns the id of a vertex or e... -
Predicate Functions
Exists(Property) Exists(Path) Predicates are boolean functions that return true or false for a given set of input. They are most commonly used to filter out subgraphs in the WHE... -
Connectors For Flink SQL Query Engine
Apache Paimon (Incubating) Hudi Iceberg -
Design & Concepts
Apache Hudi Stack Timeline File Layouts Table & Query Types Indexing Write Operations Key Generation Record Payload Schema Evolution Metadata Table Concurrency Control -
Numeric Functions
rand abs ceil floor round sign rand rand() returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e.[0,1). The numbers returned follow ... -
Logarithmic Functions
e sqrt exp log log10 e e() returns the base of the natural logarithm, e. Syntax: e() Returns: An agtype float . Query SELECT * FROM cypher ( 'graph_name' , $$...