[05/51] [partial] incubator-hawq git commit: SGA import

[rv...@apache.org]

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.sql
new file mode 100644
index 0000000..b74cddc
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.sql
@@ -0,0 +1,502 @@
+DROP TABLE IF EXISTS test_ao_zlib_8;
+CREATE TABLE test_ao_zlib_8 (c0 int4, c1 text) with (appendonly=true, orientation=row, compresstype=zlib, blocksize=32768, checksum=false, compresslevel=8);
+INSERT INTO test_ao_zlib_8 values (-32768, 'hello world'),
+(-32768, ''),
+(null, ''),
+(32767, null),
+(null, 'z'),
+(128, repeat('b',1000)),
+(0, 'z'),
+(-32768, 'hello world'),
+(-128, ''),
+(-128, 'z'),
+(128, ''),
+(-32768, 'z'),
+(-128, ''),
+(32767, null),
+(0, repeat('b',1000)),
+(2147483647, 'z'),
+(-2147483648, null),
+(2147483647, 'hello world'),
+(0, ''),
+(2147483647, repeat('b',1000)),
+(null, null),
+(-128, null),
+(0, 'hello world'),
+(32767, null),
+(0, repeat('b',1000)),
+(2147483647, ''),
+(-2147483648, 'z'),
+(32767, repeat('b',1000)),
+(-128, 'z'),
+(128, 'z'),
+(null, 'z'),
+(128, ''),
+(2147483647, ''),
+(2147483647, repeat('b',1000)),
+(128, repeat('b',1000)),
+(0, ''),
+(0, ''),
+(128, ''),
+(-32768, ''),
+(-128, ''),
+(-32768, ''),
+(null, ''),
+(-2147483648, null),
+(-128, null),
+(32767, ''),
+(null, 'z'),
+(32767, ''),
+(0, 'z'),
+(32767, 'z'),
+(32767, null),
+(2147483647, 'hello world'),
+(-32768, null),
+(-128, null),
+(128, 'hello world'),
+(2147483647, ''),
+(null, 'z'),
+(0, ''),
+(-32768, ''),
+(-32768, 'hello world'),
+(0, 'hello world'),
+(0, 'z'),
+(-128, repeat('b',1000)),
+(-128, ''),
+(-32768, 'hello world'),
+(null, null),
+(-32768, 'hello world'),
+(null, null),
+(null, 'hello world'),
+(0, repeat('b',1000)),
+(-32768, ''),
+(-2147483648, 'z'),
+(32767, 'z'),
+(null, 'hello world'),
+(-32768, 'z'),
+(32767, repeat('b',1000)),
+(-32768, ''),
+(2147483647, ''),
+(-128, null),
+(32767, null),
+(-128, ''),
+(32767, ''),
+(-128, 'hello world'),
+(128, 'hello world'),
+(128, null),
+(-2147483648, 'hello world'),
+(32767, null),
+(null, 'hello world'),
+(-128, repeat('b',1000)),
+(0, ''),
+(-2147483648, ''),
+(0, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(32767, 'z'),
+(null, 'hello world'),
+(-2147483648, ''),
+(32767, null),
+(-32768, 'hello world'),
+(-32768, 'hello world'),
+(128, repeat('b',1000)),
+(-32768, ''),
+(32767, null),
+(-32768, ''),
+(-128, null),
+(0, ''),
+(null, 'hello world'),
+(128, 'hello world'),
+(-32768, 'hello world'),
+(-2147483648, 'hello world'),
+(-32768, 'z'),
+(2147483647, null),
+(-2147483648, 'hello world'),
+(-2147483648, 'hello world'),
+(32767, repeat('b',1000)),
+(128, ''),
+(-128, ''),
+(128, 'z'),
+(-128, 'hello world'),
+(-2147483648, 'z'),
+(32767, 'z'),
+(-32768, repeat('b',1000)),
+(null, null),
+(0, 'z'),
+(-2147483648, 'z'),
+(0, 'z'),
+(null, 'z'),
+(-32768, repeat('b',1000)),
+(0, 'hello world'),
+(0, ''),
+(-2147483648, 'hello world'),
+(0, null),
+(0, 'hello world'),
+(32767, 'hello world'),
+(null, repeat('b',1000)),
+(-2147483648, 'z'),
+(2147483647, 'hello world'),
+(null, 'hello world'),
+(2147483647, ''),
+(-128, repeat('b',1000)),
+(128, 'hello world'),
+(32767, 'z'),
+(-2147483648, ''),
+(-32768, 'z'),
+(128, null),
+(32767, null),
+(2147483647, null),
+(null, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-32768, ''),
+(128, 'z'),
+(-32768, repeat('b',1000)),
+(32767, ''),
+(0, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(-32768, null),
+(-2147483648, repeat('b',1000)),
+(-2147483648, null),
+(0, null),
+(-128, repeat('b',1000)),
+(2147483647, null),
+(-32768, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(2147483647, null),
+(-128, 'hello world'),
+(0, ''),
+(-32768, 'z'),
+(128, ''),
+(-128, 'z'),
+(null, repeat('b',1000)),
+(-32768, 'hello world'),
+(128, repeat('b',1000)),
+(-32768, null),
+(32767, null),
+(32767, 'z'),
+(2147483647, null),
+(-32768, ''),
+(32767, 'hello world'),
+(null, repeat('b',1000)),
+(2147483647, 'hello world'),
+(-128, 'z'),
+(2147483647, ''),
+(0, ''),
+(-128, 'hello world'),
+(-128, repeat('b',1000)),
+(-32768, 'z'),
+(128, repeat('b',1000)),
+(null, repeat('b',1000)),
+(-128, ''),
+(-2147483648, ''),
+(32767, ''),
+(null, ''),
+(128, 'z'),
+(32767, null),
+(0, 'hello world'),
+(2147483647, 'hello world'),
+(-2147483648, 'z'),
+(null, 'z'),
+(128, 'hello world'),
+(32767, repeat('b',1000)),
+(-2147483648, 'z'),
+(2147483647, null),
+(-128, null),
+(-128, 'z'),
+(32767, ''),
+(0, repeat('b',1000)),
+(0, 'z'),
+(32767, ''),
+(32767, 'z'),
+(2147483647, repeat('b',1000)),
+(-128, 'hello world'),
+(null, ''),
+(-32768, 'z'),
+(null, 'hello world'),
+(128, null),
+(-128, null),
+(32767, null),
+(-2147483648, 'hello world'),
+(32767, 'hello world'),
+(128, null),
+(32767, 'z'),
+(-128, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(0, 'hello world'),
+(2147483647, repeat('b',1000)),
+(-32768, 'z'),
+(null, 'hello world'),
+(null, repeat('b',1000)),
+(null, ''),
+(2147483647, 'z'),
+(null, repeat('b',1000)),
+(128, 'z'),
+(-2147483648, repeat('b',1000)),
+(-128, 'z'),
+(0, 'z'),
+(2147483647, repeat('b',1000)),
+(null, ''),
+(0, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(0, repeat('b',1000)),
+(null, 'z'),
+(0, repeat('b',1000)),
+(0, null),
+(2147483647, repeat('b',1000)),
+(32767, 'hello world'),
+(128, 'z'),
+(-32768, null),
+(-2147483648, ''),
+(2147483647, null),
+(2147483647, 'z'),
+(-128, null),
+(32767, repeat('b',1000)),
+(32767, 'hello world'),
+(0, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-128, null),
+(null, ''),
+(32767, 'hello world'),
+(-128, repeat('b',1000)),
+(-128, 'hello world'),
+(-32768, ''),
+(-128, repeat('b',1000)),
+(128, 'hello world'),
+(null, repeat('b',1000)),
+(-32768, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(null, null),
+(2147483647, 'z'),
+(-32768, ''),
+(null, repeat('b',1000)),
+(-32768, null),
+(-2147483648, 'z'),
+(null, null),
+(32767, ''),
+(-128, repeat('b',1000)),
+(32767, 'z'),
+(-128, 'hello world'),
+(32767, ''),
+(32767, 'z'),
+(0, ''),
+(null, ''),
+(null, 'z'),
+(0, 'z'),
+(32767, ''),
+(null, ''),
+(null, repeat('b',1000)),
+(0, repeat('b',1000)),
+(2147483647, null),
+(128, ''),
+(-2147483648, ''),
+(null, 'z'),
+(2147483647, 'z'),
+(-128, null),
+(null, null),
+(null, repeat('b',1000)),
+(null, repeat('b',1000)),
+(2147483647, null),
+(-128, 'hello world'),
+(128, 'hello world'),
+(null, null),
+(32767, 'hello world'),
+(-32768, ''),
+(-128, repeat('b',1000)),
+(null, ''),
+(-2147483648, repeat('b',1000)),
+(-32768, null),
+(-128, null),
+(-128, ''),
+(-128, repeat('b',1000)),
+(null, 'hello world'),
+(32767, 'z'),
+(-128, ''),
+(32767, 'z'),
+(32767, repeat('b',1000)),
+(32767, ''),
+(128, ''),
+(128, 'z'),
+(128, 'hello world'),
+(null, 'hello world'),
+(0, repeat('b',1000)),
+(128, 'hello world'),
+(-2147483648, ''),
+(null, null),
+(0, null),
+(null, ''),
+(-128, repeat('b',1000)),
+(0, ''),
+(0, ''),
+(0, 'z'),
+(32767, null),
+(32767, 'z'),
+(2147483647, repeat('b',1000)),
+(128, null),
+(-32768, ''),
+(-128, 'hello world'),
+(-32768, 'hello world'),
+(-128, repeat('b',1000)),
+(0, 'hello world'),
+(128, 'z'),
+(null, 'hello world'),
+(128, ''),
+(2147483647, repeat('b',1000)),
+(32767, 'hello world'),
+(-2147483648, ''),
+(-32768, repeat('b',1000)),
+(null, repeat('b',1000)),
+(32767, ''),
+(2147483647, ''),
+(0, 'hello world'),
+(128, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-32768, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, 'z'),
+(32767, ''),
+(-2147483648, 'hello world'),
+(128, ''),
+(-128, null),
+(0, 'hello world'),
+(0, 'z'),
+(-128, ''),
+(0, repeat('b',1000)),
+(0, ''),
+(-2147483648, 'z'),
+(32767, null),
+(128, 'z'),
+(null, 'z'),
+(-2147483648, 'hello world'),
+(-128, 'hello world'),
+(-128, 'hello world'),
+(32767, ''),
+(2147483647, ''),
+(32767, 'z'),
+(-128, ''),
+(-32768, null),
+(32767, ''),
+(-2147483648, null),
+(-32768, 'hello world'),
+(-32768, ''),
+(-32768, repeat('b',1000)),
+(128, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, null),
+(2147483647, ''),
+(-32768, 'hello world'),
+(-32768, null),
+(128, ''),
+(128, ''),
+(128, ''),
+(-32768, 'z'),
+(2147483647, 'hello world'),
+(128, null),
+(-128, repeat('b',1000)),
+(0, null),
+(null, null),
+(32767, null),
+(128, repeat('b',1000)),
+(2147483647, 'z'),
+(0, repeat('b',1000)),
+(2147483647, 'z'),
+(-2147483648, repeat('b',1000)),
+(32767, 'z'),
+(32767, ''),
+(128, 'hello world'),
+(-128, repeat('b',1000)),
+(-32768, 'z'),
+(32767, repeat('b',1000)),
+(0, null),
+(0, 'z'),
+(2147483647, repeat('b',1000)),
+(128, null),
+(2147483647, null),
+(null, 'z'),
+(-2147483648, 'z'),
+(-32768, 'hello world'),
+(null, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(128, repeat('b',1000)),
+(-128, 'z'),
+(-128, 'hello world'),
+(-128, 'hello world'),
+(128, repeat('b',1000)),
+(0, 'hello world'),
+(32767, null),
+(2147483647, repeat('b',1000)),
+(2147483647, null),
+(0, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-128, 'z'),
+(2147483647, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-128, ''),
+(-32768, 'z'),
+(null, 'hello world'),
+(0, 'hello world'),
+(-128, null),
+(32767, null),
+(0, 'hello world'),
+(0, repeat('b',1000)),
+(null, 'z'),
+(-2147483648, 'hello world'),
+(2147483647, repeat('b',1000)),
+(null, repeat('b',1000)),
+(128, ''),
+(-128, 'hello world'),
+(2147483647, ''),
+(32767, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-128, null),
+(32767, null),
+(-32768, repeat('b',1000)),
+(0, ''),
+(2147483647, 'z'),
+(-128, 'hello world'),
+(32767, null),
+(128, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(0, null),
+(32767, 'hello world'),
+(0, 'hello world'),
+(-128, null),
+(128, null),
+(null, 'hello world'),
+(-128, 'hello world'),
+(0, 'hello world'),
+(-32768, 'hello world'),
+(32767, 'hello world'),
+(128, ''),
+(-128, 'z'),
+(-128, null),
+(-128, ''),
+(-32768, ''),
+(2147483647, ''),
+(-32768, 'hello world'),
+(32767, repeat('b',1000)),
+(-128, ''),
+(2147483647, ''),
+(32767, ''),
+(2147483647, null),
+(null, null),
+(-128, 'z'),
+(-128, 'z'),
+(128, 'z'),
+(32767, repeat('b',1000)),
+(32767, null),
+(2147483647, null),
+(-2147483648, ''),
+(-2147483648, ''),
+(-128, ''),
+(-32768, 'hello world'),
+(2147483647, 'z'),
+(2147483647, ''),
+(-2147483648, ''),
+(-128, 'hello world'),
+(32767, ''),
+(0, ''),
+(null, ''),
+(2147483647, 'hello world'),
+(-128, repeat('b',1000));
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.yaml
new file mode 100644
index 0000000..afec159
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_8/test_ao_zlib_8.yaml
@@ -0,0 +1,23 @@
+AO_FileLocations:
+  Blocksize: 32768
+  Checksum: false
+  CompressionLevel: 8
+  CompressionType: zlib
+  Files:
+  - path: test-data/hawq-data/gpseg0/16385/179545/179586.1
+    size: 976
+  - path: test-data/hawq-data/gpseg1/16385/179545/179586.1
+    size: 2592
+AO_Schema:
+- name: c0
+  type: int4
+- name: c1
+  type: text
+DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 1.2.0.0 build
+  dev) on i386-apple-darwin11.4.2, compiled by GCC gcc (GCC) 4.4.2 compiled on Feb
+  28 2014 09:52:04 (with assert checking)
+DFS_URL: hdfs://127.0.0.1:9000
+Encoding: UTF8
+FileFormat: AO
+TableName: public.test_ao_zlib_8
+Version: 1.0.0