语法 float ST_MaxDistance(geometry g1,geometry g2);参数 参数名称 描述 g1 第一个Geometry对象。g2 第二个Geometry对象。描述 如果g1和g2是相同的对象,则该函数将返回该对象中彼此距离最远的两个顶点之间的距离。示例 默认调用:SELECT...
语法 float ST_MaxDistance(geometry g1,geometry g2);参数 参数名称 描述 g1 第一个Geometry对象。g2 第二个Geometry对象。描述 如果g1和g2是相同的对象,则该函数将返回该对象中彼此距离最远的两个顶点之间的距离。示例 默认调用:SELECT...
3DDWithin function:SELECT ST_3DDWithin(g1,g2,2),ST_3DDFullyWithin(g1,g2,2)from(SELECT 'LINESTRING(0 1 0,1 1 0)':geometry as g1,'LINESTRING(0 0 0,0-1 0)':geometry as g2)as test;st_3ddwithin|st_3ddfullywithin-+-t|f(1 row)
3DDWithin function:SELECT ST_3DDWithin(g1,g2,2),ST_3DDFullyWithin(g1,g2,2)from(SELECT 'LINESTRING(0 1 0,1 1 0)':geometry as g1,'LINESTRING(0 0 0,0-1 0)':geometry as g2)as test;st_3ddwithin|st_3ddfullywithin-+-t|f(1 row)
3DDWithin function:SELECT ST_3DDWithin(g1,g2,2),ST_3DDFullyWithin(g1,g2,2)from(SELECT 'LINESTRING(0 1 0,1 1 0)':geometry as g1,'LINESTRING(0 0 0,0-1 0)':geometry as g2)as test;st_3ddwithin|st_3ddfullywithin-+-t|f(1 row)
示例 对比ST_OrderingEquals和 ST_Equals:SELECT ST_Equals(g1,g2),ST_OrderingEquals(g1,g2)FROM(SELECT 'LINESTRING(0 1,2 3)':geometry as g1,'LINESTRING(2 3,0 1)':geometry as g2)as test;st_equals|st_orderingequals-+-t|f(1 row)
示例 对比ST_OrderingEquals和 ST_Equals:SELECT ST_Equals(g1,g2),ST_OrderingEquals(g1,g2)FROM(SELECT 'LINESTRING(0 1,2 3)':geometry as g1,'LINESTRING(2 3,0 1)':geometry as g2)as test;st_equals|st_orderingequals-+-t|f(1 row)
示例 对比ST_OrderingEquals和 ST_Equals:SELECT ST_Equals(g1,g2),ST_OrderingEquals(g1,g2)FROM(SELECT 'LINESTRING(0 1,2 3)':geometry as g1,'LINESTRING(2 3,0 1)':geometry as g2)as test;st_equals|st_orderingequals-+-t|f(1 row)
G1_Young_Generation_Time link_jobmanager_Status_JVM_GarbageCollector_G1_Old_Generation_Time flink_taskmanager_job_task_operator_dtNumBytesIn 可以发现前四个指标都是G1垃圾收集,其前缀符合flink_jobmanager_Status_JVM_...
G1_Young_Generation_Time link_jobmanager_Status_JVM_GarbageCollector_G1_Old_Generation_Time flink_taskmanager_job_task_operator_dtNumBytesIn 可以发现前四个指标都是G1垃圾收集,其前缀符合flink_jobmanager_Status_JVM_...
Known Text(WKT)string that represents a geometry object or a geography object.The WKT string that is returned does not contain spatial reference identifier(SRID)metadata.Syntax text ST_AsText(geometry g1);text ST_AsText...
Known Text(WKT)string that represents a geometry object or a geography object.The WKT string that is returned does not contain spatial reference identifier(SRID)metadata.Syntax text ST_AsText(geometry g1);text ST_AsText...
Known Text(WKT)string that represents a geometry object or a geography object.The WKT string that is returned does not contain spatial reference identifier(SRID)metadata.Syntax text ST_AsText(geometry g1);text ST_AsText...
st_touches-t(1 row)Obtain an intersection that does not meet one of the DE-9IM conditions.SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as ...
st_touches-t(1 row)Obtain an intersection that does not meet one of the DE-9IM conditions.SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as ...
st_touches-t(1 row)Obtain an intersection that does not meet one of the DE-9IM conditions.SELECT ST_Touches(g1,g2),ST_Relate(g1,g2)FROM(SELECT 'LINESTRING(0 0,0 2)':geometry as g1,'LINESTRING(0 1,0 3)':geometry as g2)as ...
名称 类型 描述 示例值 object 执行资源配置信息 ECSInstance string ECS 实例 ecs.gn5i-c2g1.large CPU long CPU 核心数范围 4~96 2 GPUNum long GPU 个数 1 Name string 展示文案 ecs.gn5i-c2g1.large-2vCPU-8GB-1*NVIDIA_P4 RAM long ...
use the ST_3DDWithin function.Examples The following example shows the difference between the ST_DWithin function and the ST_DFullyWithin function:SELECT ST_DFullyWithin(g1,g2,2),ST_DWithin(g1,g2,2)from(SELECT 'LINESTRING...
use the ST_3DDWithin function.Examples The following example shows the difference between the ST_DWithin function and the ST_DFullyWithin function:SELECT ST_DFullyWithin(g1,g2,2),ST_DWithin(g1,g2,2)from(SELECT 'LINESTRING...
use the ST_3DDWithin function.Examples The following example shows the difference between the ST_DWithin function and the ST_DFullyWithin function:SELECT ST_DFullyWithin(g1,g2,2),ST_DWithin(g1,g2,2)from(SELECT 'LINESTRING...
3DLongestLine function and the ST_3DShortestLine function.SELECT ST_AsText(ST_3DLongestLine(g1,g2))as lonest,ST_AsText(ST_3DShortestLine(g1,g2))as shortest from(SELECT 'POINT(0 0 0)':geometry as g1,'LINESTRING(0 0 1,1 1 0)...
3DLongestLine function and the ST_3DShortestLine function.SELECT ST_AsText(ST_3DLongestLine(g1,g2))as lonest,ST_AsText(ST_3DShortestLine(g1,g2))as shortest from(SELECT 'POINT(0 0 0)':geometry as g1,'LINESTRING(0 0 1,1 1 0)...
3DLongestLine function and the ST_3DShortestLine function.SELECT ST_AsText(ST_3DLongestLine(g1,g2))as lonest,ST_AsText(ST_3DShortestLine(g1,g2))as shortest from(SELECT 'POINT(0 0 0)':geometry as g1,'LINESTRING(0 0 1,1 1 0)...
vCPU 内存(GB)ecs.c7.large 2 4 ecs.c7.xlarge 4 8 ecs.c7.2xlarge 8 16 ecs.c7...g7.large 2 8 ecs.g7.xlarge 4 16 ecs.g7.2xlarge 8 32 ecs.g7.4xlarge 16 64 ecs.g7.6xlarge 24 96 ecs.g7.8xlarge 32 128 ecs.g7.16xlarge 64 256 ecs.g6....
相关示例如下:示例1:故障转移方式 a1.sinkgroups=g1 a1.sinkgroups.g1.sinks=k1 k2 a1.sinkgroups.g1.processor.type=failover a1.sinkgroups.g1.processor.priority.k1=5 a1.sinkgroups.g1.processor.priority.k2=10 a1.sinkgroups.g1....
示例 对比ST_ContainsProperly和 ST_Contains:SELECT ST_Contains(g1,g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':...
示例 对比ST_ContainsProperly和 ST_Contains:SELECT ST_Contains(g1,g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':...
如果Geometry对象或Geography对象A没有...示例 SELECT ST_Covers(g1,g2),ST_CoveredBy(g2,g1)FROM(SELECT 'POLYGON((0 0,1 1,1 0,0 0))':geometry as g1,'LINESTRING(0 0,1 1)':geometry as g2)as test;st_covers|st_coveredby-+-t|t(1 row)
示例 对比ST_ContainsProperly和 ST_Contains:SELECT ST_Contains(g1,g2),ST_ContainsProperly(g1,g2),ST_ContainsProperly(g1,g3)FROM(SELECT 'POLYGON((0 0,0 3,3 3,3 0,0 0))':geometry as g1,'POLYGON((0 0,0 1,1 1,1 0,0 0))':...
default 189G 17M 189G 1%run/nvidia-topologyd/virtualTopology.xml tmpfs 1.5G 68K 1.5G 1%proc/driver/nvidia/params tmpfs 1.5G 4.0K 1.5G 1%etc/nvidia/nvidia-application-profiles-rc.d devtmpfs 1.5G 0 1.5G 0%dev/nvidia0 可以...
This topic describes ...Parameters Parameter Description g1 Geometry object 2.g2 Geometry object 1.Examples SELECT ST_AsText(ST_ClosestPoint('LINESTRING(0-1,0 1)':geometry,'POINT(1 0)':geometry));st_astext-POINT(0 0)(1 row)
如果Geometry对象或Geography...示例 默认调用:SELECT ST_Covers(g1,g2),ST_CoveredBy(g2,g1)FROM(SELECT 'POLYGON((0 0,1 1,1 0,0 0))':geometry as g1,'LINESTRING(0 0,1 1)':geometry as g2)as test;st_covers|st_coveredby-+-t|t(1 row)
如果Geometry对象或Geography...示例 默认调用:SELECT ST_Covers(g1,g2),ST_CoveredBy(g2,g1)FROM(SELECT 'POLYGON((0 0,1 1,1 0,0 0))':geometry as g1,'LINESTRING(0 0,1 1)':geometry as g2)as test;st_covers|st_coveredby-+-t|t(1 row)
语法 geometry ST_LongestLine(geometry g1,geometry g2);参数 参数名称 描述 g1 第一个Geometry对象。g2 第二个Geometry对象。示例 默认调用:SELECT ST_AsText(ST_LongestLine('POINT(0 0)':geometry,'LINESTRING(0 0,1 1)':geometry));...
语法 geometry ST_LongestLine(geometry g1,geometry g2);参数 参数名称 描述 g1 第一个Geometry对象。g2 第二个Geometry对象。示例 默认调用:SELECT ST_AsText(ST_LongestLine('POINT(0 0)':geometry,'LINESTRING(0 0,1 1)':geometry));...