检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Exporting CSV/TXT Data to OBS Planning Data Export Creating an OBS Foreign Table Exporting Data Examples Parent topic: Exporting Data to OBS
Importing ORC or CarbonData Data from OBS Preparing Data on OBS Creating a Foreign Server Creating a Foreign Table Querying Data on OBS Through Foreign Tables Deleting Resources Supported Data Types Parent topic: Importing Data from OBS in Parallel
ALTER FOREIGN TABLE (for HDFS or OBS) Function Modifies an HDFS or OBS foreign table.
"Access Denied" Is Displayed When the SQL Statement for Creating an OBS Foreign Table Is Executed Symptom When a user executes the SQL statement for creating an OBS foreign table, an OBS error Access Denied is reported.
Importing CSV/TXT Data from OBS Creating Access Keys (AK and SK) Uploading Data to OBS Creating an OBS Foreign Table Importing Data Handling Import Errors Parent topic: Importing Data from OBS in Parallel
Parameter LOCATION supports prefixes gsobs and obs, which are identified as OBS information. LOCATION should be followed by gsobs, OBS URL, and Bucket, or by obs and Bucket.
OPTIONS parameters address Specifies the endpoint of the OBS service. Obtain the address as follows: Obtain the OBS path by performing 2 in Preparing Data on OBS. The OBS path displayed on OBS is the endpoint of the OBS service, that is, obs.example.com.
OBS: specifies the OBS path of the data source file. You only need to enter /Bucket name/Folder directory level/. HDFS: specifies the path in the HDFS file system.
WRITE ONLY creates a write-only HDFS/OBS foreign table. READ ONLY creates a read-only HDFS/OBS foreign table. READ WRITE creates a read/write HDFS/OBS foreign table. If the foreign table type is not specified, a read-only foreign table is created by default.
Parent topic: Exporting ORC Data to OBS
What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables in GaussDB(DWS)?
What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables in GaussDB(DWS)?
Granting Write Permission to OBS Storage Location and OBS Bucket as Planned Create an OBS bucket and a folder in the OBS bucket as the directory for storing exported data. Log in to the OBS management console.
Parent topic: Exporting ORC Data to OBS
On the GaussDB(DWS) database, create the foreign tables tpcds.customer_address_ext1 and tpcds.customer_address_ext2 for the OBS data server to receive data exported from the database. OBS and the database are in the same region.
Parent topic: Exporting CSV/TXT Data to OBS
What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables in GaussDB(DWS)?
Preparations Before Using Hudi Prerequisites You have created an OBS agency and OBS data source. For details, see Managing OBS Data Sources.
An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS Foreign Table, Indicating that the User Does Not Have the Permission or the Permission Is Insufficient Symptom An administrator can execute the statement for creating a GDS
GS_OBS_LATENCY GS_OBS_LATENCY records the average latency of OBS during the 10 minutes before logtime. The latency is estimated based on OBS operations. This view is supported only by clusters of version 8.2.0 or later.
