1 of 3

Schema

This page describes how to use schema functions in Lenses SQL Processors.

TYPEOF

This page describes the TYPEOF function in Lenses SQL.

Returns the object type of a complex expression. This can only be used when the format on the wire includes the details of the object's full name.

Available in:

Processors

SQL Studio

DUMP

This page describes the DUMP function in Lenses SQL.

DUMP(expr)

Show the internal representation of a value.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DUMP(id) AS dump_id,
    DUMP(users_id) AS dump_users_id,
    DUMP(created_at) AS dump_created_at,
    DUMP(modified_at) AS dump_modified_at,
    DUMP(email) AS dump_email,
    DUMP(first_name) AS dump_first_name,
    DUMP(last_name) aAS s dump_last_name
FROM users-events
WHERE modified_at IS NULL
LIMIT 1;

Output:

{
  "value": {
    "dump_id": "io.lenses.sql.model.StringValue@StringValue(8c8b3c3a-7fa9-43bd-a8d2-1290e3940e49)",
    "dump_users_id": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_created_at": "io.lenses.sql.model.StringValue@StringValue(2023-10-29T22:20:50.010963)",
    "dump_modified_at": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_email": "io.lenses.sql.model.StringValue@StringValue(Brenda.Pierce@hotmail.com)",
    "dump_first_name": "io.lenses.sql.model.StringValue@StringValue(Brenda)",
    "dump_last_name": "io.lenses.sql.model.StringValue@StringValue(Pierce)"
  }
}

DUMP

This page describes the DUMP function in Lenses SQL.

DUMP(expr)

Show the internal representation of a value.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DUMP(id) AS dump_id,
    DUMP(users_id) AS dump_users_id,
    DUMP(created_at) AS dump_created_at,
    DUMP(modified_at) AS dump_modified_at,
    DUMP(email) AS dump_email,
    DUMP(first_name) AS dump_first_name,
    DUMP(last_name) aAS s dump_last_name
FROM users-events
WHERE modified_at IS NULL
LIMIT 1;

Output:

{
  "value": {
    "dump_id": "io.lenses.sql.model.StringValue@StringValue(8c8b3c3a-7fa9-43bd-a8d2-1290e3940e49)",
    "dump_users_id": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_created_at": "io.lenses.sql.model.StringValue@StringValue(2023-10-29T22:20:50.010963)",
    "dump_modified_at": "io.lenses.sql.model.NullValue$@NullValue",
    "dump_email": "io.lenses.sql.model.StringValue@StringValue(Brenda.Pierce@hotmail.com)",
    "dump_first_name": "io.lenses.sql.model.StringValue@StringValue(Brenda)",
    "dump_last_name": "io.lenses.sql.model.StringValue@StringValue(Pierce)"
  }
}