P盒如何玩-P盒如何玩文档介绍内容-阿里云

示例数据库描述

query(p_deptno IN NUMBER,p_empno IN OUT NUMBER,p_ename IN OUT VARCHAR2,p_job OUT VARCHAR2,p_hiredate OUT DATE,p_sal OUT NUMBER)IS BEGIN SELECT empno,ename,job,hiredate,sal INTO p_empno,p_ename,p_job,p_hiredate,p_sal FROM ...

使用前须知

response_time_avg:host upstream_response_time_p50:host upstream_response_time_p90:host upstream_response_time_p99:host request_time_avg:host request_time_p50:host request_time_p90:host request_time_p99:host host+status 10...

概览

P10 percentile 0.1，大于10%本周期所有采样数据 P20 percentile 0.2，大于20%本周期所有采样数据 P30 percentile 0.3，大于30%本周期所有采样数据 P40 percentile 0.4，大于40%本周期所有采样数据 P50 percentile 0.5，大于50%本周期所有...

实时媒体处理

定价普通转码定价标准转码规格 H.264（元/分钟）H.265（元/分钟）480P（含）及以下 0.017 0.085 480P~720P（含）0.033 0.17 720P~1080P（含）0.065 0.34 1080P~2K（含）0.136 0.68 2K~4K（含）0.272 1.36 转码规格定义：480P：640×480 ...

DROP INDEX

创建列存索引idx3 CREATE INDEX IF NOT EXISTS idx3 USING COLUMNAR ON test(p1,p2,c1,c2,c3)PARTITION BY ENUMERABLE(p1,p2,bucket(128,p1,p2));删除二级索引执行以下语句，禁用二级索引idx1。ALTER INDEX IF EXISTS idx1 ON test ...

按自定义时间列冷热分离

CREATE TABLE dt(p1 integer,p2 bigint,p3 bigint,c1 varchar,constraint pk primary key(p1,p2,p3))WITH(COMPRESSION='ZSTD',CHS='86400',CHS_L2='storagetype=COLD',CHS_COLUMN='COLUMN=p2');参数说明 CHS：冷热分离时间点，单位为秒（s...

RANGE

