Replicate an Existing Backup 569 Backup/Restore Storage Plugin API 569 Backup/Restore Storage Plugin API 0 Plugin Configuration File 569 Plugin API 570 Plugin Commands 571 Implementing a Backup/Restore Storage delete_backup 0 Synopsis 578 Description 578 Arguments 578 Exit Code 578 Example 578 plugin_api_version 579 plugin_api_version 0 Synopsis 579 Description 579 Return Value 579 restore_data 579 restore_data the External Table Protocol 845 Installing the External Table Protocol 0 gpextprotocal.c 846 gpextprotocal.c 0 Querying Data 852 Querying Data 0 About Greenplum Query Processing 853 About Greenplum

Replicate an Existing Backup 578 Backup/Restore Storage Plugin API 578 Backup/Restore Storage Plugin API 0 Plugin Configuration File 578 Plugin API 579 Plugin Commands 580 Implementing a Backup/Restore Storage delete_backup 0 Synopsis 587 Description 587 Arguments 587 Exit Code 587 Example 587 plugin_api_version 588 plugin_api_version 0 Synopsis 588 Description 588 Return Value 588 restore_data 588 restore_data the External Table Protocol 854 Installing the External Table Protocol 0 gpextprotocal.c 855 gpextprotocal.c 0 Querying Data 861 Querying Data 0 About Greenplum Query Processing 862 About Greenplum

Replicate an Existing Backup 501 Backup/Restore Storage Plugin API 501 Backup/Restore Storage Plugin API 0 Plugin Configuration File 501 Plugin API 502 Plugin Commands 503 Implementing a Backup/Restore Storage delete_backup 0 Synopsis 510 Description 510 Arguments 510 Exit Code 510 Example 510 plugin_api_version 511 plugin_api_version 0 Synopsis 511 Description 511 Return Value 511 restore_data 511 restore_data the External Table Protocol 777 Installing the External Table Protocol 0 gpextprotocal.c 778 gpextprotocal.c 0 Querying Data 784 Querying Data 0 About Greenplum Query Processing 785 About Greenplum

Process 569 Replicate an Existing Backup 569 Backup/Restore Storage Plugin API 570 Plugin Configuration File 570 Plugin API 571 Plugin Commands 572 Implementing a Backup/Restore Storage Plugin 572 delete\_backup 578 Synopsis 578 Description 579 Arguments 579 Exit Code 579 Example 579 plugin\_api\_version 579 Synopsis 579 Description 579 Return Value 579 restore\_data 579 Synopsis 579 Description Custom Data Access Protocol 844 Notes 845 Installing the External Table Protocol 845 gpextprotocal.c 846 Querying Data 852 About Greenplum Query Processing 853 Understanding Query Planning and Dispatch

XML Teradata SQL Other DB SQL Apache MADlib ML/Statistics/Graph Python. R, Java, Perl, C Programmatic Apache SOLR Text PostGIS GeoSpatial Custom Apps BI / Reporting Machine Learning ⼯工作原理理 2017.thegiac.com C API (Greenplum, PostgreSQL, HAWQ) 底层抽象层 (数组操作、类型转换、数值计算库等) 数据库内建函 数 ⽤用户接⼝口 ⾼高层抽象层 (迭代控制器器) 内循环函数 (实现机器器学习逻辑) Python SQL C++ MADlib 架构 2017.thegiac 用户案例例2 基于API日志的⾦金金融产品⽤用户分析 2017.thegiac.com 问题 ● 更更好地理理解不不同种 类的⽤用户 ● 更更好地了了解⽤用户与 APP的交互 ● 对实时API请求进 ⾏行行分类和安全检测 ● 数据量量⼤大，现有数 据分析团队缺乏技 能 客户 数据科学解决⽅方案 ● 某⼤大型跨国⾦金金 融服务公司 ● 移动应⽤用 API 分析

Custom Data Access Protocol 728 Notes 729 Installing the External Table Protocol 729 gpextprotocal.c 730 Querying Data 735 About Greenplum Query Processing 736 Understanding Query Planning and Dispatch define the structure of the record with an AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+———+— 1 | [1,2,3] | json_to_recordset(json) jsonb structure of the record with an AS clause. select * from json_to_recordset(‘[{“a”:1,“b”:“foo”},{“a”:“2”,“c”:“bar”}]’) as x(a int, b text); a | b —+—– 1 | foo 2 | Note: The examples for the functions json_populate_record()

Custom Data Access Protocol 755 Notes 756 Installing the External Table Protocol 756 gpextprotocal.c 757 Querying Data 762 About Greenplum Query Processing 763 Understanding Query Planning and Dispatch 2 Functions in PL/Container 948 About PL/Python 3 Functions in PL/Container 949 Developing CUDA API Functions with PL/Container 949 Prerequisites 950 Install and Customize the PL/Container Image 950 2348 Limitation 2348 DataDirect Driver Documentation 2349 Greenplum Partner Connector API 2349 Using the GPPC API 2350 Requirements 2351 Header and Library Files 2351 Data Types 2351 Composite Types

Custom Data Access Protocol 764 Notes 764 Installing the External Table Protocol 765 gpextprotocal.c 765 Querying Data 770 About Greenplum Query Processing 771 Understanding Query Planning and Dispatch 2 Functions in PL/Container 959 About PL/Python 3 Functions in PL/Container 960 Developing CUDA API Functions with PL/Container 960 Prerequisites 960 Install and Customize the PL/Container Image 961 2419 Limitation 2420 DataDirect Driver Documentation 2420 Greenplum Partner Connector API 2421 Using the GPPC API 2422 Requirements 2422 Header and Library Files 2422 Data Types 2423 Composite Types

Greenplum 6 Documentation VMware, Inc. 34 Installing the External Table Protocol 735 gpextprotocal.c 736 Querying Data 741 About Greenplum Query Processing 742 Understanding Query Planning and Dispatch 2 Functions in PL/Container 929 About PL/Python 3 Functions in PL/Container 931 Developing CUDA API Functions with PL/Container 931 Prerequisites 931 Install and Customize the PL/Container Image 932 2374 Limitation 2375 DataDirect Driver Documentation 2375 Greenplum Partner Connector API 2376 Using the GPPC API 2377 Requirements 2377 Header and Library Files 2377 Data Types 2378 Composite Types

Custom Data Access Protocol 558 Notes 559 Installing the External Table Protocol 559 gpextprotocal.c 560 Querying Data 565 About Greenplum Query Processing 566 Understanding Query Planning and Dispatch 2 Functions in PL/Container 750 About PL/Python 3 Functions in PL/Container 752 Developing CUDA API Functions with PL/Container 752 Prerequisites 752 Install and Customize the PL/Container Image 753 json_populate_record(null::myrowtype, ‘{“a”: 1, “b”: [“2”, “a b”], “c”: {“d”: 4, “e”: “a b c”}}’) a | b | c —+———–+————- 1 | {2,“a b”} | (4,“a b c”) json_populate_recordset(base anyelement, from_json json)