1 of 1

MKSTRING

This page describes the MKSTRING function in Lenses SQL.

MKSTRING(anyType)

Returns a string representation of any given value.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    MKSTRING(tpep_dropoff_datetime), 
    dropoff_latitude 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "MKSTRING": "\"2016-01-01 00:11:14\"",
    "dropoff_latitude": "40.865577697753906"
  }
}

This page describes the MKSTRING function in Lenses SQL.

MKSTRING(anyType)

Returns a string representation of any given value.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    MKSTRING(tpep_dropoff_datetime), 
    dropoff_latitude 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "MKSTRING": "\"2016-01-01 00:11:14\"",
    "dropoff_latitude": "40.865577697753906"
  }
}