子查询表达式
本节描述本数据库中可用的 SQL 兼容的子查询表达式。所有本节中成文的表达式都返回布尔值（真/假）结果。EXISTS EXISTS(subquery)EXISTS 的参数是一个任意的 SELECT 语句，或者说 子查询。系统对子查询进行运算以判断它是否返回行。如果它...
创建触发器
FOR record_object in(select*from pg_event_trigger_dropped_objects()WHERE TG_TAG NOT IN('ALTER TABLE','DROP PUBLICATION','ALTER PUBLICATION'))LOOP IF record_object.object_type='type' THEN ELSE INSERT INTO public.oms_dropped...
公共错误码
诊断 404 GeographicRegionForRegion.NotFound The geographic region for region has not found-诊断 404 GeographicSpanForRegion.NotFound The geographic span for region has not found-诊断 500 DB.Error db error 数据库报错 诊断 ...
DeleteFlowTag-删除标签
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidIdentifier.NotFound space id is error or not ...
UpdateFlowTag-更新标签
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidIdentifier.NotFound space id is error or not ...
行和数组比较
NOT IN expression NOT IN(value[,.])右手边是一个圆括弧包围的标量列表。如果左手边表达式的结果不等于所有右手边表达式，结果为“真”。它是下面形式的缩写：expression<>value1 AND expression<>value2 AND.请注意如果左手边表达式得到...
错误代码
shutdown 57P02 crash_shutdown 57P03 cannot_connect_now 57P04 database_dropped 57P05 idle_session_timeout Class 58—System Error(errors external to 本数据库 itself)58000 system_error 58030 io_error 58P01 undefined_file 58P...
CreateFlowTag-创建标签
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidIdentifier.NotFound space id is error or not ...
DeleteFlowTagGroup-删除标签分类
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidOrganization.NotFound The organization is not ...
查找最耗费资源的 SQL（Top SQL）
数据库是较大型的应用，对于繁忙的数据库，需要消耗大量的内存、CPU、IO、网络资源。SQL 优化是数据库优化的手段之一，而为了达到 SQL 优化的最佳效果，您首先需要了解最消耗资源的 SQL（Top SQL），例如 IO 消耗最高的 SQL。数据库资源...
UpdateFlowTagGroup-更新标签分类
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidOrganization.NotFound The organization is not ...
CreateFlowTagGroup-创建标签分类
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidOrganization.NotFound The organization is not ...
UpdatePipelineBaseInfo-更新流水线基本信息
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidIdentifier.NotFound space id is error or not ...
StopVMDeployOrder-终止机器部署
403 Forbidden.UserNotInCurrentOrganization The user is not in the organization and is not authorized to perform the operation.当前用户不在该企业中，无权进行操作。404 InvalidOrganization.NotFound The organization is not ...
MySQL提示：1055(42000):SELECT list is not in GROUP...
问题现象 在执行MySQL命令进行查询时，提示如下错误：1055(42000):SELECT list is not in GROUP BY clause and contains nonaggregated column 可能原因 该报错可能由以下两种原因引入：原因一：用户修改了sql_mode参数，加上了ONLY_FULL_...
MySQL提示“1846(0A000):ALGORITHM=INPLACE is not ...
问题现象 在RDS MySQL实例中，使用INPLACE方式扩展VARCHAR字段长度时，提示如下错误：ERROR 1846(0A000):ALGORITHM=INPLACE is not supported.Reason:Cannot change column type INPLACE.Try ALGORITHM=COPY.可能原因 使用INPLACE方式扩展...
出错提示“Newest installed kernel not in use”
问题描述 在操作系统迁移时，出错提示“Newest installed kernel not in use”。问题原因 待迁移的操作系统中未将最新安装的内核设置为启动内核，可能导致操作系统迁移失败。解决方案 更换内核启动顺序，将最新版本的内核设置为默认启动...
DeleteADSetting-删除RDS SQL Server的AD域关联
403 InvalidOperation.Invalid Current instance is not in Domain,remove operation is only valid when current instance is in domain.当前实例不在域中，删除操作仅在当前实例在域中时有效。403 IncorrectDBInstanceState Current DB ...
DeleteADSetting-删除RDS SQL Server的AD域关联
403 InvalidOperation.Invalid Current instance is not in Domain,remove operation is only valid when current instance is in domain.当前实例不在域中，删除操作仅在当前实例在域中时有效。403 IncorrectDBInstanceState Current DB ...
错误码
保存点异常 3B000 保存点异常（SAVEPOINT EXCEPTION）3B001 无效的保存点声明（INVALID SAVEPOINT SPECIFICATION）3D 类：非法数据库名 3D000 非法数据库名（INVALID CATALOG NAME）3F 类：非法模式名 3F000 非法模式名（INVALID SCHEMA ...
6.0版TPC-H性能测试
bin/bash total_cost=0 for i in {1.22} do echo"begin run Q${i},tpch_query/q$i.sql,`date`"begin_time=`date+s.%N`./psql${实例连接地址}-p${端口号}-U${数据库用户}-f~/tpch_query/q${i}.sql>~/log/log_q${i}.out rc=$?end_time=`date+...
RDS SQL Server实例间复制数据库
备份集中没有指定的数据库 400 InvalidRestoreTimeSpecified Unable to restore to the specified time,because the database is in cold storage at this time.Please choose a valid restore point.不能恢复到指定的时间点，因为数据库在...
RDS SQL Server实例间复制数据库
备份集中没有指定的数据库 400 InvalidRestoreTimeSpecified Unable to restore to the specified time,because the database is in cold storage at this time.Please choose a valid restore point.不能恢复到指定的时间点，因为数据库在...
DeleteVirtualNode-删除一个虚拟节点
400 VirtualNode.DELETE.FAILED The vnode has eci on it,please delete eci first.-403 OperationDenied.VswZoneMisMatch The specified VSwitchId is not in the specified Zone.-403 QuotaExceeded%s quota exceeded.用户允许创建的实例...
Spark常见报错
ENI_NOT_VALID The VPC of the specified ENI and security group are not in the same VPC DRIVER_FILE_NOTFOUND java.lang.ClassNotFoundException Spark执行时偶发失败。BROADCAST_TOO_LARGE Cannot broadcast the table that is larger...
CreateReadOnlyDBInstance-创建只读实例
400 InvalidSecurityIPList.Malformed The specified parameter SecurityIPList is not valid.-400 InvalidSecurityIPList.Duplicate The Security IP address is not in the available range or occupied.当前的安全IP地址已被占用或不在...
CreateReadOnlyDBInstance-创建只读实例
400 InvalidSecurityIPList.Malformed The specified parameter SecurityIPList is not valid.-400 InvalidSecurityIPList.Duplicate The Security IP address is not in the available range or occupied.当前的安全IP地址已被占用或不在...
CreateReadOnlyDBInstance-创建只读实例
400 InvalidSecurityIPList.Malformed The specified parameter SecurityIPList is not valid.-400 InvalidSecurityIPList.Duplicate The Security IP address is not in the available range or occupied.当前的安全IP地址已被占用或不在...
CreateReadOnlyDBInstance-创建只读实例
400 InvalidSecurityIPList.Malformed The specified parameter SecurityIPList is not valid.-400 InvalidSecurityIPList.Duplicate The Security IP address is not in the available range or occupied.当前的安全IP地址已被占用或不在...
SQL诊断
Hologres提供慢Query日志，默认采集大于100ms的DML和...ERRCODE_INVALID_CATALOG_NAME ERRCODE_UNDEFINED_DATABASE 指定的数据库不存在。暂无 检查数据库是否存在。ERRCODE_CANNOT_COERCE 两个类型数据之间无法转化时报错。cannot cast type ...
公共错误码
诊断 400 Client.HanaInvalidParameterRequirePointInTime The database recovery point in time is required.-诊断 400 Client.HanaInvalidParameterRequireLogPosition The database log recovery position is required.-诊断 400 Client...
Serverless模式数据共享性能测试
创建一个名为db01的数据库，并切换到db01数据库，语句如下：CREATE DATABASE db01;\c db01 查询db01的UUID，语句如下：SELECT current_database_uuid();创建一个名为tpch的Schema，并将其设置为默认Schema，语句如下：CREATE SCHEMA IF NOT...
UpdateDataSource
400 Invalid.Tenant.UserNotInProject The user is not in the project.用户不在项目中。400 MissingParam.ConnectionStr.Property You must specify property%s required by the data source connection string.数据源连接串信息必填属性...
MySQL提示“1846(0A000):ALGORITHM=INPLACE is not ...
问题现象 在RDS MySQL实例中，使用INPLACE方式扩展VARCHAR字段长度时，提示如下错误：ERROR 1846(0A000):ALGORITHM=INPLACE is not supported.Reason:Cannot change column type INPLACE.Try ALGORITHM=COPY.可能原因 使用INPLACE方式扩展...
faascmd常见问题
404 Image not in success state The fpga image you specify is not in success state.指定的镜像不是success状态。您只能下载success状态的镜像。404 FPGA IMAGE STATE ERROR The specify fpga image is not in success state.指定的镜像...
ExecuteScalingRule
400 InvalidLoadBalancerId.VPCMismatch The specified virtual switch and the instance in specified load balancer are not in the same VPC.指定的伸缩组的负载均衡实例含有的ECS实例与VSwitchId不在同一个VPC当中。400 ...
7.0版TPC-H性能测试
ALTER DATABASE<数据库名称>SET adbpg_enable_dynamic_join_filter=on;调整查询可用内存。ALTER DATABASE<数据库名称>SET statement_mem='16GB';创建TPC-H测试表。DROP TABLE IF EXISTS NATION;CREATE TABLE NATION(N_NATIONKEY INTEGER ...
CreateDataSource
400 Invalid.Tenant.UserNotInProject The user is not in the project.用户不在项目中。400 ConnectionAlreadyExist The connection with envType%s and name%s already exists.连接串名称重复 400 DataSource.CheckRamRoleFailure Failed...
错误码表（2.0版）
18001 Not support CREATE DATABASE in db:schema 无法在该数据连接上进行CREATE DATABASE操作，请检查所用数据库连接是否正确。18002 非ADS user导致的失败信息。操作必须由ADS user进行，请确认当前使用的UMM账号是ADS用户账号。18003 NA...
测试方案介绍
PGUSER=<AccessID>PGPASSWORD=<AccessKey>psql-p<Port>-h<Endpoint>-d<Database>使用psql连接Hologres后，您可以使用如下建表语句创建数据库表。DROP TABLE IF EXISTS LINEITEM;BEGIN;CREATE TABLE LINEITEM(L_ORDERKEY bigint NOT NULL,L_...
- 产品推荐
- 这些文档可能帮助您