MapReduce服务 MRS-CarbonData表空间索引语法说明:快速示例

时间：2025-02-12 14:58:21

MapReduce服务 MRS CarbonData语法参考

快速示例

create table IF NOT EXISTS carbonTable(COLUMN1    BIGINT,LONGITUDE    BIGINT,LATITUDE    BIGINT,COLUMN2    BIGINT,COLUMN3    BIGINT)STORED AS carbondataTBLPROPERTIES ('SPATIAL_INDEX.mygeohash.type'='geohash','SPATIAL_INDEX.mygeohash.sourcecolumns'='longitude, latitude','SPATIAL_INDEX.mygeohash.originLatitude'='39.850713','SPATIAL_INDEX.mygeohash.gridSize'='50','SPATIAL_INDEX.mygeohash.minLongitude'='115.828503','SPATIAL_INDEX.mygeohash.maxLongitude'='720.000000','SPATIAL_INDEX.mygeohash.minLatitude'='39.850713','SPATIAL_INDEX.mygeohash.maxLatitude'='720.000000','SPATIAL_INDEX'='mygeohash','SPATIAL_INDEX.mygeohash.conversionRatio'='1000000','SORT_COLUMNS'='column1,column2,column3,latitude,longitude');

上一篇：MapReduce服务 MRS-CarbonData表空间索引语法说明:建表

下一篇：MapReduce服务 MRS-CarbonData表空间索引语法说明:建表