![]() ![]() For more information about the LOAD command, see LOAD. Run the LOAD command multiple times to load all data from OSS to the MaxCompute tables that you created, and execute the SELECT statement to query and verify the imported data.For more information, see STS authorization. Create a RAM role that has the OSS access permissions and assign the RAM role to the RAM user.If you want to configure the project to use the MaxCompute V2.0 data types and the Decimal 2.0 data type, add the following commands at the beginning of the CREATE TABLE statements: ) In this example, the project uses the MaxCompute V2.0 data types because the TPC-H dataset uses the MaxCompute V2.0 data types and the Decimal 2.0 data type. The following sample commands show how to create tables: Use the ad-hoc query feature to execute SQL statements (optional). Right-click the exported folder and select Get total size to obtain the total size of the folder and the number of files in the folder.įor more information about ad hoc queries, see.On the Amazon Web Services (AWS) platform, create an IAM user who uses the programmatic access method to access Amazon S3.In the Account Management section of the Overview page, click the link under RAM user logon, and use the RAM user to log on to the Alibaba Cloud Management Console. In the left-side navigation pane, click Overview.The AliyunMGWFullAccess policy authorizes the RAM user to perform online migration jobs. We can unload Redshift data to S3 in Parquet format directly. The AliyunOSSFullAccess policy authorizes the RAM user to read data from and write data to OSS buckets. 2 Answers Sorted by: 4 Spark is not needed anymore. On the page that appears, select AliyunOSSFullAccess and AliyunMGWFullAccess, and click OK. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |