检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
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
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.
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.
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
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.
based on the export mode and data format set in the OBS foreign table.
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.
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.
V3 table A V3 table refers to a table whose colversion defined in the CREATE TABLE syntax is 3.0 during table creation, indicating that each column of the column-store table is stored in a file named C1_field.0, and data is stored in the OBS file system.
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. The amount of free space you have is equal to the total storage capacity of your cluster.
Figure 9 Testing GaussDB(DWS) connectivity Step 5: Creating a DLI Flink Job Log in to the OBS console and create an OBS bucket to store Flink jobs. For details, see the OBS User Guide. Set key parameters as follows and retain the default values for other parameters.
If data stored in the OBS is no longer used, you can delete it to avoid further expenditures. Configure the Balance Alert function on the Billing Center > Overview page.
It is used when the amount of OBS data to be stored or the data volume exceeds the package capacity.
Each region has its own shared public services (ECS, EVS, OBS, VPC, EIP, and IMS). Regions are either common or dedicated. A common region provides common cloud services available to all tenants.
Each region has its own shared public services (ECS, EVS, OBS, VPC, EIP, and IMS). Regions are either common or dedicated. A common region provides common cloud services available to all tenants.
