-
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... -
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 ... -
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... -
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 Spark SQL Query Engine
Delta Lake Delta Lake with Microsoft Azure Blob Storage Hudi Iceberg Kudu Hive Apache Paimon (Incubating) TiDB TPC-DS TPC-H -
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... -
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 ... -
String Functions
replace split left right substring rTrim lTrim trim toLower toUpper reverse toString replace replace() returns a string in which all occurrences of a specified strin... -
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' , $$... -
AWS
Iceberg AWS Integrations Iceberg provides integration with different AWS services through the iceberg-aws module. This section describes how to use Iceberg with AWS. Enabling ...
