MPP计算引擎 DUMP语法是什么?

Full MPP Mode下使用Dump to ODPS


通过 engine=MPP 的hint和 dump-header 的hint执行MPP Dump to ODPS，示例:<PRE prettyprinted? linenums>

1. /*+ engine=MPP, dump-header=[DUMP DATA [OVERWRITE] INTO 'odps://project_name/table_name']*/ SELECT ...
2. /*+ engine=MPP, return-dump-record-count=TRUE, dump-header=[DUMP DATA [OVERWRITE] INTO 'odps://project_name/table_name']*/ SELECT ...

1. /*+ engine=MPP,
2.     dump-col-del=[,],
3.     dump-row-del=[\n],
4.     dump-oss-accesskey-id=xxxx,
5.     dump-oss-accesskey-secret=xxxx,
6.     dump-header=[DUMP DATA OVERWRITE INTO 'oss://xxx/xxx/xxx']*/ SELECT ...
8. /*+ engine=MPP,
9.     return-dump-record-count=TRUE,
10.     dump-col-del=[,],
11.     dump-row-del=[\n],
12.     dump-oss-accesskey-id=xxxx,
13.     dump-oss-accesskey-secret=xxxx,
14.     dump-header=[DUMP DATA OVERWRITE INTO 'oss://xxx/xxx/xxx']*/ SELECT ...