SQL

Overview Commands

CRUD & Graph Schema & Buckets Database & Indexes Planning & System

SELECT

CREATE TYPE

ALTER DATABASE

EXPLAIN

INSERT

ALTER TYPE

BACKUP DATABASE

PROFILE

UPDATE

DROP TYPE

EXPORT DATABASE

CONSOLE

DELETE

TRUNCATE TYPE

IMPORT DATABASE

CREATE VERTEX

CREATE BUCKET

ALIGN DATABASE

CREATE EDGE

ALTER BUCKET (not implemented)

CHECK DATABASE

MOVE VERTEX

DROP BUCKET

CREATE INDEX

MATCH

TRUNCATE BUCKET

REBUILD INDEX

TRAVERSE

CREATE PROPERTY

DROP INDEX

ALTER PROPERTY

CREATE MATERIALIZED VIEW

DROP PROPERTY

DROP MATERIALIZED VIEW

CREATE TRIGGER

REFRESH MATERIALIZED VIEW

DROP TRIGGER

ALTER MATERIALIZED VIEW (planned)

Overview Functions

Graph Math Collections Geometric Vector Misc

out()

count()

set()

point()

vectorDimension()

date()

in()

min()

map()

circle()

vectorMin()

duration()

both()

max()

list()

rectangle()

vectorMax()

sysdate()

outE()

sum()

first()

lineString()

vectorSum()

format()

inE()

avg()

last()

polygon()

vectorAvg()

strcmpci()

bothE()

abs()

intersect()

distance()

vectorAdd()

concat()

outV()

pow()

unionall()

geo.geomFromText()

vectorSubtract()

if()

inV()

sqrt()

distinct()

geo.point()

vectorScale()

ifempty()

bothV()

variance()

difference()

geo.lineString()

vectorVariance()

ifnull()

traversedElement()

stddev()

symmetricDifference()

geo.polygon()

vectorStdDev()

coalesce()

traversedVertex()

mode()

geo.buffer()

vectorNormalize()

uuid()

traversedEdge()

median()

geo.envelope()

vectorisNormalized()

encode()

shortestPath()

percentile()

geo.distance()

vectorHasNaN()

decode()

dijkstra()

randomInt()

geo.area()

vectorHasInf()

bool_and()

astar()

geo.asText()

vectorDotProduct()

bool_or()

geo.asGeoJson()

vectorMagnitude()

expand()

geo.x()

vectorL1Norm()

version()

geo.y()

vectorLInfNorm()

SEARCH_INDEX()

geo.within()

vectorL2Distance()

SEARCH_FIELDS()

geo.intersects()

vectorCosineSimilarity()

SEARCH_INDEX_MORE()

geo.contains()

vectorQuantizeInt8()

SEARCH_FIELDS_MORE()

geo.dWithin()

vectorDequantizeInt8()

geo.disjoint()

vectorQuantizeBinary()

geo.equals()

vectorApproxDistance()

geo.crosses()

vectorClip()

geo.overlaps()

vectorMultiScore()

geo.touches()

vectorHybridScore()

vectorRRFScore()

vectorNormalizeScores()

vectorScoreTransform()

vectorSparsity()

vectorDenseToSparse()

vectorSparseToDense()

vectorSparseCreate()

vectorSparseDot()

vectorToString()

vectorNeighbours()

Extended Functions (APOC Compatible)

ArcadeDB provides 100+ additional functions organized by namespace. These are available in both SQL and Cypher queries. See reference/extended-functions.adoc#extended-functions for the complete reference.

Agg/Util Convert/Date Map Text Vector

agg.median()

convert.toJson()

map.merge()

text.jaroWinklerDistance()

vector.cosinesimilarity()

agg.statistics()

convert.fromJsonMap()

map.flatten()

text.levenshteinDistance()

vector.dotproduct()

util.compress()

date.add()

map.fromLists()

text.levenshteinSimilarity()

vector.l2distance()

util.md5()

date.format()

map.groupBy()

text.hammingDistance()

vector.neighbors()

util.sha256()

date.toISO8601()

map.setKey()

text.sorensenDiceSimilarity()

vector.normalize()

Overview Methods

Conversions String manipulation Collections Geometric Misc

convert()

append()

[]

isWithin()

exclude()

asBoolean()

capitalize()

size()

intersectsWith()

include()

asByte()

charAt()

remove()

type()

asDate()

indexOf()

removeAll()

javaType()

asDateTime()

lastIndexOf()

keys()

hash()

asDecimal()

left()

values()

ifempty()

asDouble()

right()

transform()

ifnull()

asFloat()

trim()

field()

precision()

asInteger()

trimPrefix()

sort()

asJSON()

trimSuffix()

join()

asList()

replace()

asLong()

length()

asMap()

subString()

asRecord()

toLowerCase()

asRID()

toUpperCase()

asSet()

normalize()

asShort()

split()

asString()

format()

prefix()