Step By Step
1.进入DataWorks控制台创建工作空间
![Dingtalk_20221124161508.jpg Dingtalk_20221124161508.jpg](https://ucc.alicdn.com/pic/developer-ecology/1d6ac284511340d7b5e1c48e7e79dfb5.jpg?x-oss-process=image/resize,w_1400/format,webp)
2.选择MaxCompute引擎
![Dingtalk_20221124161557.jpg Dingtalk_20221124161557.jpg](https://ucc.alicdn.com/pic/developer-ecology/a7f1cccf21b442a1b418083bce52206b.jpg?x-oss-process=image/resize,w_1400/format,webp)
3.创建完成后进入数据开发
![Dingtalk_20221124161922.jpg Dingtalk_20221124161922.jpg](https://ucc.alicdn.com/pic/developer-ecology/6186981034c24ba791091e648e5ebace.jpg?x-oss-process=image/resize,w_1400/format,webp)
4.新建表填入路径和表名称
![Dingtalk_20221124162009.jpg Dingtalk_20221124162009.jpg](https://ucc.alicdn.com/pic/developer-ecology/6fdd16a9dc8c4efa8477527ac1478c70.jpg?x-oss-process=image/resize,w_1400/format,webp)
![Dingtalk_20221124162518.jpg Dingtalk_20221124162518.jpg](https://ucc.alicdn.com/pic/developer-ecology/87e2ba2a8d3c4446b8befd5d25195245.jpg?x-oss-process=image/resize,w_1400/format,webp)
5.填入数据库定义语言
CREATE TABLE IF NOT EXISTS test_table
(
age BIGINT COMMENT '年龄',
job STRING COMMENT '工作类型',
marital STRING COMMENT '婚否',
education STRING COMMENT '教育程度',
default STRING COMMENT '是否有信用卡',
housing STRING COMMENT '房贷',
loan STRING COMMENT '贷款',
contact STRING COMMENT '联系途径',
month STRING COMMENT '月份',
day_of_week STRING COMMENT '星期几',
duration STRING COMMENT '持续时间',
campaign BIGINT COMMENT '本次活动联系的次数',
pdays DOUBLE COMMENT '与上一次联系的时间间隔',
previous DOUBLE COMMENT '之前与客户联系的次数',
poutcome STRING COMMENT '之前市场活动的结果',
emp_var_rate DOUBLE COMMENT '就业变化速率',
cons_price_idx DOUBLE COMMENT '消费者物价指数',
cons_conf_idx DOUBLE COMMENT '消费者信心指数',
euribor3m DOUBLE COMMENT '欧元存款利率',
nr_employed DOUBLE COMMENT '职工人数',
y BIGINT COMMENT '是否有定期存款'
);
![Dingtalk_20221124162702.jpg Dingtalk_20221124162702.jpg](https://ucc.alicdn.com/pic/developer-ecology/03f06946a2b94c0bbeb87f30da9a07f7.jpg?x-oss-process=image/resize,w_1400/format,webp)
6.提交开发以及生产环境
![Dingtalk_20221124162854.jpg Dingtalk_20221124162854.jpg](https://ucc.alicdn.com/pic/developer-ecology/cf24f92a1ab54894836faa5137a5287f.jpg?x-oss-process=image/resize,w_1400/format,webp)
7.导入本地的数据
![Dingtalk_20221124165506.jpg Dingtalk_20221124165506.jpg](https://ucc.alicdn.com/pic/developer-ecology/72417447cf034b0cbe1b25b836c69e35.jpg?x-oss-process=image/resize,w_1400/format,webp)
8.新建odpssql节点运行查询sql
![Dingtalk_20221124171137.jpg Dingtalk_20221124171137.jpg](https://ucc.alicdn.com/pic/developer-ecology/5ef0f4f22cd64e05aa1749584eb922ee.jpg?x-oss-process=image/resize,w_1400/format,webp)
9.运行结果
![image.png image.png](https://ucc.alicdn.com/pic/developer-ecology/bbd2e9e012d84cdb8d2075197eaf4335.png?x-oss-process=image/resize,w_1400/format,webp)