UltipaDocs
Try Playground
  • Introduction
  • Terminologies
    • Reserved Words
    • Data Types
    • Alias
    • Operators
    • Expression
    • Filter
    • Prefix
    • Node and Edge Templates
    • Homologous and Heterologous Data
    • Clause Execution Times
    • Graphset
    • Schema
    • Property
    • Insert
    • Overwrite
    • Upsert
    • Update
    • Delete
    • Find Nodes
    • Find Edges
      • AB
      • Autonet
      • Spread
      • Path Template
      • K-Hop
      • K-Hop Template
    • Find Subgraphs
    • GROUP BY
    • ORDER BY
    • SKIP
    • LIMIT
    • WHERE
    • RETURN
    • WITH
    • UNCOLLECT
    • UNION
    • UNION ALL
    • CALL
    • BATCH
      • Schema Checker
      • Equal
      • Not Equal
      • Less Than
      • Greater Than
      • Less Than or Equal
      • Greater Than or Equal
      • Between
      • Between or Equal
      • Beong to
      • Not Belong To
      • CONTAINS | String
      • CONTAINS | Full-Text
      • Regular Match
      • IS NULL
      • IS NOT NULL
      • And
      • Or
      • Not
      • Exclusive OR
      • DISTINCT
      • toString()
      • toInteger()
      • toFloat()
      • toDouble()
      • toDecimal()
      • toSet()
      • castToRaw()
      • now()
      • dateAdd()
      • dateDiff()
      • year()
      • month()
      • day()
      • dayOfWeek()
      • dateFormat()
      • point()
      • distance()
      • pointInPolygon()
      • lower()
      • upper()
      • reverse()
      • startsWith()
      • endsWith()
      • JSON_decode()
      • JSON_merge()
      • trim()
      • ltrim()
      • rtrim()
      • left()
      • right()
      • substring()
      • replace()
      • split()
      • intersection()
      • difference()
      • listUnion()
      • size()
      • head()
      • reduce()
      • listContains()
      • append()
      • pi()
      • pow()
      • sqrt()
      • abs()
      • floor()
      • ceil()
      • round()
      • sin()
      • cos()
      • tan()
      • cot()
      • asin()
      • acos()
      • atan()
      • length()
      • pnodes()
      • pedges()
      • count()
      • sum()
      • max()
      • min()
      • avg()
      • stddev()
      • collect()
      • dedup()
      • CASE
      • table()
      • coalesce()
      • ifnull()
    • Acceleration
    • Index
    • Full-text
    • LTE
    • Real-time Process
    • Backend Task
    • Analytics Node
    • Server Statistics
    • Server Backup
    • Privilege
    • Policy
    • User
  • Trigger
  1. Docs
  2. /
  3. UQL
  4. /
  5. Index | Full-text | LTE

LTE

LTE

LTE is short for Load to Engine, it loads disk-based properties into Ultipa's high-performance graph computing engine. Before executing LTE, make sure there is adequate memory space. System properties UID, FROM and TO do not support LTE operation. Previously LTE-ed properties will be auto LTE-ed again after a system reboot and a GraphSet re-mount.

NOTE

LTE is a prerequisite when executing inter-step comparison (by path_ascend(), path_descend()), weighted shortest path calculation (by shortest(<property>)) and inter-step filtering (by prev_n, prev_e and alias defined earlier in the same path template).

Syntax:

Syntax
// To load a certain node property under a certain node schema in the current graphset
LTE().node_property(@<schema>.<property>)

// To load a certain node property (if has) under all node schemas in the current graphset
LTE().node_property(@*.<property>)

// To load a certain edge property under a certain edge schema in the current graphset
LTE().edge_property(@<schema>.<property>)

// To load a certain edge property (if has) under all edge schemas in the current graphset
LTE().edge_property(@*.<property>)

UFE

UFE is short for Unload from Engine, it unloads properties not needed for query acceleration from engine, hence saves server memory (the property continues to persist on disk unless it is deleted). Deleting a property will also remove the property from engine, unmounting a GraphSet also unloads its properties, if there is any, from engine.

NOTE

The UFE() will take some time depending on the size of the data, but will not affect other operations.

Syntax:

Syntax
// To unload a certain node property under a certain node schema in the current graphset
UFE().node_property(@<schema>.<property>)

// To unload a certain node property (if has) under all node schemas in the current graphset
UFE().node_property(@*.<property>)

// To unload a certain edge property under a certain edge schema in the current graphset
UFE().edge_property(@<schema>.<property>)

// To unload a certain edge property (if has) under all edge schemas in the current graphset
UFE().edge_property(@*.<property>)