Apache Pinot Docs
latest
Ask or search…
K
Comment on page

STPOINT

This section contains reference documentation for the ST_POINT/STPOINT function.
Returns a geometry or geography type point object with the given coordinate values.

Signature

STPOINT(x, y)
STPOINT(x, y, isGeography)
ST_POINT(x, y)
ST_POINT(x, y, isGeography)

Usage Examples

select STPOINT(-122, 37) AS value
from ignoreMe
value
00c05e8000000000004042800000000000
select STPOINT(-122, 37, 0) AS value
from ignoreMe
value
00c05e8000000000004042800000000000
select STPOINT(-122, 37, 1) AS value
from ignoreMe
value
80c05e8000000000004042800000000000
select ST_POINT(-122, 37, 1) AS value
from ignoreMe
value
80c05e8000000000004042800000000000