and/or its subsidiaries. For more information, go to https://www.broadcom.com. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. Copyright and trademark Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 To create Description 1119 Parameters 1119 Examples 1120 Compatibility 1120 See Also 1120 ALTER OPERATOR CLASS 1120 VMware Greenplum 7 Documentation VMware by Broadcom 52 Synopsis 1120 Description 1120 Parameters

Declaring Distribution Keys 537 Custom 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 over extracting them separately with per-key operators. JSON keys are matched to identical column names in the target row type. JSON type coercion for these functions might not result in desired values INDEX 1255 ALTER LANGUAGE 1256 ALTER MATERIALIZED VIEW 1256 ALTER OPERATOR 1256 ALTER OPERATOR CLASS 1257 ALTER OPERATOR FAMILY 1257 ALTER PROTOCOL 1257 ALTER RESOURCE GROUP 1257 ALTER RESOURCE QUEUE

and/or its subsidiaries. For more information, go to https://www.broadcom.com. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. Copyright and trademark Declaring Distribution Keys 563 Custom Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 To create INDEX 1312 ALTER LANGUAGE 1313 ALTER MATERIALIZED VIEW 1313 ALTER OPERATOR 1313 ALTER OPERATOR CLASS 1314 ALTER OPERATOR FAMILY 1314 ALTER PROTOCOL 1314 ALTER RESOURCE GROUP 1315 ALTER RESOURCE QUEUE

Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561 To create INDEX 1295 ALTER LANGUAGE 1296 ALTER MATERIALIZED VIEW 1296 ALTER OPERATOR 1296 ALTER OPERATOR CLASS 1297 ALTER OPERATOR FAMILY 1297 ALTER PROTOCOL 1297 ALTER RESOURCE GROUP 1297 ALTER RESOURCE QUEUE 1311 CREATE LANGUAGE 1311 CREATE MATERIALIZED VIEW 1312 CREATE OPERATOR 1312 CREATE OPERATOR CLASS 1312 CREATE OPERATOR FAMILY 1312 CREATE PROTOCOL 1313 VMware Greenplum 6 Documentation VMware

Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 To create INDEX 1280 ALTER LANGUAGE 1281 ALTER MATERIALIZED VIEW 1281 ALTER OPERATOR 1281 ALTER OPERATOR CLASS 1282 ALTER OPERATOR FAMILY 1282 ALTER PROTOCOL 1282 ALTER RESOURCE GROUP 1283 ALTER RESOURCE QUEUE 1296 CREATE LANGUAGE 1296 CREATE MATERIALIZED VIEW 1297 CREATE OPERATOR 1297 CREATE OPERATOR CLASS 1297 VMware Greenplum 6 Documentation VMware, Inc. 61 CREATE OPERATOR FAMILY 1297 CREATE PROTOCOL

Declaring Distribution Keys 535 Custom 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 INDEX 1250 ALTER LANGUAGE 1251 ALTER MATERIALIZED VIEW 1251 ALTER OPERATOR 1251 ALTER OPERATOR CLASS 1252 ALTER OPERATOR FAMILY 1252 ALTER PROTOCOL 1252 ALTER RESOURCE GROUP 1253 ALTER RESOURCE QUEUE 1266 CREATE LANGUAGE 1266 CREATE MATERIALIZED VIEW 1267 CREATE OPERATOR 1267 CREATE OPERATOR CLASS 1267 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 59 CREATE OPERATOR FAMILY 1267 CREATE

Declaring Distribution Keys 455 Custom 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 over extracting them separately with per-key operators. JSON keys are matched to identical column names in the target row type. JSON type coercion for these functions might not result in desired values INDEX 1099 ALTER LANGUAGE 1099 ALTER MATERIALIZED VIEW 1099 ALTER OPERATOR 1100 ALTER OPERATOR CLASS 1100 ALTER OPERATOR FAMILY 1100 ALTER PROTOCOL 1101 ALTER RESOURCE GROUP 1101 ALTER RESOURCE QUEUE

Declaring Distribution Keys 726 Custom Distribution Key Hash Functions 727 Example Custom Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc. 41 INDEX 1056 ALTER LANGUAGE 1056 ALTER MATERIALIZED VIEW 1056 ALTER OPERATOR 1057 ALTER OPERATOR CLASS 1057 ALTER OPERATOR FAMILY 1057 ALTER PROTOCOL 1058 ALTER RESOURCE GROUP 1058 VMware Greenplum Inc. 62 CREATE LANGUAGE 1072 CREATE MATERIALIZED VIEW 1072 CREATE OPERATOR 1072 CREATE OPERATOR CLASS 1072 CREATE OPERATOR FAMILY 1073 CREATE PROTOCOL 1073 CREATE RESOURCE GROUP 1073 CREATE RESOURCE

Declaring Distribution Keys 735 Custom Distribution Key Hash Functions 736 Example Custom Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc. 42 INDEX 1065 ALTER LANGUAGE 1065 ALTER MATERIALIZED VIEW 1065 ALTER OPERATOR 1066 ALTER OPERATOR CLASS 1066 ALTER OPERATOR FAMILY 1066 ALTER PROTOCOL 1067 ALTER RESOURCE GROUP 1067 VMware Greenplum Inc. 63 CREATE LANGUAGE 1081 CREATE MATERIALIZED VIEW 1081 CREATE OPERATOR 1081 CREATE OPERATOR CLASS 1081 CREATE OPERATOR FAMILY 1082 CREATE PROTOCOL 1082 CREATE RESOURCE GROUP 1082 CREATE RESOURCE

Declaring Distribution Keys 658 Custom Distribution Key Hash Functions 659 Example Custom Hash Operator Class 659 Choosing the Table Storage Model 661 VMware Greenplum v6.17 Documentation VMware, Inc. 37 ALTER INDEX 992 ALTER LANGUAGE 992 ALTER MATERIALIZED VIEW 992 ALTER OPERATOR 993 ALTER OPERATOR CLASS 993 ALTER OPERATOR FAMILY 993 ALTER PROTOCOL 994 ALTER RESOURCE GROUP 994 VMware Greenplum v6 Inc. 58 CREATE LANGUAGE 1008 CREATE MATERIALIZED VIEW 1008 CREATE OPERATOR 1008 CREATE OPERATOR CLASS 1008 CREATE OPERATOR FAMILY 1009 CREATE PROTOCOL 1009 CREATE RESOURCE GROUP 1009 CREATE RESOURCE