检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 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
What Are the Differences Between Data Formats Supported by OBS and GDS Foreign Tables? The file formats supported by OBS and GDS foreign tables are as follows: OBS file formats: CSV, TEXT, ORC, and CARBONDATA. The default format is TEXT. GDS file formats: CSV and TEXT.
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.
ALTER FOREIGN TABLE (for HDFS or OBS) Function Modifies an HDFS or OBS foreign table.
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.
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.
CREATE FOREIGN TABLE (SQL on OBS or Hadoop) Function CREATE FOREIGN TABLE creates an HDFS or OBS foreign table in the current database to access structured data stored on HDFS or OBS. You can also export data in ORC format to HDFS or OBS.
Parent topic: Exporting ORC Data to OBS
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)?
