:Instructions CREATE TABLE pour les sources de données MaxCompute

#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 test_maxcompute_table_done partition (ds="20230423") select '{"swift_start_timestamp":1682179200}';

-- Add the user account for the engine instance.
add user ****@aliyun.com;
-- Grant the required table 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 field-level permission verification is enabled in MaxCompute, data pull may fail for fields with high-level security labels, which prevents index creation. To resolve this, you must grant the account field-level access permissions.
-- 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