:CREATE TABLE statement for creating a table in a MaxCompute data source

Table creation statement

In this example, the name of the data table to be created is test_maxcompute_table, and the name of the corresponding done table is test_maxcompute_table_done.

#1. Create a data table.
CREATE TABLE IF NOT EXISTS test_maxcompute_table
(
  pk_id Bigint ,
  cate_id Bigint ,
  vector_array string 
)
PARTITIONED by 
(
  ds STRING
);

#2. Create a partition in the data table.
alter table test_maxcompute_table  add if not exists partition (ds="20230423");

#3. Create a done table.
create table test_maxcompute_table_done (attribute string) partitioned by (ds string);

#4. Create a partition in the done table.
alter table test_maxcompute_table_done  add if not exists partition (ds="20230423");


#5. Insert data into the data table.
insert into test_maxcompute_table partition (ds='20230423') select 1,'12345','xxx,xxx,xxx,xx....';

#6. Insert data into the done table.
insert into table ecom_table_done partition (ds="20230423") select '{"swift_start_timestamp":1682179200}';

Authorization statement

The account that you use to log on to the OpenSearch console must be granted the following permissions on the MaxCompute table that you want to configure: the DESCRIBE, SELECT, and DOWNLOAD permissions on the table and the LABEL permission on the fields of the table.

-- Add an account that is used to manage Havenask instances.
add user ****@aliyun.com;

-- Grant the required permissions to the account.
GRANT describe,select,download ON TABLE table_xxx TO USER ****@aliyun.com
GRANT describe,select,download ON TABLE table_xxx_done TO USER ****@aliyun.com

-- If you enable field permission verification for your MaxCompute table, the system prevents you from accessing highly privileged fields when you pull data, and indexes cannot be created for the table. In this case, you must grant your account the permissions to access fields. 
-- Grant permissions on the entire project.
SET LABEL 3 to USER ****@aliyun.com

-- Grant permissions on a single table.
GRANT LABEL 3 ON TABLE table_xxx(col1, col2) TO ****@aliyun.com

Parameters for adding a MaxCompute data source