Apache Pinot Docs
Search…
latest
Configuration Reference
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

1
select STPOINT(-122, 37) AS value
2
from ignoreMe
Copied!
value
00c05e8000000000004042800000000000
1
select STPOINT(-122, 37, 0) AS value
2
from ignoreMe
Copied!
value
00c05e8000000000004042800000000000
1
select STPOINT(-122, 37, 1) AS value
2
from ignoreMe
Copied!
value
80c05e8000000000004042800000000000
1
select ST_POINT(-122, 37, 1) AS value
2
from ignoreMe
Copied!
value
80c05e8000000000004042800000000000
Copy link