检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
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.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ALL,on(),off(DFS,GUC,HDFS,ORC,SLRU,MEM_CTL,AUTOVAC,ANALYZE,CACHE,ADIO,SSL,GDS,TBLSPC,WLM,SPACE,OBS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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.
based on the export mode and data format set in the OBS foreign table.
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.
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.
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.
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.
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.
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.
You can use COPY TO to export data in TEXT or CSV format to OBS, but cannot use COPY FROM to import data from OBS. For CSV files that are exported to OBS and contain utf8 BOM, you are advised to use OBS to import them. Otherwise, the BOM field may fail to be identified.
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.
By default, the OBS path of a storage-compute decoupled table is displayed as a relative path. To use the disk cache, enable the asynchronous I/O parameter.
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.
