检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
the following command to query the maximum timeline of the hudi data on OBS, that is, the latest submitted data: 1 SELECT * FROM hudi_get_max_commit('SCHEMA.FOREIGN_TABLE'); Example: Query the maximum timeline of the OBS foreign table rtd_mfdt_int_unit_ft in the current schema.
LOCATION specifies the OBS directory where the data file is stored, formatted as obs://OBS bucket name/folder name. In this example, the directory is obs://dli-obs01/dli_order.
OBS_VFILE_TYPE: Virtual file in OBS, OBS read/write handle. READ_SEGMENT_TYPE: Entity that merges multiple OBS read requests. SHARED_OBS_HANDLE_TYPE: OBS Handler resource used to connect to the OBS service.
Data imported from OBS is encrypted. Parent topic: Product Consulting
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Step 2: Uploading Data to OBS Create an OBS bucket and upload the local CSV data to the bucket.
Data imported from OBS is encrypted. Parent topic: Product Consulting
However, if you use more space than the free-of-charge storage space, the exceeded part is charged as per OBS billing rules. For details, see the OBS pricing details. The dependency of the snapshot service is as follows: The snapshot management function depends on OBS or NFS.
This parameter is available only when type is OBS. secret_access_key Indicates the secret access key (SK) (obtained by users from the OBS page) used for the OBS access protocol.
Table 1 Best practices Practice Description Data Import and Export Importing Data from OBS to a Cluster This practice demonstrates how to upload sample data to OBS and import OBS data to the target table on GaussDB(DWS), helping you quickly learn how to import data from OBS to a GaussDB
DDL Syntax DDL Syntax Overview ALTER DATABASE ALTER FOREIGN TABLE (GDS Import and Export) ALTER FOREIGN TABLE (for HDFS or OBS) ALTER FUNCTION ALTER GROUP ALTER INDEX ALTER LARGE OBJECT ALTER REDACTION POLICY ALTER RESOURCE POOL ALTER ROLE ALTER ROW LEVEL SECURITY POLICY ALTER SCHEMA
This parameter is available only when type is OBS. - secret_access_key Indicates the secret access key (SK) (obtained by users from the OBS page) used for the OBS access protocol.
Importing data from the OBS Upload data to OBS and then export it to GaussDB(DWS) clusters. Data formats such as CSV and TEXT are supported.
Solution: Check whether the settings of GDS, HDFS foreign tables, Roach, and OBS are correct.
