Segment 1D Segment 2A Segment 2B Segment 2D Segment 3A Segment 3B Segment 2C Segment 3C Segment 3D 分区 SELECT COUNT(*) FROM orders WHERE order_date >= ‘Oct 1 2007’ AND order_date <= ‘Oct 31 2007’ 1C Segment 1D Segment 2A Segment 2B Segment 2C Segment 2D Segment 3A Segment 3B Segment 3C Segment 3D 15 Pivotal Confidential–Internal Use Only 递归查询 表‘SALES’ 表‘SALES’ ■ 层次结构 ■ 树状结构 WITH RECURSIVE Goetz Graefe 优化分布式大数据系统中特别复杂的查询 18 Madlib: 迭代并行模型训练 Master model = init(…) WHILE model not converged model = SELECT model.aggregation(…) FROM data table ENDWHILE 模型存储过程 …

EXISTS. Например, следующий запрос: Общие элементы языка 84 SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker = 'A'); использованием предиката EXISTS: SELECT model, speed, hd FROM PC WHERE EXISTS (SELECT * FROM product WHERE maker = 'A' AND product.model = PC.model); существуют модели, производитель которых начинается на букву «A»: SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker STARTING WITH 'A'); См

3A Segment 3B Segment 3C Segment 3D Segment 1A Segment 1B Segment 1C Segment 1D Segment 2A Segment 2B Segment 2C Segment 2D Segment 3A Segment 3B Segment 3C Segment 3D Segment 1A Segment 1B Segment 1C 1C Segment 1D Segment 2A Segment 2B Segment 2C Segment 2D Segment 3A Segment 3B Segment 3C Segment 3D 分布和分区 SELECT COUNT(*) FROM orders WHERE order_date >= ‘Oct 20 2007’ AND order_date < ‘Oct 27 2007’ 1C Segment 1D Segment 2A Segment 2B Segment 2C Segment 2D Segment 3A Segment 3B Segment 3C Segment 3D 10 Pivotal Confidential–Inter nal Use Only 多级分区存储 • 哈希Distribution：数据均 匀的分布到各个数据节点 • 范围分区： 数据节点内部，

Greenplum Database Best Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339 Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc. 42 Choosing the Table Storage Model 0 Heap Storage 738 Append-Optimized Storage 739

Greenplum Database Best Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330 Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc. 41 Choosing the Table Storage Model 0 Heap Storage 729 Append-Optimized Storage 730

Greenplum Database Best Practices 0 Best Practices Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Space 261 Storage Model 261 Heap Storage or Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263 Hash Operator Class 659 Choosing the Table Storage Model 661 VMware Greenplum v6.17 Documentation VMware, Inc. 37 Choosing the Table Storage Model 0 Heap Storage 661 Append-Optimized Storage 662

Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334 Distribution Key Hash Functions 725 Example Custom Hash Operator Class 725 Choosing the Table Storage Model 727 Heap Storage 727 Append-Optimized Storage 727 To create a heap table 728 Choosing Row or Column-Oriented

Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541 To create a heap table 541 Choosing Row or Column-Oriented Changing the Distribution Policy 550 Redistributing Table Data 551 Altering the Table Storage Model 551 Adding a Compressed Column to Table 551 Inheritance of Compression Settings 552 Dropping a Customer Support 1171 Greenplum Database Best Practices 1172 Best Practices Summary 1173 Data Model 1173 Heap vs. Append-Optimized Storage 1173 Row vs. Column Oriented Storage 1173 Compression 1174

Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458 VMware Tanzu Greenplum 6 Documentation VMware Changing the Distribution Policy 467 Redistributing Table Data 467 Altering the Table Storage Model 468 Adding a Compressed Column to Table 468 Inheritance of Compression Settings 468 Dropping a Customer Support 1023 Greenplum Database Best Practices 1024 Best Practices Summary 1025 Data Model 1025 Heap vs. Append-Optimized Storage 1025 Row vs. Column Oriented Storage 1025 Compression 1025

Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Changing the Distribution Policy 548 Redistributing Table Data 548 Altering the Table Storage Model 548 Adding a Compressed Column to Table 549 Inheritance of Compression Settings 549 Dropping a Customer Support 1166 Greenplum Database Best Practices 1167 Best Practices Summary 1168 Data Model 1168 Heap vs. Append-Optimized Storage 1168 Row vs. Column Oriented Storage 1168 Compression 1169