system.rst

System Functions

Table of contents

• TYPEOF

TYPEOF

Description

Usage: typeof(expr) function returns name of the data type of the value that is passed to it. This can be helpful for troubleshooting or dynamically constructing SQL queries.

Argument type: ANY

Return type: STRING

Example:

os> source=people | eval `typeof(date)` = typeof(DATE('2008-04-14')), `typeof(int)` = typeof(1), `typeof(now())` = typeof(now()), `typeof(column)` = typeof(accounts) | fields `typeof(date)`, `typeof(int)`, `typeof(now())`, `typeof(column)`
fetched rows / total rows = 1/1
+----------------+---------------+-----------------+------------------+
| typeof(date)   | typeof(int)   | typeof(now())   | typeof(column)   |
|----------------+---------------+-----------------+------------------|
| DATE           | INTEGER       | DATETIME        | STRUCT           |
+----------------+---------------+-----------------+------------------+