全部产品
阿里云办公

4.1.4 DUMP语法

更新时间:2018-10-09 07:01:47

Dump to ODPS

通过 engine=MPP 的hint和 dump-header 的hint执行MPP Dump to ODPS,示例:

  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 ...

Dump to OSS

通过 engine=MPP 的hint和 dump-header 的hint执行MPP Dump to OSS,示例:

  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 ...
  7. /*+ engine=MPP,
  8. return-dump-record-count=TRUE,
  9. dump-col-del=[,],
  10. dump-row-del=[\n],
  11. dump-oss-accesskey-id=xxxx,
  12. dump-oss-accesskey-secret=xxxx,
  13. dump-header=[DUMP DATA OVERWRITE INTO 'oss://xxx/xxx/xxx']*/ SELECT ...