检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Check whether OBS is running properly. If it is, contact technical support to check whether the dms-agent process is normal. DWS.13009 The OBS storage space is insufficient. Ensure the OBS storage space is sufficient. DWS.0107 DN REDO is being executed. Try again later.
Transferring Data to OBS Raw data of metrics is kept for two days on Cloud Eye. You can enable OBS and save the raw data to OBS so that it can be saved for a longer time.
CREATE DATABASE OBS foreign tables support XSKY S3. OBS foreign tables are adapted to XSKY and the parameter eol is added. CREATE FOREIGN TABLE (SQL on Hadoop or OBS) SQL supports Roaring Bitmaps.
However, if you use more space than the free-of-charge storage space, the exceeded part is charged according to OBS billing rules. For details, see the OBS pricing details.
This section describes how to import sample data from OBS to a data warehouse cluster and perform querying and analysis operations on the sample data. The sample data is generated based on the standard TPC-DS benchmark test.
Type: USERSET Value range: a string Default value: OBS, HADOOP and REMOTE_DATANODE are enabled. MD is disabled. You can run the SHOW profile_logging_module command to view the value.
Table 1 Regions and OBS bucket names Region OBS Bucket CN North-Beijing1 dws-demo-cn-north-1 CN North-Beijing2 dws-demo-cn-north-2 CN North-Beijing4 dws-demo-cn-north-4 CN North-Ulanqab1 dws-demo-cn-north-9 CN East-Shanghai1 dws-demo-cn-east-3 CN East-Shanghai2 dws-demo-cn-east-2
Scan operation hints can be used for row-store tables, column-store tables, HDFS tables, HDFS foreign tables, OBS tables, and subquery tables. HDFS tables include primary tables and delta tables. The delta tables are invisible to users.
SERVER Specifies the OBS server, which takes effect only when COPY TO is used. filename is a path on OBS, indicating that data is exported to OBS. Name of the created OBS server. BOM Specifies whether to add the UTF-8 BOM field to the exported CSV file.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ALL,on(),off(DFS,GUC,HDFS,ORC,SLRU,MEM_CTL,AUTOVAC,ANALYZE,CACHE,ADIO,SSL,GDS,TBLSPC,WLM,SPACE,OBS
In addition, database audit logs can be dumped to OBS to ensure the log retention period. For details, see Viewing Database Audit Logs. Parent topic: Security
The only difference in usage compared to OBS is when creating data sources. Accessing Multiple MRS Clusters Concurrently Due to JDK restrictions, one JVM can store only one Kerberos configuration file at a time.
It is mandatory. source_filepath: file path on the OBS server. Only .jar files are supported. accesskey: key obtained for accessing the OBS service. It is mandatory. secret_key: secret key obtained for the OBS service.
Notes and Constraints Only snapshots whose backup device is OBS can be used to restore clusters. By default, the new cluster created during restoration using a snapshot has the same specifications and node quantity as the original cluster.
Change the database owner. 1 2 ALTER DATABASE database_name OWNER TO new_owner; Change the default tablespace of the database. 1 2 ALTER DATABASE database_name SET TABLESPACE new_tablespace; The current tablespaces cannot be changed to OBS tablespaces.
An existing foreign server whose type is lf, dli, obs, or hdfs. CATALOG Catalog to be accessed in LakeFormation. - OPTIONS Specifies parameters of foreign table data. This is supported only by 8.3.0 and later versions. dli_project_id: project ID of DLI.
Once established, the KV cache of the consumer VW periodically synchronizes the SST file incrementally from the OBS cudesc snapshot directory of the producer to the local host. This allows tables in the producer VW to be queried across VWs in the consumer VM.
based on the export mode and data format set in the OBS foreign table.
Solution: Check whether the settings of GDS, HDFS foreign tables, Roach, and OBS are correct. GAUSS-01719: "cache lookup failed for partitioned table %u in pg_partition" SQLSTATE: XX000 Description: The corresponding tuple cannot be found in the partition table.
Scan operation hints can be used for row-store tables, column-store tables, HDFS tables, HDFS foreign tables, OBS tables, and subquery tables. HDFS tables include primary tables and delta tables. The delta tables are invisible to users.