示例 RANGE类型的使用示例：CREATE TABLE sales_range(dept_no INT,part_no INT,country varchar(20),date DATE,amount INT)PARTITION BY RANGE(amount)(PARTITION p0 VALUES LESS THAN(1000),PARTITION p1 VALUES LESS THAN(2000),...

TPC-H测试集

SQL16 select p_brand,p_type,p_size,count(distinct ps_suppkey)as supplier_cnt from partsupp,part where p_partkey=ps_partkey and p_brand<>'Brand#45' and p_type not like 'SMALL ANODIZED%' and p_size in(47,15,37,30,46,16,18,6)...

新增功能开关

例如以下代码：public class CommonTypeSwitch {@AppSwitch(des="String 类型开关",level=Level.p2)public static String stringSwitch="string;AppSwitch(des="Integer 类型开关",level=Level.p1)public static Integer integerSwitch=2;...

ARRAY_NORMALIZE

返回根据指定p范数（p Norm）对数组元素规范化后的数组。命令格式 array_normalize(array,p)此函数等价于 TRANSFORM(array,v->v/REDUCE(array,0,(a,v)->a+POW(ABS(v),p),a->POW(a,1/p))，但是 REDUCE 部分只执行一次。参数说明 array：输入...

并行查询使用示例

SUBQUERY支持原始SQL语句，如下所示：select s_acctbal,s_name,n_name,p_partkey,p_mfgr,s_address,s_phone,s_comment from part,supplier,partsupp,nation,region where p_partkey=ps_partkey and s_suppkey=ps_suppkey and p_size=35 ...

ROLLBACK

CREATE OR REPLACE PROCEDURE emp_insert(p_empno IN emp.empno%TYPE,p_ename IN emp.ename%TYPE,p_job IN emp.job%TYPE,p_mgr IN emp.mgr%TYPE,p_hiredate IN emp.hiredate%TYPE,p_sal IN emp.sal%TYPE,p_comm IN emp.comm%TYPE,p_deptno ...

图片水印

访问类型@watermark=1&object=<encodedobject>&t=<transparency>&x=<distanceX>&y=<distanceY>&p=…其中 watermark 与 object 两个参数为必填项。文中出现的url_safe_base64_encode指的是URL安全Base64编码，请参见关键词。参数名称描述...

使用说明

50500(PARTITION p20200101000000 VALUES LESS THAN('2020-01-01 00:00:00')ENGINE=InnoDB,PARTITION p20210101000000 VALUES LESS THAN('2021-01-01 00:00:00')ENGINE=InnoDB,PARTITION p20220101000000 VALUES LESS THAN('2022-01-01 00:...

PLDA

STRING 无，即不输出 P(w/z)表 pzwTableName 否 P(z/w)输出表。STRING 无，即不输出 P(z/w)表 pdzTableName 否 P(d/z)输出表。STRING 无，即不输出 P(d/z)表 pzdTableName 否 P(z/d)输出表。STRING 无，即不输出 P(z/d)表 pzTableName 否 P...

查询数据

Q16 select p_brand,p_type,p_size,count(distinct ps_suppkey)as supplier_cnt from partsupp,part where p_partkey=ps_partkey and p_brand<>'Brand#44' and p_type not like 'SMALL BURNISHED%' and p_size in(36,27,34,45,11,6,25,16)...

NULL

最简单的语句是 NULL ...例如：CREATE OR REPLACE PROCEDURE divide_it(p_numerator IN NUMBER,p_denominator IN NUMBER,p_result OUT NUMBER)IS BEGIN IF p_denominator=0 THEN NULL;ELSE p_result:=p_numerator/p_denominator;END IF;END;

修改分区

2022,2024,2026,2028),SUBPARTITION p1sp2 VALUES IN(2021,2023,2025,2027,2029)),PARTITION p2(SUBPARTITION p2sp1 VALUES IN(2020,2022,2024,2026,2028),SUBPARTITION p2sp2 VALUES IN(2021,2023,2025,2027,2029),SUBPARTITION p2sp3 ...

通过外表导入至数仓版

在下方示例中，p1 为第1级分区，p2 为第2级分区，p3 为第3级分区：parquet_partition_classic/├─p1=2020-01-01│├─p2=4│├─p3=SHANGHAI│├─000000_0│└─000000_1│└─p3=SHENZHEN│└─000000_0│└─p2=6│└─p3=SHENZHEN│└...

数据集信息和示例查询

Q16 select p_brand,p_type,p_size,count(distinct ps_suppkey)as supplier_cnt from partsupp,part where p_partkey=ps_partkey and p_brand<>'Brand#44' and p_type not like 'SMALL BURNISHED%' and p_size in(36,27,34,45,11,6,25,16)...

数据类型

枚举名描述 AliRtcVideoQualityDefault 默认，和采集保持一致（例如：采集视频流最高为1080P，默认录制1080P视频流）。AliRtcAudioSampleRate：录制音频采样率。枚举名描述 AliRtcAudioSampleRate_8000 采样率8000。...

LIST DEFAULT HASH

分区键字段类型为 VARCHAR 时，使用LIST COLUMNS示例如下：CREATE TABLE t_goods(country VARCHAR(30),year VARCHAR(60),goods TEXT)PARTITION BY LIST COLUMNS(country)(PARTITION p1 VALUES IN('China'),PARTITION p2 VALUES IN('USA'),...

ALTER TABLE…SPLIT SUBPARTITION

p2_americas|40|4788b|US|09-OCT-12 00:00:00|15000(12 rows)下列命令将子分区p2_americas划分为两个新的子分区，并重新分配了内容：ALTER TABLE sales SPLIT SUBPARTITION p2_americas VALUES('US')INTO(SUBPARTITION p2_us,SUBPARTITION ...

REORGANIZE PARTITION

修改3个分区 p0、p1、p2 为 q1、q2：ALTER TABLE sales_list_hash REORGANIZE PARTITION p0,p1,p2 INTO(PARTITION q1 VALUES in(1,2)(SUBPARTITION s0,SUBPARTITION s1),PARTITION q2 VALUES in(3,4)(SUBPARTITION s3,SUBPARTITION s4));

如何配置通知订阅

选择事件通知订阅：支持选择 P1、P2、P3、P4 优先级，影响程度高、低的选择条件；最多8个条件。选择故障通知订阅：和事件条件一致。通知渠道：通知渠道根据通知对象类型做区分。当通知对象类型为个人时，通知渠道可选范围...

PolarDB for PostgreSQL 11

11/bin/pgbench-M prepared-n-r-P 1-f./ro.sql-c 256-j 128-T 120-D scale=10000-D range=500000000 总数据量10亿，热数据10亿/usr/pgsql-11/bin/pgbench-M prepared-n-r-P 1-f./ro.sql-c 256-j 128-T 120-D scale=10000-D range=...

UPDATE

CREATE OR REPLACE PROCEDURE emp_comp_update(p_empno IN emp.empno%TYPE,p_sal IN emp.sal%TYPE,p_comm IN emp.comm%TYPE)IS BEGIN UPDATE emp SET sal=p_sal,comm=p_comm WHERE empno=p_empno;IF SQL%FOUND THEN DBMS_OUTPUT.PUT_LINE('...

持久内存型性能白皮书

p"redis.host=${server_ip}"-p"redis.port=${port}"-p"redis.password=${password}"-p"recordcount=${recordcount}"-p"operationcount=${operationcount}"-p"redis.timeout=30000"-p"redis.command_group=${command_group}"-p"fieldcount=$...

UPSERT

示例单次写入 UPSERT INTO dt(p1,p2,c1,c2)VALUES(10,20,30,40);UPSERT INTO dt(p1,p2,c2)VALUES(10,20,40);仅写入一行的部分列 UPSERT INTO dt(p1,p2,c1)VALUES(10,20,30);再写入同一行的其他列批量写入 UPSERT INTO dt(p1,p2,c1,c2)...

持久内存型性能白皮书

p"redis.host=${server_ip}"-p"redis.port=${port}"-p"redis.password=${password}"-p"recordcount=${recordcount}"-p"operationcount=${operationcount}"-p"redis.timeout=30000"-p"redis.command_group=${command_group}"-p"fieldcount=$...

LIST-LIST

'ITALY')(SUBPARTITION p0 VALUES in(1,2),SUBPARTITION p1 VALUES in(3,4),SUBPARTITION p2 VALUES in(5,6)),PARTITION asia VALUES in('INDIA','PAKISTAN')(SUBPARTITION p3 VALUES in(1,2),SUBPARTITION p4 VALUES in(3,4),SUBPARTITION...

指标说明

upstream_response_time_p50 请求连接时长的50分位值 upstream_response_time_p90 请求连接时长的90分位值 upstream_response_time_p99 请求连接时长的99分位值 app_lb_id维度 app_lb_id维度指标的标签为 app_lb_id，指标详情如下表所示。...

性能白皮书

11/bin/pgbench-M prepared-n-r-P 1-f./ro.sql-c 256-j 128-T 120-D scale=10000-D range=500000000 总数据量10亿，热数据10亿/usr/pgsql-11/bin/pgbench-M prepared-n-r-P 1-f./ro.sql-c 256-j 128-T 120-D scale=10000-D range=...

SHOW INDEX

创建列存索引idx3 CREATE INDEX IF NOT EXISTS idx3 USING COLUMNAR ON test(p1,p2,c1,c2,c3)PARTITION BY ENUMERABLE(p1,p2,bucket(128,p1,p2));执行以下语句，查看表test中的所有索引。SHOW INDEX FROM test;返回结果如下：+-+-+-+-+-+-+...

PRAGMA EXCEPTION_INIT

CREATE OR REPLACE PACKAGE BODY ar AS PROCEDURE check_balance(p_balance NUMBER,p_amount NUMBER)IS BEGIN IF(p_amount>p_balance)THEN RAISE overdrawn;END IF;END;END;以下存储过程(purchase)调用check_balance存储过程。如果p_amount...

AddRecordTemplate

1080P 720P 360P Audio 1IN 1IN_1080P 1IN_720P 1IN_360P 无 2IN 2IN_1080P 2IN_720P 2IN_360P 无 4IN 4IN_1080P 4IN_720P 4IN_360P 无 9IN 9IN_1080P 9IN_720P 9IN_360P 无 12IN 12IN_1080P 12IN_720P 12IN_360P 无 16IN 16IN_1080P 16IN_...

KEY-LIST

2),SUBPARTITION p1 VALUES in(3,4),SUBPARTITION p2 VALUES in(5,6)),PARTITION dp1(SUBPARTITION p3 VALUES in(1,2),SUBPARTITION p4 VALUES in(3,4),SUBPARTITION p5 VALUES in(5,6)),PARTITION dp2(SUBPARTITION p6 VALUES in(1,2),...

HASH-LIST

SUBPARTITION p1 VALUES in(3,4),SUBPARTITION p2 VALUES in(5,6)),PARTITION dp1(SUBPARTITION p3 VALUES in(1,2),SUBPARTITION p4 VALUES in(3,4),SUBPARTITION p5 VALUES in(5,6)),PARTITION dp2(SUBPARTITION p6 VALUES in(1,2),...

测试方法

bin/ycsb run mongodb-s-p workload=site.ycsb.workloads.CoreWorkload-p recordcount=1000000-p operationcount=5000000-p insertproportion=0-p readproportion=50-p updateproportion=50-p requestdistribution=zipfian-p mongodb.url=...

Star Schema Benchmark

Q2.3 SELECT SUM(lo_revenue),d_year,p_brand FROM lineorder,dates,part,supplier WHERE lo_orderdate=d_datekey AND lo_partkey=p_partkey AND lo_suppkey=s_suppkey AND p_brand='MFGR#2239' AND s_region='EUROPE' GROUP BY d_year,p_...

P盒如何玩

新品推荐