集成SDK

环境要求 Python版本>=3.0。第一步：设置访问凭据 调用阿里云OpenAPI通常需要设置访问密钥（AccessKey），详情参见 凭据。为了避免凭据泄露，常见的方案是将其写入到环境变量中，更多安全方案请参见 凭据的安全使用方案。以设置环境变量 ...

快速体验

SELECT CASE WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=0 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)<=3 THEN '0点-3点' WHEN CAST(SUBSTR(behavior_time,12)AS BIGINT)>=4 AND CAST(SUBSTR(behavior_time,12)AS BIGINT)点-7点' ...

ALIYUN:WAF3:Instance

\ \ select Outside Chinese mainland.Intelligent region selection is supported."Required:true Type:String TrafficBillingProtectionThreshold:Description:en:In pay-as-you-go WAF 3.0,the traffic billing protection feature is ...

数据倾斜调优

方法1：select/*+skewjoin(a)*/*from T0 a join T1 b on cast(a.c0 as string)=cast(b.c0 as string)and a.c1=b.c1;方法2：select/*+skewjoin(b)*/*from(select cast(a.c0 as string)as c00 from T0 a)b join T1 c on b.c00=c.c0;加...

实时精准营销（人群圈选）

方案对比 对比项 方案一（MySQL/PostgreSQL）方案二（PostgreSQL）方案三（PostgreSQL）方案三相比方案一的提升 与查询圈选用户速度 1.5秒 0.042秒 0.0015秒 99900%或查询圈选用户速度 3.6秒 3秒 0.0017秒 211665%空间占用（表）63,488 MB ...

集成SDK

setx ALIBABA_CLOUD_ACCESS_KEY_ID3 LTAI4GDty8ab9W4Y1D*/M setx ALIBABA_CLOUD_ACCESS_KEY_SECRET IrVTNZNy5yQelTETg0cZML3TQn*/M 其中/M 表示系统级环境变量，设置用户级环境变量时可以不携带该参数。测试设置是否成功 单击 开始（或快捷...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT a/>/b AS OpZ,a#>#b AS OpT,a@>b AS Op2D,a@>b ...

查询和分析网站日志

本文以查询和分析网站日志为例，帮助您快速上手查询和分析操作。...Linux i686)AppleWebKit/534.33(KHTML,like Gecko)Ubuntu/9.10 Chromium/13.0.752.0 Chrome/13.0.752.0 Safari/534.33 vip_addr:192.0.2.2 vpc_id:3db327b1*82df19818a72

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ a...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ a...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ a...

被包含算子

示例 WITH box AS(SELECT ST_MakeBox3dt(0,0,0,'2010-01-01 00:00:00',10,10,10,'2012-01-01 00:00:00')a,ST_MakeBox3dt(6,6,3,'2010-01-01 00:00:00',8,8,5,'2013-01-01 00:00:00')b)SELECT b/<@/ aAS OpZ,b#<@# aAS OpT,b<@ aAS Op2D,b</@ a...

分析IIS日志

