You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by rv...@apache.org on 2015/09/19 02:36:05 UTC
[22/51] [partial] incubator-hawq git commit: SGA import
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.sql
new file mode 100644
index 0000000..a45b698
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.sql
@@ -0,0 +1,502 @@
+DROP TABLE IF EXISTS test_ao_quicklz;
+CREATE TABLE test_ao_quicklz (c0 int4, c1 text) with (appendonly=true, orientation=row, compresstype=quicklz, blocksize=32768, checksum=false, compresslevel=1);
+INSERT INTO test_ao_quicklz values (0, 'hello world'),
+(-128, 'z'),
+(-128, repeat('b',1000)),
+(0, repeat('b',1000)),
+(-128, null),
+(-128, 'hello world'),
+(-32768, 'hello world'),
+(2147483647, 'z'),
+(-2147483648, 'hello world'),
+(32767, null),
+(-32768, 'z'),
+(32767, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(2147483647, ''),
+(-2147483648, ''),
+(-2147483648, ''),
+(-2147483648, 'z'),
+(128, null),
+(0, null),
+(32767, 'z'),
+(2147483647, null),
+(2147483647, ''),
+(2147483647, null),
+(32767, 'hello world'),
+(0, 'hello world'),
+(-128, ''),
+(2147483647, 'hello world'),
+(128, null),
+(0, 'hello world'),
+(null, 'hello world'),
+(32767, repeat('b',1000)),
+(128, repeat('b',1000)),
+(-2147483648, null),
+(2147483647, 'z'),
+(-128, null),
+(32767, ''),
+(128, 'hello world'),
+(null, 'z'),
+(0, 'hello world'),
+(2147483647, repeat('b',1000)),
+(null, ''),
+(128, ''),
+(32767, 'hello world'),
+(0, repeat('b',1000)),
+(-2147483648, null),
+(-2147483648, repeat('b',1000)),
+(128, repeat('b',1000)),
+(0, null),
+(-128, null),
+(2147483647, ''),
+(null, null),
+(null, repeat('b',1000)),
+(null, null),
+(32767, 'z'),
+(0, repeat('b',1000)),
+(-32768, null),
+(-2147483648, ''),
+(128, null),
+(-2147483648, null),
+(-32768, ''),
+(-32768, null),
+(2147483647, ''),
+(128, ''),
+(32767, 'hello world'),
+(-128, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-128, 'z'),
+(2147483647, ''),
+(32767, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-32768, ''),
+(2147483647, ''),
+(128, null),
+(0, 'hello world'),
+(0, ''),
+(0, repeat('b',1000)),
+(-32768, ''),
+(2147483647, null),
+(null, 'hello world'),
+(-128, 'z'),
+(-32768, 'z'),
+(32767, ''),
+(0, repeat('b',1000)),
+(-128, 'z'),
+(null, 'z'),
+(-2147483648, 'z'),
+(2147483647, 'z'),
+(-2147483648, 'hello world'),
+(128, ''),
+(128, 'z'),
+(null, 'hello world'),
+(0, 'z'),
+(-128, 'hello world'),
+(null, 'z'),
+(128, 'z'),
+(-128, repeat('b',1000)),
+(0, 'z'),
+(2147483647, 'z'),
+(null, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-128, null),
+(-2147483648, repeat('b',1000)),
+(null, 'z'),
+(-128, ''),
+(2147483647, 'hello world'),
+(0, null),
+(-128, null),
+(2147483647, 'z'),
+(-32768, ''),
+(32767, 'z'),
+(0, ''),
+(0, 'hello world'),
+(32767, ''),
+(128, 'z'),
+(2147483647, repeat('b',1000)),
+(-2147483648, null),
+(-128, null),
+(-128, repeat('b',1000)),
+(-2147483648, null),
+(null, ''),
+(-32768, null),
+(32767, null),
+(-32768, repeat('b',1000)),
+(null, null),
+(128, ''),
+(2147483647, 'z'),
+(0, 'hello world'),
+(null, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-2147483648, ''),
+(2147483647, 'hello world'),
+(-32768, null),
+(0, ''),
+(-2147483648, null),
+(null, 'z'),
+(-2147483648, repeat('b',1000)),
+(-128, 'hello world'),
+(32767, 'z'),
+(32767, ''),
+(0, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(-2147483648, 'z'),
+(128, 'hello world'),
+(-32768, 'z'),
+(0, null),
+(-2147483648, repeat('b',1000)),
+(-2147483648, ''),
+(32767, null),
+(0, 'hello world'),
+(128, null),
+(-2147483648, null),
+(-128, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(null, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(-128, 'z'),
+(2147483647, 'hello world'),
+(-128, 'hello world'),
+(2147483647, null),
+(-32768, null),
+(-32768, 'hello world'),
+(null, null),
+(null, repeat('b',1000)),
+(2147483647, null),
+(2147483647, null),
+(2147483647, repeat('b',1000)),
+(-2147483648, ''),
+(2147483647, 'hello world'),
+(-32768, 'hello world'),
+(-128, repeat('b',1000)),
+(-128, null),
+(-128, ''),
+(null, 'hello world'),
+(32767, repeat('b',1000)),
+(2147483647, null),
+(-32768, ''),
+(null, null),
+(-128, 'z'),
+(-128, ''),
+(-2147483648, 'hello world'),
+(-128, 'z'),
+(-32768, 'z'),
+(2147483647, 'z'),
+(null, 'z'),
+(-128, ''),
+(2147483647, ''),
+(null, repeat('b',1000)),
+(128, 'hello world'),
+(128, null),
+(0, ''),
+(-2147483648, 'hello world'),
+(2147483647, repeat('b',1000)),
+(-32768, null),
+(2147483647, 'z'),
+(-128, 'hello world'),
+(128, ''),
+(2147483647, 'hello world'),
+(128, repeat('b',1000)),
+(-128, ''),
+(128, null),
+(-32768, ''),
+(0, 'hello world'),
+(-128, repeat('b',1000)),
+(-128, null),
+(32767, repeat('b',1000)),
+(32767, 'hello world'),
+(2147483647, 'z'),
+(0, repeat('b',1000)),
+(0, 'z'),
+(2147483647, 'hello world'),
+(-32768, 'z'),
+(32767, ''),
+(-2147483648, 'hello world'),
+(0, null),
+(-128, null),
+(128, 'z'),
+(128, 'hello world'),
+(-32768, 'hello world'),
+(-32768, 'hello world'),
+(-128, 'hello world'),
+(32767, repeat('b',1000)),
+(0, ''),
+(128, repeat('b',1000)),
+(-128, 'hello world'),
+(0, 'z'),
+(-32768, repeat('b',1000)),
+(32767, null),
+(0, 'hello world'),
+(-128, ''),
+(-32768, 'z'),
+(-32768, 'z'),
+(-32768, 'hello world'),
+(-32768, repeat('b',1000)),
+(0, null),
+(-128, 'hello world'),
+(128, repeat('b',1000)),
+(-128, 'hello world'),
+(2147483647, ''),
+(128, 'z'),
+(0, null),
+(-2147483648, 'z'),
+(128, ''),
+(-2147483648, null),
+(-32768, repeat('b',1000)),
+(0, ''),
+(null, null),
+(2147483647, ''),
+(2147483647, ''),
+(null, ''),
+(32767, 'hello world'),
+(null, 'z'),
+(null, null),
+(32767, ''),
+(32767, 'z'),
+(-2147483648, null),
+(-2147483648, 'z'),
+(-128, null),
+(null, 'hello world'),
+(-128, null),
+(128, ''),
+(-128, ''),
+(-32768, 'hello world'),
+(32767, repeat('b',1000)),
+(128, 'z'),
+(128, repeat('b',1000)),
+(-2147483648, ''),
+(-32768, null),
+(2147483647, 'hello world'),
+(null, repeat('b',1000)),
+(2147483647, 'z'),
+(32767, null),
+(128, repeat('b',1000)),
+(0, repeat('b',1000)),
+(2147483647, ''),
+(128, repeat('b',1000)),
+(32767, 'hello world'),
+(128, 'hello world'),
+(2147483647, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(0, ''),
+(-128, 'z'),
+(2147483647, ''),
+(-32768, null),
+(-128, null),
+(-128, 'z'),
+(null, 'hello world'),
+(32767, repeat('b',1000)),
+(32767, null),
+(-128, 'z'),
+(0, 'z'),
+(-128, 'z'),
+(2147483647, 'z'),
+(0, 'z'),
+(128, null),
+(0, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(2147483647, 'hello world'),
+(0, repeat('b',1000)),
+(null, null),
+(128, null),
+(-128, 'hello world'),
+(32767, repeat('b',1000)),
+(null, null),
+(128, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(0, ''),
+(-2147483648, 'z'),
+(null, repeat('b',1000)),
+(128, null),
+(null, 'hello world'),
+(-128, ''),
+(32767, 'z'),
+(-32768, ''),
+(null, 'hello world'),
+(32767, 'hello world'),
+(128, 'z'),
+(2147483647, null),
+(2147483647, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(2147483647, 'z'),
+(32767, repeat('b',1000)),
+(null, 'z'),
+(2147483647, ''),
+(null, repeat('b',1000)),
+(128, repeat('b',1000)),
+(null, null),
+(-32768, 'hello world'),
+(128, ''),
+(32767, repeat('b',1000)),
+(32767, 'z'),
+(0, null),
+(0, ''),
+(32767, null),
+(null, repeat('b',1000)),
+(-32768, ''),
+(null, 'hello world'),
+(-128, 'z'),
+(-2147483648, null),
+(0, 'hello world'),
+(2147483647, ''),
+(0, 'z'),
+(128, null),
+(-128, 'z'),
+(-128, 'z'),
+(null, ''),
+(2147483647, ''),
+(0, repeat('b',1000)),
+(2147483647, null),
+(32767, null),
+(128, ''),
+(null, 'z'),
+(-128, 'hello world'),
+(null, repeat('b',1000)),
+(2147483647, 'z'),
+(-128, repeat('b',1000)),
+(-128, null),
+(-32768, null),
+(0, 'z'),
+(-32768, null),
+(-128, 'hello world'),
+(-32768, null),
+(null, 'z'),
+(32767, 'z'),
+(32767, 'hello world'),
+(2147483647, repeat('b',1000)),
+(null, null),
+(null, 'z'),
+(-2147483648, 'z'),
+(null, 'z'),
+(-128, 'hello world'),
+(-128, null),
+(0, ''),
+(2147483647, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-128, ''),
+(32767, null),
+(-32768, repeat('b',1000)),
+(-32768, ''),
+(0, repeat('b',1000)),
+(2147483647, ''),
+(-32768, 'hello world'),
+(128, null),
+(2147483647, ''),
+(-128, 'z'),
+(-2147483648, 'hello world'),
+(0, 'z'),
+(32767, null),
+(2147483647, ''),
+(-32768, null),
+(-32768, ''),
+(null, null),
+(null, ''),
+(32767, repeat('b',1000)),
+(-2147483648, ''),
+(32767, 'hello world'),
+(128, 'hello world'),
+(null, 'z'),
+(0, repeat('b',1000)),
+(-2147483648, 'z'),
+(-2147483648, repeat('b',1000)),
+(null, 'hello world'),
+(-32768, 'z'),
+(-128, 'hello world'),
+(128, ''),
+(-2147483648, 'z'),
+(-32768, null),
+(null, 'hello world'),
+(128, 'z'),
+(32767, 'z'),
+(-32768, ''),
+(32767, ''),
+(-2147483648, 'z'),
+(32767, 'z'),
+(2147483647, repeat('b',1000)),
+(-2147483648, 'z'),
+(null, 'z'),
+(null, 'z'),
+(2147483647, 'z'),
+(-128, ''),
+(128, ''),
+(-2147483648, null),
+(-2147483648, 'hello world'),
+(128, ''),
+(null, 'hello world'),
+(2147483647, 'hello world'),
+(-128, 'hello world'),
+(null, null),
+(-32768, 'z'),
+(32767, null),
+(2147483647, 'z'),
+(2147483647, 'z'),
+(128, 'hello world'),
+(null, 'hello world'),
+(0, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(2147483647, ''),
+(-32768, 'z'),
+(128, 'z'),
+(-32768, null),
+(128, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(2147483647, 'z'),
+(32767, ''),
+(0, null),
+(128, 'hello world'),
+(-32768, 'z'),
+(0, 'z'),
+(null, 'hello world'),
+(128, repeat('b',1000)),
+(0, repeat('b',1000)),
+(32767, 'z'),
+(-32768, 'z'),
+(-32768, ''),
+(-32768, 'hello world'),
+(0, 'hello world'),
+(-2147483648, ''),
+(-2147483648, null),
+(0, ''),
+(32767, ''),
+(2147483647, 'z'),
+(-2147483648, 'z'),
+(null, repeat('b',1000)),
+(0, ''),
+(128, null),
+(-2147483648, 'z'),
+(-2147483648, 'hello world'),
+(2147483647, ''),
+(32767, 'hello world'),
+(-32768, repeat('b',1000)),
+(-32768, ''),
+(32767, null),
+(128, 'hello world'),
+(0, ''),
+(null, ''),
+(-32768, null),
+(-128, 'z'),
+(-128, 'z'),
+(0, 'hello world'),
+(32767, repeat('b',1000)),
+(-2147483648, null),
+(32767, ''),
+(32767, ''),
+(-32768, repeat('b',1000)),
+(-32768, ''),
+(0, 'z'),
+(null, 'z'),
+(-128, ''),
+(-2147483648, null),
+(null, 'z'),
+(0, 'hello world'),
+(0, ''),
+(32767, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(0, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(-2147483648, ''),
+(2147483647, 'z'),
+(2147483647, null);
\ 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_quicklz/test_ao_quicklz.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.yaml
new file mode 100644
index 0000000..4d973b4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_quicklz/test_ao_quicklz.yaml
@@ -0,0 +1,23 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 1
+ CompressionType: quicklz
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179546.1
+ size: 1160
+ - path: test-data/hawq-data/gpseg1/16385/179545/179546.1
+ size: 4608
+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_quicklz
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.ans
new file mode 100644
index 0000000..d215d92
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.ans
@@ -0,0 +1,3 @@
+0
+1
+null
\ 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_types_bit/test_ao_types_bit.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.sql
new file mode 100644
index 0000000..2b3b166
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_bit;
+CREATE TABLE test_ao_types_bit (c0 bit) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_bit values ('1'),
+('0'),
+(null);
\ 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_types_bit/test_ao_types_bit.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.yaml
new file mode 100644
index 0000000..83f463a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit/test_ao_types_bit.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179641.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179641.1
+ size: 64
+AO_Schema:
+- name: c0
+ type: bit
+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_types_bit
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.ans
new file mode 100644
index 0000000..081cd39
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.ans
@@ -0,0 +1,3 @@
+00010
+10010
+null
\ 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_types_bit5/test_ao_types_bit5.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.sql
new file mode 100644
index 0000000..16a4199
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_bit5;
+CREATE TABLE test_ao_types_bit5 (c0 bit(5)) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_bit5 values ('10010'),
+('00010'),
+(null);
\ 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_types_bit5/test_ao_types_bit5.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.yaml
new file mode 100644
index 0000000..5690a43
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bit5/test_ao_types_bit5.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179646.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179646.1
+ size: 64
+AO_Schema:
+- name: c0
+ type: bit
+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_types_bit5
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.ans
new file mode 100644
index 0000000..c08ed6c
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.ans
@@ -0,0 +1,3 @@
+false
+null
+true
\ 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_types_bool/test_ao_types_bool.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.sql
new file mode 100644
index 0000000..2e633fd
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_bool;
+CREATE TABLE test_ao_types_bool (c0 bool) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_bool values ('true'),
+('false'),
+(null);
\ 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_types_bool/test_ao_types_bool.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.yaml
new file mode 100644
index 0000000..f06f5d6
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bool/test_ao_types_bool.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179636.1
+ size: 48
+ - path: test-data/hawq-data/gpseg1/16385/179545/179636.1
+ size: 24
+AO_Schema:
+- name: c0
+ type: bool
+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_types_bool
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.ans
new file mode 100644
index 0000000..def8e29
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.ans
@@ -0,0 +1,3 @@
+(2,3),(0,1)
+(200,400),(100,200)
+null
\ 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_types_box/test_ao_types_box.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.sql
new file mode 100644
index 0000000..65f05d2
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_box;
+CREATE TABLE test_ao_types_box (c0 box) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_box values ('((0,1),(2,3))'),
+('((100,200),(200,400))'),
+(null);
\ 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_types_box/test_ao_types_box.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.yaml
new file mode 100644
index 0000000..2e50326
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_box/test_ao_types_box.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179746.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179746.1
+ size: 120
+AO_Schema:
+- name: c0
+ type: box
+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_types_box
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.ans
new file mode 100644
index 0000000..c60294a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.ans
@@ -0,0 +1,3 @@
+aaaaaaaaaaaaaaaaaaa
+hello world
+null
\ 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_types_bytea/test_ao_types_bytea.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.sql
new file mode 100644
index 0000000..7509436
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_bytea;
+CREATE TABLE test_ao_types_bytea (c0 bytea) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_bytea values ('hello world'),
+('aaaaaaaaaaaaaaaaaaa'),
+(null);
\ 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_types_bytea/test_ao_types_bytea.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.yaml
new file mode 100644
index 0000000..e17f786
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_bytea/test_ao_types_bytea.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179656.1
+ size: 72
+ - path: test-data/hawq-data/gpseg1/16385/179545/179656.1
+ size: 40
+AO_Schema:
+- name: c0
+ type: bytea
+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_types_bytea
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.ans
new file mode 100644
index 0000000..04726ee
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.ans
@@ -0,0 +1,4 @@
+123456789a
+aaaa
+bbccddeeff
+null
\ 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_types_char10/test_ao_types_char10.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.sql
new file mode 100644
index 0000000..c44e5da
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_char10;
+CREATE TABLE test_ao_types_char10 (c0 char(10)) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_char10 values ('123456789a'),
+('bbccddeeff'),
+('aaaa'),
+(null);
\ 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_types_char10/test_ao_types_char10.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.yaml
new file mode 100644
index 0000000..bfb1a70
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_char10/test_ao_types_char10.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179691.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179691.1
+ size: 104
+AO_Schema:
+- name: c0
+ type: bpchar
+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_types_char10
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.ans
new file mode 100644
index 0000000..76d690e
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.ans
@@ -0,0 +1,4 @@
+172.20.143.0/24
+192.168.1.255/32
+2001:db8:85a3:8d3:1319:8a2e:370:7344/128
+null
\ 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_types_cidr/test_ao_types_cidr.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.sql
new file mode 100644
index 0000000..adbd458
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_cidr;
+CREATE TABLE test_ao_types_cidr (c0 cidr) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_cidr values ('2001:db8:85a3:8d3:1319:8a2e:370:7344/128'),
+('192.168.1.255/32'),
+('172.20.143.0/24'),
+(null);
\ 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_types_cidr/test_ao_types_cidr.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.yaml
new file mode 100644
index 0000000..8065202
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_cidr/test_ao_types_cidr.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179776.1
+ size: 56
+ - path: test-data/hawq-data/gpseg1/16385/179545/179776.1
+ size: 80
+AO_Schema:
+- name: c0
+ type: cidr
+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_types_cidr
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.ans
new file mode 100644
index 0000000..6ebd06f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.ans
@@ -0,0 +1,3 @@
+<(1,2),3>
+<(100,200),300>
+null
\ 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_types_circle/test_ao_types_circle.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.sql
new file mode 100644
index 0000000..fbac31a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_circle;
+CREATE TABLE test_ao_types_circle (c0 circle) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_circle values ('<(1,2),3>'),
+('<(100,200),300>'),
+(null);
\ 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_types_circle/test_ao_types_circle.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.yaml
new file mode 100644
index 0000000..7317194
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_circle/test_ao_types_circle.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179751.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179751.1
+ size: 104
+AO_Schema:
+- name: c0
+ type: circle
+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_types_circle
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.ans
new file mode 100644
index 0000000..55df816
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.ans
@@ -0,0 +1,4 @@
+2014-03-02
+4277-12-31
+4713-01-01
+null
\ 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_types_date/test_ao_types_date.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.sql
new file mode 100644
index 0000000..e985af5
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_date;
+CREATE TABLE test_ao_types_date (c0 date) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_date values ('4713-01-01 BC'),
+('2014-03-02'),
+('4277-12-31 AD'),
+(null);
\ 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_types_date/test_ao_types_date.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.yaml
new file mode 100644
index 0000000..2f0ad9f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_date/test_ao_types_date.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179706.1
+ size: 48
+ - path: test-data/hawq-data/gpseg1/16385/179545/179706.1
+ size: 48
+AO_Schema:
+- name: c0
+ type: date
+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_types_date
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.ans
new file mode 100644
index 0000000..32928da
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.ans
@@ -0,0 +1,10 @@
+-12.3456
+-Infinity
+0
+1
+123456
+2.0009999
+9999.123
+Infinity
+NaN
+null
\ 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_types_float4/test_ao_types_float4.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.sql
new file mode 100644
index 0000000..6f71bf4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.sql
@@ -0,0 +1,12 @@
+DROP TABLE IF EXISTS test_ao_types_float4;
+CREATE TABLE test_ao_types_float4 (c0 float4) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_float4 values (-12.3456),
+(0),
+(1.00),
+(2.001),
+(9999.1234),
+(123456),
+('Infinity'),
+('-Infinity'),
+('NaN'),
+(null);
\ 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_types_float4/test_ao_types_float4.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.yaml
new file mode 100644
index 0000000..06eaaa7
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float4/test_ao_types_float4.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179676.1
+ size: 88
+ - path: test-data/hawq-data/gpseg1/16385/179545/179676.1
+ size: 64
+AO_Schema:
+- name: c0
+ type: float4
+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_types_float4
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.ans
new file mode 100644
index 0000000..e7bd15d
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.ans
@@ -0,0 +1,13 @@
+-12.8765
+-123.456
+-Infinity
+0
+1
+12345
+128
+1298765
+2.0009999999999999
+999999
+Infinity
+NaN
+null
\ 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_types_float8/test_ao_types_float8.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.sql
new file mode 100644
index 0000000..1102cd4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS test_ao_types_float8;
+CREATE TABLE test_ao_types_float8 (c0 float8) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_float8 values (-123.456),
+(-12.8765),
+(0),
+(1.00),
+(2.001),
+(128),
+(1298765),
+(999999),
+(12345),
+('Infinity'),
+('-Infinity'),
+('NaN'),
+(null);
\ 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_types_float8/test_ao_types_float8.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.yaml
new file mode 100644
index 0000000..dce9075
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_float8/test_ao_types_float8.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179681.1
+ size: 128
+ - path: test-data/hawq-data/gpseg1/16385/179545/179681.1
+ size: 152
+AO_Schema:
+- name: c0
+ type: float8
+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_types_float8
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.ans
new file mode 100644
index 0000000..d390e5f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.ans
@@ -0,0 +1,5 @@
+172.20.143.0
+192.168.1.255/24
+2001::7344
+2001:db8:85a3:8d3:1319:8a2e:370:7344/64
+null
\ 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_types_inet/test_ao_types_inet.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.sql
new file mode 100644
index 0000000..21de2a6
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS test_ao_types_inet;
+CREATE TABLE test_ao_types_inet (c0 inet) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_inet values ('2001:db8:85a3:8d3:1319:8a2e:370:7344/64'),
+('2001::7344'),
+('172.20.143.0'),
+('192.168.1.255/24'),
+(null);
\ 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_types_inet/test_ao_types_inet.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.yaml
new file mode 100644
index 0000000..dca1d2a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_inet/test_ao_types_inet.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179771.1
+ size: 88
+ - path: test-data/hawq-data/gpseg1/16385/179545/179771.1
+ size: 80
+AO_Schema:
+- name: c0
+ type: inet
+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_types_inet
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.ans
new file mode 100644
index 0000000..e0b42fd
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.ans
@@ -0,0 +1,6 @@
+-128
+-32768
+0
+128
+32767
+null
\ 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_types_int2/test_ao_types_int2.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.sql
new file mode 100644
index 0000000..98a6be8
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS test_ao_types_int2;
+CREATE TABLE test_ao_types_int2 (c0 int2) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_int2 values (-32768),
+(-128),
+(0),
+(128),
+(32767),
+(null);
\ 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_types_int2/test_ao_types_int2.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.yaml
new file mode 100644
index 0000000..e101a89
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int2/test_ao_types_int2.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179661.1
+ size: 48
+ - path: test-data/hawq-data/gpseg1/16385/179545/179661.1
+ size: 64
+AO_Schema:
+- name: c0
+ type: int2
+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_types_int2
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.ans
new file mode 100644
index 0000000..a868fa7
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.ans
@@ -0,0 +1,8 @@
+-128
+-2147483648
+-32768
+0
+128
+2147483647
+32767
+null
\ 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_types_int4/test_ao_types_int4.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.sql
new file mode 100644
index 0000000..0a050c7
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS test_ao_types_int4;
+CREATE TABLE test_ao_types_int4 (c0 int4) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_int4 values (-2147483648),
+(-32768),
+(-128),
+(0),
+(128),
+(32767),
+(2147483647),
+(null);
\ 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_types_int4/test_ao_types_int4.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.yaml
new file mode 100644
index 0000000..9794fc4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4/test_ao_types_int4.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179666.1
+ size: 48
+ - path: test-data/hawq-data/gpseg1/16385/179545/179666.1
+ size: 88
+AO_Schema:
+- name: c0
+ type: int4
+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_types_int4
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.ans
new file mode 100644
index 0000000..272b468
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.ans
@@ -0,0 +1,4 @@
+null
+{1,2,3,4}
+{{1,2},{3,4}}
+{{{1,2},{3,4}},{{5,6},{7,8}}}
\ 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_types_int4_array/test_ao_types_int4_array.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.sql
new file mode 100644
index 0000000..9a94f01
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_int4_array;
+CREATE TABLE test_ao_types_int4_array (c0 int4[]) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_int4_array values ('{1,2,3,4}'),
+('{{1,2},{3,4}}'),
+('{{{1,2},{3,4}},{{5,6},{7,8}}}'),
+(null);
\ 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_types_int4_array/test_ao_types_int4_array.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.yaml
new file mode 100644
index 0000000..ea04982
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int4_array/test_ao_types_int4_array.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179786.1
+ size: 224
+ - path: test-data/hawq-data/gpseg1/16385/179545/179786.1
+ size: 0
+AO_Schema:
+- name: c0
+ type: _int4
+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_types_int4_array
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.ans
new file mode 100644
index 0000000..8f7245d
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.ans
@@ -0,0 +1,10 @@
+-128
+-2147483648
+-32768
+-9223372036854775808
+0
+128
+2147483647
+32767
+9223372036854775807
+null
\ 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_types_int8/test_ao_types_int8.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.sql
new file mode 100644
index 0000000..698357b
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.sql
@@ -0,0 +1,12 @@
+DROP TABLE IF EXISTS test_ao_types_int8;
+CREATE TABLE test_ao_types_int8 (c0 int8) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_int8 values (-9223372036854775808),
+(-2147483648),
+(-32768),
+(-128),
+(0),
+(128),
+(32767),
+(2147483647),
+(9223372036854775807),
+(null);
\ 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_types_int8/test_ao_types_int8.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.yaml
new file mode 100644
index 0000000..9e2a308
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_int8/test_ao_types_int8.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179671.1
+ size: 56
+ - path: test-data/hawq-data/gpseg1/16385/179545/179671.1
+ size: 168
+AO_Schema:
+- name: c0
+ type: int8
+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_types_int8
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.ans
new file mode 100644
index 0000000..a109b6f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.ans
@@ -0,0 +1,3 @@
+-178000000 years
+178000000 years
+null
\ 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_types_interval/test_ao_types_interval.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.sql
new file mode 100644
index 0000000..9ff013e
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_interval;
+CREATE TABLE test_ao_types_interval (c0 interval) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_interval values ('-178000000 years'),
+('178000000 years'),
+(null);
\ 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_types_interval/test_ao_types_interval.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.yaml
new file mode 100644
index 0000000..bc2efa7
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_interval/test_ao_types_interval.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179731.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179731.1
+ size: 80
+AO_Schema:
+- name: c0
+ type: interval
+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_types_interval
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.ans
new file mode 100644
index 0000000..ecdbd6e
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.ans
@@ -0,0 +1,3 @@
+[(0,0),(6,6)]
+[(1,1),(2,2)]
+null
\ 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_types_lseg/test_ao_types_lseg.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.sql
new file mode 100644
index 0000000..7cd211f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_lseg;
+CREATE TABLE test_ao_types_lseg (c0 lseg) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_lseg values ('[(0,0),(6,6)]'),
+('[(1,1),(2,2)]'),
+(null);
\ 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_types_lseg/test_ao_types_lseg.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.yaml
new file mode 100644
index 0000000..0f63d3d
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_lseg/test_ao_types_lseg.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179741.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179741.1
+ size: 120
+AO_Schema:
+- name: c0
+ type: lseg
+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_types_lseg
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.ans
new file mode 100644
index 0000000..3e41529
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.ans
@@ -0,0 +1,2 @@
+ff:89:71:45:ae:01
+null
\ 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_types_macaddr/test_ao_types_macaddr.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.sql
new file mode 100644
index 0000000..3dbdae6
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.sql
@@ -0,0 +1,4 @@
+DROP TABLE IF EXISTS test_ao_types_macaddr;
+CREATE TABLE test_ao_types_macaddr (c0 macaddr) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_macaddr values ('FF:89:71:45:AE:01'),
+(null);
\ 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_types_macaddr/test_ao_types_macaddr.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.yaml
new file mode 100644
index 0000000..7648e31
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_macaddr/test_ao_types_macaddr.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179766.1
+ size: 56
+ - path: test-data/hawq-data/gpseg1/16385/179545/179766.1
+ size: 0
+AO_Schema:
+- name: c0
+ type: macaddr
+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_types_macaddr
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.ans
new file mode 100644
index 0000000..ce5d116
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.ans
@@ -0,0 +1,3 @@
+0.0001
+6.54
+null
\ 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_types_numeric/test_ao_types_numeric.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.sql
new file mode 100644
index 0000000..03e300c
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_numeric;
+CREATE TABLE test_ao_types_numeric (c0 numeric) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_numeric values (6.54),
+(0.0001),
+(null);
\ 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_types_numeric/test_ao_types_numeric.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.yaml
new file mode 100644
index 0000000..cdd8907
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_numeric/test_ao_types_numeric.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179686.1
+ size: 72
+ - path: test-data/hawq-data/gpseg1/16385/179545/179686.1
+ size: 0
+AO_Schema:
+- name: c0
+ type: numeric
+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_types_numeric
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.ans
new file mode 100644
index 0000000..284a9bc
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.ans
@@ -0,0 +1,3 @@
+((1,1))
+((1,1),(2,3),(4,5))
+null
\ 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_types_path/test_ao_types_path.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.sql
new file mode 100644
index 0000000..278b8fe
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_path;
+CREATE TABLE test_ao_types_path (c0 path) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_path values ('(1,1)'),
+('(1,1),(2,3),(4,5)'),
+(null);
\ 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_types_path/test_ao_types_path.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.yaml
new file mode 100644
index 0000000..29e0a15
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_path/test_ao_types_path.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179756.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179756.1
+ size: 152
+AO_Schema:
+- name: c0
+ type: path
+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_types_path
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.ans
new file mode 100644
index 0000000..16db211
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.ans
@@ -0,0 +1,4 @@
+(1,2)
+(100,200)
+(1000,2000)
+null
\ 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_types_point/test_ao_types_point.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.sql
new file mode 100644
index 0000000..15a047c
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_point;
+CREATE TABLE test_ao_types_point (c0 point) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_point values (POINT(1,2)),
+(POINT(100,200)),
+(POINT(1000,2000)),
+(null);
\ 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_types_point/test_ao_types_point.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.yaml
new file mode 100644
index 0000000..7c89dce
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_point/test_ao_types_point.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179736.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179736.1
+ size: 112
+AO_Schema:
+- name: c0
+ type: point
+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_types_point
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.ans
new file mode 100644
index 0000000..eca3c70
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.ans
@@ -0,0 +1,3 @@
+((1,1),(3,2),(4,5))
+((100,123),(5,10),(7,2),(4,5))
+null
\ 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_types_polygon/test_ao_types_polygon.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.sql
new file mode 100644
index 0000000..d2e2bcc
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_polygon;
+CREATE TABLE test_ao_types_polygon (c0 polygon) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_polygon values ('((1,1),(3,2),(4,5))'),
+('((100,123),(5,10),(7,2),(4,5))'),
+(null);
\ 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_types_polygon/test_ao_types_polygon.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.yaml
new file mode 100644
index 0000000..a19096b
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_polygon/test_ao_types_polygon.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179761.1
+ size: 0
+ - path: test-data/hawq-data/gpseg1/16385/179545/179761.1
+ size: 248
+AO_Schema:
+- name: c0
+ type: polygon
+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_types_polygon
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.ans
new file mode 100644
index 0000000..8e5dbb9
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.ans
@@ -0,0 +1,5 @@
+
+bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
bbb
+hello world
+null
+z
\ 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_types_text/test_ao_types_text.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.sql
new file mode 100644
index 0000000..1c02f3f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS test_ao_types_text;
+CREATE TABLE test_ao_types_text (c0 text) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_text values (''),
+('z'),
+('hello world'),
+(repeat('b',1000)),
+(null);
\ 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_types_text/test_ao_types_text.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.yaml
new file mode 100644
index 0000000..61d174d
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_text/test_ao_types_text.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179701.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179701.1
+ size: 1088
+AO_Schema:
+- name: c0
+ 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_types_text
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.ans
new file mode 100644
index 0000000..334846c
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.ans
@@ -0,0 +1,4 @@
+00:00:00
+04:05:06
+23:59:59
+null
\ 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_types_time/test_ao_types_time.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.sql
new file mode 100644
index 0000000..f27f9da
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS test_ao_types_time;
+CREATE TABLE test_ao_types_time (c0 time) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_time values ('00:00:00'),
+('04:05:06'),
+('23:59:59'),
+(null);
\ 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_types_time/test_ao_types_time.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.yaml
new file mode 100644
index 0000000..1945e11
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_time/test_ao_types_time.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179711.1
+ size: 24
+ - path: test-data/hawq-data/gpseg1/16385/179545/179711.1
+ size: 80
+AO_Schema:
+- name: c0
+ type: time
+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_types_time
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.ans
new file mode 100644
index 0000000..00743ef
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.ans
@@ -0,0 +1,5 @@
+1999-01-08 04:05:06.0
+2004-10-19 10:23:54.0
+2942-12-31 00:00:00.0
+4713-01-01 00:00:00.0
+null
\ 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_types_timestamp/test_ao_types_timestamp.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.sql
new file mode 100644
index 0000000..8601e61
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS test_ao_types_timestamp;
+CREATE TABLE test_ao_types_timestamp (c0 timestamp) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_timestamp values ('4713-01-01 BC'),
+('2942-12-31 AD'),
+('1999-01-08 04:05:06'),
+('2004-10-19 10:23:54'),
+(null);
\ 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_types_timestamp/test_ao_types_timestamp.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.yaml
new file mode 100644
index 0000000..c95d756
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_timestamp/test_ao_types_timestamp.yaml
@@ -0,0 +1,21 @@
+AO_FileLocations:
+ Blocksize: 32768
+ Checksum: false
+ CompressionLevel: 0
+ CompressionType: none
+ Files:
+ - path: test-data/hawq-data/gpseg0/16385/179545/179721.1
+ size: 56
+ - path: test-data/hawq-data/gpseg1/16385/179545/179721.1
+ size: 80
+AO_Schema:
+- name: c0
+ type: timestamp
+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_types_timestamp
+Version: 1.0.0
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.ans
new file mode 100644
index 0000000..2242ef4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.ans
@@ -0,0 +1,3 @@
+000000000011100
+1111
+null
\ 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_types_varbit/test_ao_types_varbit.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.sql
new file mode 100644
index 0000000..aecc72a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_types_varbit/test_ao_types_varbit.sql
@@ -0,0 +1,5 @@
+DROP TABLE IF EXISTS test_ao_types_varbit;
+CREATE TABLE test_ao_types_varbit (c0 varbit) with (appendonly=true, orientation=row, compresstype=none, blocksize=32768, checksum=false, compresslevel=0);
+INSERT INTO test_ao_types_varbit values ('1111'),
+('000000000011100'),
+(null);
\ No newline at end of file