Contents Release Notes
5
Creating and Managing Tablespaces...................................................................................270
Creating and Managing Schemas........................................................................................272
Creating and Managing Tables............................................................................................ 274
Choosing the Table Storage Model..................................................................................... 279
Partitioning Large Tables......................................................................................................290
Creating and Using Sequences........................................................................................... 303
Using Indexes in Greenplum Database............................................................................... 306
Creating and Managing Views............................................................................................. 310
Distribution and Skew..................................................................................................................... 311
Local (Co-located) Joins.......................................................................................................311
Data Skew............................................................................................................................ 311
Processing Skew.................................................................................................................. 312
Inserting, Updating, and Deleting Data...........................................................................................315
About Concurrency Control in Greenplum Database...........................................................315
Inserting Rows...................................................................................................................... 316
Updating Existing Rows........................................................................................................317
Deleting Rows.......................................................................................................................317
Working With Transactions...................................................................................................317
Global Deadlock Detector.....................................................................................................319
Vacuuming the Database..................................................................................................... 321
Running Out of Locks...........................................................................................................321
Querying Data................................................................................................................................. 323
About Greenplum Query Processing....................................................................................323
About GPORCA....................................................................................................................326
Defining Queries................................................................................................................... 339
WITH Queries (Common Table Expressions)......................................................................351
Using Functions and Operators............................................................................................355
Working with JSON Data..................................................................................................... 365
Working with XML Data........................................................................................................378
Using Full Text Search.........................................................................................................390
Using Greenplum MapReduce............................................................................................. 425
Query Performance.............................................................................................................. 433
Managing Spill Files Generated by Queries........................................................................ 433
Query Profiling...................................................................................................................... 433
Working with External Data.............................................................................................................439
Accessing External Data with PXF...................................................................................... 439
Defining External Tables...................................................................................................... 439
Accessing External Data with Foreign Tables..................................................................... 457
Using the Greenplum Parallel File Server (gpfdist)..............................................................466
Loading and Unloading Data.......................................................................................................... 470
Loading Data Using an External Table................................................................................ 471
Loading and Writing Non-HDFS Custom Data.................................................................... 471
Handling Load Errors............................................................................................................474
Loading Data with gpload.....................................................................................................476
Accessing External Data with PXF...................................................................................... 477
Transforming External Data with gpfdist and gpload........................................................... 478
Loading Data with COPY..................................................................................................... 488
Running COPY in Single Row Error Isolation Mode............................................................489
Optimizing Data Load and Query Performance................................................................... 489
Unloading Data from Greenplum Database.........................................................................489
Formatting Data Files........................................................................................................... 492
Example Custom Data Access Protocol.............................................................................. 495
Managing Performance................................................................................................................... 502
Defining Database Performance.......................................................................................... 502
Common Causes of Performance Issues............................................................................ 503
Greenplum Database Memory Overview............................................................................. 506
评论0
最新资源