检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Import and Export Best Practices for Data Import GDS Practice Guide Transferring Data Between OBS Buckets and GaussDB (DWS) Clusters Using GDS to Import Table Data from a Remote Server to a GaussDB(DWS) Cluster Importing Table Data from MRS Hive to a GaussDB(DWS) Cluster Enabling
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.
Data Migration What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables in GaussDB(DWS)? How Is Data Stored in GaussDB(DWS)? How Much Service Data Can Be Stored in GaussDB(DWS)? How Do I Import and Export Data in GaussDB(DWS) Using \copy?
SCHEMA.FOREIGN_TABLE indicates the name and schema of the OBS foreign table. LATEST_COMMIT indicates the end time of the Hudi synchronization. Example: Data has been synchronized to the target table public.in_rel from hudi by 20220913152131.
DWSAccessOBS OBS Administrator Audit log dump: reports audit logs to OBS buckets. DWSAccessKMS KMS Administrator Used to query and rotate keys in a KMS encrypted cluster.
By default, the OBS cold and hot storage is disabled. 29 enable_tsdb_multi_temperature Specifies whether to enable the OBS cold and hot storage for time series tables.
type=OBS Example Response { "data_sources": [ { "id": "8010dbc0-c1d2-48d6-87eb-3229f9195fed", "name": "tes54", "type": "OBS", "connect_info": "gaussdb", "user_name": "DWSAccessOBS", "configure_status
LMT: Switch the hot partition data that is not updated in the last [day] days to the OBS tablespace as cold partition data. [day] is an integer ranging from 0 to 36500, in days.
OBS GaussDB(DWS) uses OBS to convert cluster data and external data, satisfying the requirements for secure, reliable, and cost-effective storage. MRS Data can be migrated from MRS to GaussDB(DWS) clusters for analysis after the data is processed by Hadoop.
The foreign server associated with the table is hdfs_server, the format of the file on HDFS corresponding to the table is ORC, and the data storage path on OBS is /user/hive/warehouse/product_info_orc/.
Servers whose type is lf, dli, obs, or hdfs can be associated. For details, see CREATE SERVER. CATALOG Catalog to be accessed in LakeFormation.
Schema Is Granted to a User, the User Still Cannot Query the Tables How Do I Revoke the Permission of a User If grant select on table t1 to public Has Been Executed on a Table An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS
OBS I/O indicates details about an OBS I/O request. (supported by V3 tables or foreign tables with storage and compute decoupled) count indicates the total number of OBS I/O requests. averageRTT indicates the average round trip time (RTT) of OBS I/O requests.
cluster. errhint: You need to define at least 1 Datanode with CREATE NODE. level:ERROR GS_225120023 errmsg:Statistics in some tables or columns(%s) are not collected. errhint: Do analyze for them in order to generate optimized plan. evel: level GS_225120024 errmsg:Statistics in some obs
GDS Foreign Table and An Error Is Reported Indicating that ROUNDROBIN Is Not Supported When CDM Is Used to Import MySQL Data to GaussDB(DWS), the Column Length Exceeds the Threshold and Data Synchronization Fails "Access Denied" Is Displayed When the SQL Statement for Creating an OBS
Analyzing a Table ANALYZE supports row-store, column-store, HDFS, and OBS tables in ORC or CARBONDATA format. ANALYZE can also collect statistics about specified columns of a local table.
Full export: Export all query SQL results to a specified path in an OBS bucket. By default, the results are exported to a CSV file. For details, see Exporting Data. Using gs_dump and gs_dumpall Alternatively, you can use gs_dump and gs_dumpall to export data.
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.
Currently, you can only use the snapshots stored in OBS to restore data to a new cluster. The resources required for restoring data to a new cluster do not exceed your available resource quota.
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.
