delta) and block size can be specified. Suitable for frequent updates and deletes. Use indexes for drill through queries. TABLE ‘SALES’ Jun Column-oriented HEAP (row-oriented) Oct Year -1 Year -2 External

oriented faster when returning all columns  HEAP for many updates and deletes  Use indexes for drill through queries Columnar storage compresses better Optimized for retrieving a subset of the columns

340 Data Skew 340 Processing Skew 341 Partitioning 341 Number of Partition and Columnar Storage Files 342 Indexes 343 Column Sequence and Byte Alignment 344 Memory and Resource Management with Resource Removing Bloat from System Catalogs 358 Monitoring Greenplum Database Log Files 359 Monitoring Greenplum Database Log Files 0 Loading Data 360 Loading Data 0 INSERT Statement with Column Values 361 Extension 442 Enabling PL/Java and Installing JAR Files 443 Uninstalling PL/Java 444 Remove PL/Java Support for a Database 444 Uninstall the Java JAR files and Software Package 444 Writing PL/Java functions

331 Data Skew 331 Processing Skew 332 Partitioning 332 Number of Partition and Columnar Storage Files 333 Indexes 334 Column Sequence and Byte Alignment 335 Memory and Resource Management with Resource Removing Bloat from System Catalogs 349 Monitoring Greenplum Database Log Files 350 Monitoring Greenplum Database Log Files 0 Loading Data 351 VMware Greenplum v6.18 Documentation VMware, Inc. 16 Extension 432 Enabling PL/Java and Installing JAR Files 433 Uninstalling PL/Java 434 Remove PL/Java Support for a Database 434 Uninstall the Java JAR files and Software Package 435 Writing PL/Java functions

v6.17 Documentation VMware, Inc. 11 Partitioning 267 Number of Partition and Columnar Storage Files 268 Indexes 269 Column Sequence and Byte Alignment 270 Memory and Resource Management with Resource Removing Bloat from System Catalogs 284 Monitoring Greenplum Database Log Files 285 Monitoring Greenplum Database Log Files 0 Loading Data 286 Loading Data 0 INSERT Statement with Column Values 287 and Installing JAR Files 368 VMware Greenplum v6.17 Documentation VMware, Inc. 17 Uninstalling PL/Java 369 Remove PL/Java Support for a Database 369 Uninstall the Java JAR files and Software Package

v6.20 Documentation VMware, Inc. 15 Partitioning 336 Number of Partition and Columnar Storage Files 337 Indexes 338 Column Sequence and Byte Alignment 339 Memory and Resource Management with Resource 352 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 16 Monitoring Greenplum Database Log Files 354 Loading Data 355 INSERT Statement with Column Values 355 COPY Statement 355 External Tables Extension 437 Enabling PL/Java and Installing JAR Files 438 Uninstalling PL/Java 438 Remove PL/Java Support for a Database 439 Uninstall the Java JAR files and Software Package 439 Writing PL/Java functions

SQL-0N-HADOOP 技术大量涌现 出来，几乎成为当前 Hadoop 开发使用的一个技术热点趋势。 这 些 技 术 包 括：Hive、Pivotal HAWQ、SPARK SQL、Impala、 Prest、Drill、Tajo 等等很多，这些技术有些是在 Mapreduce 上做 了优化。例如 Spark 采用内存中的 Mapreduce 技术，号称性能比 基于文件的的 Mapreduce 提高 10 倍；有的则采用

Constraints 531 Dropping a Time-based Restriction 531 Auditing 531 Viewing the Database Server Log Files 532 Encrypting Data and Database Connections 535 Encrypting gpfdist Connections 536 Encrypting Existing Tablespaces 556 Dropping Tablespaces 557 Moving the Location of Temporary or Transaction Files 557 Creating and Managing Schemas 557 The Default "Public" Schema 557 Creating a Schema 558 Schema s3 External Tables 623 About the s3 Protocol LOCATION URL 624 About Reading and Writing S3 Data Files 626 s3 Protocol AWS Server-Side Encryption Support 626 s3 Protocol Proxy Support 627 About Providing

Auditing 502 VMware Greenplum 6 Documentation VMware, Inc. 23 Viewing the Database Server Log Files 503 Encrypting Data and Database Connections 506 Encrypting gpfdist Connections 507 Encrypting Existing Tablespaces 527 Dropping Tablespaces 528 Moving the Location of Temporary or Transaction Files 528 Creating and Managing Schemas 528 The Default "Public" Schema 528 Creating a Schema 529 VMware s3 External Tables 593 About the s3 Protocol LOCATION URL 595 About Reading and Writing S3 Data Files 596 s3 Protocol AWS Server-Side Encryption Support 597 s3 Protocol Proxy Support 598 About Providing

Constraints 526 Dropping a Time-based Restriction 526 Auditing 526 Viewing the Database Server Log Files 527 Encrypting Data and Database Connections 530 Encrypting gpfdist Connections 531 Encrypting Existing Tablespaces 550 Dropping Tablespaces 552 Moving the Location of Temporary or Transaction Files 552 Creating and Managing Schemas 552 The Default “Public” Schema 552 Creating a Schema 552 Schema s3 External Tables 616 About the s3 Protocol LOCATION URL 618 About Reading and Writing S3 Data Files 619 s3 Protocol AWS Server-Side Encryption Support 620 s3 Protocol Proxy Support 621 About Providing