username c-ip cs(User-Agent)sc-status sc-substatus sc-win32-status sc-bytes cs-bytes time-taken 2009-11-26 06:14:21 W3SVC692644773 125.67.67.*GET/index.html - 80 - 10.10.10.10 Baiduspider+(+http://www.example.com)200 0 64 ...

mysqlclient 连接 OceanBase 数据库

PS D:\download>pip install mysqlclient-2.2.0-cp311-cp311-win_amd64.whl Processing d:\download\mysqlclient-2.2.0-cp311-cp311-win_amd64.whl Installing collected packages:mysqlclient Successfully installed mysqlclient-2.2.0 ...

ST_Zmflag

示例 不同类型的返回值：SELECT ST_Zmflag('POINT(0 1)':geometry)as_2D,ST_Zmflag('POINTM(0 1 2)':geometry)as_3DM,ST_Zmflag('POINT(0 1 2)':geometry)as_3DZ,ST_Zmflag('POINT(0 1 2 3)':geometry)as_4D;2d|_3dm|_3dz|_4d-+-+-+-0|1|2|...

ST_Zmflag

示例 不同类型的返回值：SELECT ST_Zmflag('POINT(0 1)':geometry)as_2D,ST_Zmflag('POINTM(0 1 2)':geometry)as_3DM,ST_Zmflag('POINT(0 1 2)':geometry)as_3DZ,ST_Zmflag('POINT(0 1 2 3)':geometry)as_4D;2d|_3dm|_3dz|_4d-+-+-+-0|1|2|...

ST_Zmflag

示例 不同类型的返回值：SELECT ST_Zmflag('POINT(0 1)':geometry)as_2D,ST_Zmflag('POINTM(0 1 2)':geometry)as_3DM,ST_Zmflag('POINT(0 1 2)':geometry)as_3DZ,ST_Zmflag('POINT(0 1 2 3)':geometry)as_4D;2d|_3dm|_3dz|_4d-+-+-+-0|1|2|...

ST_OrderingEquals

示例 对比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_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_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_Dump

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_Dump('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1}|LINESTRING(0 0,0 2){2}|LINESTRING(0 1,0 3)(2 rows)

ST_Dump

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_Dump('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1}|LINESTRING(0 0,0 2){2}|LINESTRING(0 1,0 3)(2 rows)

ST_Dump

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_Dump('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1}|LINESTRING(0 0,0 2){2}|LINESTRING(0 1,0 3)(2 rows)

ST_DumpPoints

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_DumpPoints('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1,1}|POINT(0 0){1,2}|POINT(0 2){2,1}|POINT(0 1){2,2}|POINT...

ST_DumpPoints

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_DumpPoints('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1,1}|POINT(0 0){1,2}|POINT(0 2){2,1}|POINT(0 1){2,2}|POINT...

ST_DumpPoints

示例 默认调用：SELECT(t.dump).path,ST_AsText((t.dump).geom)from(select ST_DumpPoints('MULTILINESTRING((0 0,0 2),(0 1,0 3))':geometry)as dump)as t;path|st_astext-+-{1,1}|POINT(0 0){1,2}|POINT(0 2){2,1}|POINT(0 1){2,2}|POINT...

ST_ContainsProperly

示例 对比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_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_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))':...

通过DataWorks使用PyODPS

Python 3节点版本 requests 2.11.1 2.26.0 numpy 1.16.6 1.18.1 pandas 0.24.2 1.0.5 scipy 0.19.0 1.3.0 scikit_learn 0.18.1 0.22.1 pyarrow 0.16.0 2.0.0 lz4 2.1.4 3.1.10 zstandard 0.14.1 0.17.0 如果您需要使用上面列表中不存在的包...

ST_NDims

st_ndims-2(1 row)3维对象（3DM和3DZ）：SELECT ST_NDims('POINT(0 1 2)':geometry)as_3DZ,ST_NDims('POINTM(0 1 2)':geometry)as_3DM;3dz|_3dm-+-3|3(1 row)4维对象：SELECT ST_NDims('POINT(0 1 2 3)':geometry);st_ndims-4(1 row)

ST_NDims

st_ndims-2(1 row)3维对象（3DM和3DZ）：SELECT ST_NDims('POINT(0 1 2)':geometry)as_3DZ,ST_NDims('POINTM(0 1 2)':geometry)as_3DM;3dz|_3dm-+-3|3(1 row)4维对象：SELECT ST_NDims('POINT(0 1 2 3)':geometry);st_ndims-4(1 row)

ST_NDims

st_ndims-2(1 row)3维对象（3DM和3DZ）：SELECT ST_NDims('POINT(0 1 2)':geometry)as_3DZ,ST_NDims('POINTM(0 1 2)':geometry)as_3DM;3dz|_3dm-+-3|3(1 row)4维对象：SELECT ST_NDims('POINT(0 1 2 3)':geometry);st_ndims-4(1 row)

数学函数

col0|+-+|3.0|LOG10 log10(double)命令说明：求以10位底的对数 返回值类型：DOUBLE 示例：select log10(100);col0|+-+|2.0|LOG log(x,b)命令说明：返回x以b为底的对数 返回值类型：DOUBLE 示例：select log(10,100);col0|+-+|2.0|MOD 命令...

Pig作业配置

Use the FOREACH-GENERATE command to assign names to the fields.uniq_frequency3=FOREACH uniq_frequency2 GENERATE$1 as hour,$0 as ngram,$2 as score,$3 as count,$4 as mean;Use the FILTER command to move all records with a ...

Pig开发手册

Use the FOREACH-GENERATE command to assign names to the fields.uniq_frequency3=FOREACH uniq_frequency2 GENERATE$1 as hour,$0 as ngram,$2 as score,$3 as count,$4 as mean;Use the FILTER command to move all records with a ...

AsymmetricVerify

Value String 是 M2CceNZH00ZgL9ED/ZHFp21YRAvYeZHknJUc207OCZ0N9wNn9As4z2bON3FF3je+1Nu+2+8Zj50HpMTpzYpMp2R93cYmACCmhaYoKydxylbyGzJR8y9likZRCrkD38lRoS40aBBvv/6iRKzQuo9EGYVcel36cMNg00VmYNBy3pa1rwg3gA4l3cy6kjayZja1...
共有200条 < 1 2 3 4 ... 200 >
跳转至： GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
文件存储NAS 数据传输服务 区块链服务 智能语音交互 弹性公网IP 短信服务

新品推荐

新人特惠 爆款特惠 最新活动 免费试用
新人特惠 爆款特惠 最新活动 免费试用