检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
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.
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.
OBS Path: Find the product_info.txt file in the created OBS bucket and click Yes. HDFS Path: Select /user/hive/warehouse/demo.db/product_info/ and click Yes. Click OK to import the product_info table data. Create an ORC table and import data to the table.
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.
It is ideal when the volume of OBS data storage or data transfer surpasses the purchased package.
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.
table does not support deferrable index. level:ERROR GS_213100048 errmsg:index %s is not valid. errhint: Cannot change table with invalid index. level:ERROR GS_213100054 errmsg:parition not support to specify TABLESPACE. errhint: Cold data partition of multi-temperature table or OBS
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.
Currency Unit Minute (m) Hour (H) Day (d) primary_cluster_id Yes String ID of the primary cluster standby_cluster_id Yes String ID of the standby cluster primary_obs_bucket No String OBS bucket of the primary cluster standby_obs_bucket No String OBS bucket of the standby cluster Response
Because the ANALYZE performance of the OBS foreign table and HDFS foreign table is poor, you are not advised to perform ANALYZE on these tables.
Use cstore_buffers to specify the cache of ORC, Parquet, or CarbonData metadata and data for OBS or HDFS foreign tables. The metadata cache size should be 1/4 of cstore_buffers and not exceed 2 GB.