Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

UUID()

Returns a Universal Unique Identifier (UUID).

Code Block
languagesql
titleUUID Example
SELECT uuid() AS uuid FROM stream
=> 64c82e4c-7314-45e2-8ee2-c7283f6dbb74

Hash(Object o)

Returns the hash value of an object

Code Block
languagesql
titleHash Example
SELECT hash(value) AS hash FROM stream
=> 1402455053

Eval(String s)

Evaluates arbitrary expressions.

Code Block
languagesql
titleEval Example
SELECT eval("2+3") as result FROM stream
=> 5

Sleep(Number time)

Causes the currently executing operator to sleep for the specified number of milliseconds.

eIf(Expression e, Object true, Object false)

Returns the first Object if the expression evaluates to true else the second Object.

Code Block
languagesql
titleeIf Example
SELECT eif(1>0, "Greater than 0", "Lower or equal") AS result FROM stream
=> Greater than 0

Read(String path)

Reads the content of an arbitrary file and returns the content as a string.

Mem()

Returns the current used memory by the Java Virtual Machine in bytes.

Code Block
languagesql
titleMem Example
SELECT mem() AS mem FROM stream
=> 230445616

Load()

Returns the current system load average for the last minute.

Code Block
languagesql
titleLoad Example
SELECT load() AS load FROM stream
=> 2.77

Uptime()

returns the uptime of the Java Virtual Machine in milliseconds.

Code Block
languagesql
titleUptime Example
SELECT uptime() AS uptime FROM stream
=> 481030

storedLine(String storage, Vector hierarchy, Vector row)

Returns the line stored in an associative storage given by the first parameter at the hierarchy given by the second parameter at the row given by the third parameter.

Code Block
languagejs
SELECT storedLine("Storage", [123, 456], [3]) AS line FROM stream
=> [0,1,0,1,0]

storedValue(String storage, Vector hierarchy, Vector row)

 Returns the value stored in an associative storage given by the first parameter at the hierarchy given by the second parameter at the row given by the third parameter.

Code Block
languagejs
SELECT storedValue("Storage", [123, 456], [3,2]) AS value FROM stream
=> 0

 

Table of Contents