SAP HANA支持地理空间数据,可以用于存储和查询地理信息。
-- 创建包含地理空间数据的表
CREATE TABLE Locations (
LocationID INT PRIMARY KEY,
Name NVARCHAR(100),
Coordinates ST_GEOMETRY
);
-- 插入地理空间数据
INSERT INTO Locations (LocationID, Name, Coordinates)
VALUES (1, 'Office', NEW ST_POINT('POINT(30.0 10.0)'));
-- 查询距离
SELECT
A.Name AS LocationA,
B.Name AS LocationB,
ST_DISTANCE(A.Coordinates, B.Coordinates) AS Distance
FROM Locations A, Locations B
WHERE A.LocationID = 1 AND B.LocationID = 2;