| -- |
| -- Create the base table that the other tables will be loading from |
| -- |
| CREATE TABLE base_table (a int, b int, c int, d date, e varchar(10), f varchar(100), g int, h varchar(100), i int, j numeric(6,2), k bigint, l bigint, m double precision[]); |
| CREATE EXTERNAL TABLE ext_base_table (like base_table) LOCATION('gpfdist://@hostname@:@gpfdist_port@/perfdata.csv') FORMAT 'text' (DELIMITER '|'); |
| |
| -- |
| -- Load the base table so that we can use INSERT INTO SELECT * FROM to do the load performance testing |
| -- |
| INSERT INTO base_table SELECT * FROM ext_base_table; |
| |
| -- |
| -- Create the tables to be used for performance testing |
| -- |
| CREATE TABLE ao_blocksz8192 (like base_table) WITH (appendonly=true, blocksize=8192); |
| CREATE TABLE ao_blocksz32768 (like base_table) WITH (appendonly=true, blocksize=32768); |
| CREATE TABLE ao_blocksz524288 (like base_table) WITH (appendonly=true, blocksize=524288); |
| CREATE TABLE ao_zlib_blocksz8192 (like base_table) WITH (appendonly=true, compresstype=zlib, blocksize=8192); |
| |
| CREATE TABLE aoco_blocksz8192 (like base_table) WITH (appendonly=true, orientation=column, blocksize=8192); |
| CREATE TABLE aoco_blocksz32768 (like base_table) WITH (appendonly=true, orientation=column, blocksize=32768); |
| CREATE TABLE aoco_blocksz524288 (like base_table) WITH (appendonly=true, orientation=column, blocksize=524288); |
| CREATE TABLE aoco_zlib_blocksz8192 (like base_table) WITH (appendonly=true, orientation=column, compresstype=zlib, blocksize=8192); |
