hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From r..@apache.org
Subject [13/51] [partial] incubator-hawq git commit: SGA import
Date Sat, 19 Sep 2015 00:35:56 GMT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.sql
b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.sql
new file mode 100644
index 0000000..88ee5b2
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.sql
@@ -0,0 +1,502 @@
+DROP TABLE IF EXISTS test_ao_zlib_4;
+CREATE TABLE test_ao_zlib_4 (c0 int4, c1 text) with (appendonly=true, orientation=row, compresstype=zlib,
blocksize=32768, checksum=false, compresslevel=4);
+INSERT INTO test_ao_zlib_4 values (32767, 'hello world'),
+(2147483647, null),
+(32767, null),
+(128, null),
+(32767, ''),
+(32767, null),
+(2147483647, ''),
+(-2147483648, null),
+(0, 'z'),
+(2147483647, 'hello world'),
+(-32768, ''),
+(-2147483648, null),
+(-32768, ''),
+(128, repeat('b',1000)),
+(null, 'z'),
+(2147483647, null),
+(-2147483648, 'hello world'),
+(0, 'hello world'),
+(-32768, 'z'),
+(-32768, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-128, ''),
+(32767, 'hello world'),
+(32767, repeat('b',1000)),
+(2147483647, ''),
+(32767, 'hello world'),
+(2147483647, 'hello world'),
+(128, repeat('b',1000)),
+(128, 'hello world'),
+(0, null),
+(-32768, 'hello world'),
+(0, ''),
+(-32768, 'z'),
+(32767, 'hello world'),
+(32767, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(2147483647, null),
+(2147483647, repeat('b',1000)),
+(-32768, 'hello world'),
+(null, repeat('b',1000)),
+(-2147483648, 'z'),
+(128, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(2147483647, 'z'),
+(-32768, repeat('b',1000)),
+(32767, ''),
+(-128, repeat('b',1000)),
+(32767, null),
+(-128, null),
+(-32768, repeat('b',1000)),
+(null, 'hello world'),
+(-32768, null),
+(32767, null),
+(0, 'z'),
+(-2147483648, ''),
+(-2147483648, null),
+(32767, 'z'),
+(2147483647, ''),
+(null, 'z'),
+(2147483647, 'hello world'),
+(null, 'z'),
+(-32768, repeat('b',1000)),
+(-32768, 'z'),
+(32767, null),
+(-128, ''),
+(-2147483648, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(128, 'hello world'),
+(0, repeat('b',1000)),
+(-128, 'hello world'),
+(null, ''),
+(-128, null),
+(null, repeat('b',1000)),
+(128, ''),
+(-32768, repeat('b',1000)),
+(-2147483648, ''),
+(0, repeat('b',1000)),
+(128, null),
+(0, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(0, ''),
+(128, ''),
+(-32768, 'hello world'),
+(32767, null),
+(-32768, 'z'),
+(2147483647, repeat('b',1000)),
+(null, 'hello world'),
+(-2147483648, 'hello world'),
+(-32768, 'hello world'),
+(2147483647, repeat('b',1000)),
+(-2147483648, 'z'),
+(32767, 'hello world'),
+(2147483647, null),
+(2147483647, repeat('b',1000)),
+(2147483647, null),
+(128, repeat('b',1000)),
+(null, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(128, null),
+(128, ''),
+(null, null),
+(-2147483648, ''),
+(32767, null),
+(0, ''),
+(-2147483648, repeat('b',1000)),
+(-2147483648, ''),
+(-32768, null),
+(32767, ''),
+(null, null),
+(-128, null),
+(null, ''),
+(0, ''),
+(128, null),
+(128, 'z'),
+(-2147483648, null),
+(-128, 'hello world'),
+(null, repeat('b',1000)),
+(2147483647, ''),
+(-128, repeat('b',1000)),
+(2147483647, 'hello world'),
+(-128, 'z'),
+(2147483647, 'hello world'),
+(0, 'z'),
+(-2147483648, repeat('b',1000)),
+(32767, 'hello world'),
+(2147483647, 'hello world'),
+(128, repeat('b',1000)),
+(32767, 'hello world'),
+(null, ''),
+(-32768, ''),
+(-32768, ''),
+(128, 'hello world'),
+(-128, 'hello world'),
+(0, repeat('b',1000)),
+(128, null),
+(32767, ''),
+(32767, ''),
+(-2147483648, 'z'),
+(128, 'hello world'),
+(-2147483648, null),
+(0, repeat('b',1000)),
+(2147483647, null),
+(-32768, repeat('b',1000)),
+(0, ''),
+(32767, null),
+(128, 'hello world'),
+(0, 'hello world'),
+(-2147483648, 'hello world'),
+(0, ''),
+(null, ''),
+(128, 'z'),
+(32767, ''),
+(2147483647, 'hello world'),
+(32767, null),
+(0, ''),
+(2147483647, 'hello world'),
+(-128, 'hello world'),
+(null, ''),
+(-2147483648, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-128, 'hello world'),
+(-128, 'z'),
+(-128, 'hello world'),
+(2147483647, 'z'),
+(-128, ''),
+(null, null),
+(-2147483648, null),
+(32767, 'z'),
+(null, 'z'),
+(128, null),
+(32767, repeat('b',1000)),
+(-2147483648, null),
+(-128, repeat('b',1000)),
+(null, ''),
+(128, ''),
+(-2147483648, 'z'),
+(128, ''),
+(-2147483648, null),
+(-32768, null),
+(-128, 'z'),
+(0, 'z'),
+(32767, null),
+(32767, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(0, null),
+(32767, 'hello world'),
+(2147483647, ''),
+(32767, null),
+(-128, repeat('b',1000)),
+(-2147483648, 'z'),
+(128, 'z'),
+(-2147483648, repeat('b',1000)),
+(32767, ''),
+(128, 'z'),
+(-128, repeat('b',1000)),
+(0, 'z'),
+(-128, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(32767, 'z'),
+(-32768, ''),
+(-2147483648, ''),
+(-32768, null),
+(2147483647, repeat('b',1000)),
+(128, ''),
+(null, ''),
+(32767, 'z'),
+(-2147483648, repeat('b',1000)),
+(-128, 'z'),
+(-2147483648, null),
+(-2147483648, 'hello world'),
+(0, 'hello world'),
+(2147483647, 'hello world'),
+(32767, 'hello world'),
+(-128, null),
+(-2147483648, 'hello world'),
+(-32768, ''),
+(128, repeat('b',1000)),
+(-128, ''),
+(null, null),
+(2147483647, 'hello world'),
+(128, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(-2147483648, 'z'),
+(null, ''),
+(128, ''),
+(-128, 'hello world'),
+(-32768, null),
+(2147483647, 'hello world'),
+(null, ''),
+(-2147483648, null),
+(-32768, ''),
+(null, 'z'),
+(32767, ''),
+(-2147483648, 'z'),
+(0, null),
+(2147483647, null),
+(0, repeat('b',1000)),
+(0, 'z'),
+(128, 'hello world'),
+(-32768, 'hello world'),
+(-128, 'z'),
+(-2147483648, ''),
+(2147483647, repeat('b',1000)),
+(-2147483648, ''),
+(null, 'z'),
+(2147483647, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(-128, 'hello world'),
+(32767, 'z'),
+(32767, ''),
+(128, ''),
+(32767, ''),
+(2147483647, 'z'),
+(0, ''),
+(0, repeat('b',1000)),
+(-128, 'hello world'),
+(128, ''),
+(32767, 'hello world'),
+(32767, null),
+(32767, null),
+(2147483647, 'hello world'),
+(-128, ''),
+(0, repeat('b',1000)),
+(32767, ''),
+(-32768, 'z'),
+(0, repeat('b',1000)),
+(0, repeat('b',1000)),
+(0, 'z'),
+(32767, 'z'),
+(null, null),
+(-128, ''),
+(null, null),
+(-32768, repeat('b',1000)),
+(null, 'hello world'),
+(-128, 'hello world'),
+(-2147483648, 'z'),
+(2147483647, 'z'),
+(-32768, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(2147483647, null),
+(128, null),
+(128, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(32767, 'hello world'),
+(128, 'z'),
+(null, 'z'),
+(2147483647, 'hello world'),
+(-128, ''),
+(0, ''),
+(-2147483648, null),
+(-128, 'z'),
+(null, repeat('b',1000)),
+(128, 'z'),
+(-32768, null),
+(-32768, 'hello world'),
+(-32768, 'hello world'),
+(-128, 'hello world'),
+(-2147483648, ''),
+(-128, null),
+(-128, 'z'),
+(-2147483648, ''),
+(-32768, 'z'),
+(-128, repeat('b',1000)),
+(2147483647, 'hello world'),
+(32767, null),
+(128, 'hello world'),
+(-32768, 'hello world'),
+(-32768, ''),
+(-128, ''),
+(128, 'z'),
+(2147483647, 'hello world'),
+(2147483647, 'z'),
+(-2147483648, ''),
+(-32768, ''),
+(32767, 'z'),
+(-2147483648, repeat('b',1000)),
+(2147483647, ''),
+(-32768, ''),
+(-128, null),
+(null, 'hello world'),
+(-2147483648, 'z'),
+(-32768, null),
+(2147483647, repeat('b',1000)),
+(-32768, null),
+(-32768, null),
+(-32768, ''),
+(-32768, repeat('b',1000)),
+(-32768, null),
+(2147483647, 'hello world'),
+(0, repeat('b',1000)),
+(null, 'z'),
+(2147483647, ''),
+(-2147483648, repeat('b',1000)),
+(-128, 'hello world'),
+(128, 'hello world'),
+(2147483647, repeat('b',1000)),
+(0, 'hello world'),
+(128, 'z'),
+(2147483647, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-128, ''),
+(0, repeat('b',1000)),
+(2147483647, ''),
+(-2147483648, null),
+(0, null),
+(null, ''),
+(2147483647, 'z'),
+(128, 'z'),
+(-128, ''),
+(2147483647, null),
+(0, null),
+(-128, 'hello world'),
+(null, 'z'),
+(null, 'hello world'),
+(null, 'z'),
+(-128, 'z'),
+(128, 'hello world'),
+(128, repeat('b',1000)),
+(-128, 'z'),
+(0, 'z'),
+(128, ''),
+(-32768, 'hello world'),
+(-2147483648, 'hello world'),
+(0, ''),
+(0, 'hello world'),
+(null, ''),
+(-128, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(128, repeat('b',1000)),
+(128, 'hello world'),
+(null, repeat('b',1000)),
+(128, 'hello world'),
+(0, null),
+(2147483647, repeat('b',1000)),
+(-128, 'hello world'),
+(-128, repeat('b',1000)),
+(null, 'hello world'),
+(-32768, null),
+(32767, 'hello world'),
+(0, 'z'),
+(32767, null),
+(2147483647, null),
+(-2147483648, repeat('b',1000)),
+(128, ''),
+(-2147483648, null),
+(null, 'z'),
+(-2147483648, 'z'),
+(128, ''),
+(-32768, 'hello world'),
+(null, repeat('b',1000)),
+(2147483647, 'hello world'),
+(-32768, null),
+(null, ''),
+(-128, 'hello world'),
+(-128, null),
+(128, ''),
+(0, 'z'),
+(32767, repeat('b',1000)),
+(32767, ''),
+(32767, null),
+(0, null),
+(-2147483648, 'hello world'),
+(2147483647, ''),
+(2147483647, 'hello world'),
+(0, repeat('b',1000)),
+(-2147483648, null),
+(2147483647, ''),
+(-2147483648, null),
+(null, 'z'),
+(32767, 'z'),
+(null, repeat('b',1000)),
+(0, 'z'),
+(-32768, null),
+(-128, ''),
+(32767, 'z'),
+(128, repeat('b',1000)),
+(-128, 'z'),
+(2147483647, null),
+(2147483647, 'hello world'),
+(-32768, ''),
+(-128, 'hello world'),
+(-32768, 'z'),
+(-2147483648, 'hello world'),
+(0, ''),
+(32767, 'hello world'),
+(-128, 'z'),
+(0, null),
+(32767, null),
+(2147483647, null),
+(-2147483648, null),
+(2147483647, ''),
+(null, 'z'),
+(-32768, 'z'),
+(-2147483648, 'hello world'),
+(128, ''),
+(2147483647, repeat('b',1000)),
+(128, repeat('b',1000)),
+(32767, 'z'),
+(null, null),
+(0, null),
+(0, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(128, 'hello world'),
+(-128, ''),
+(32767, null),
+(128, 'z'),
+(128, 'z'),
+(128, ''),
+(32767, null),
+(128, ''),
+(-32768, 'z'),
+(2147483647, 'hello world'),
+(32767, 'z'),
+(0, repeat('b',1000)),
+(-32768, 'hello world'),
+(-2147483648, 'hello world'),
+(2147483647, 'hello world'),
+(-32768, null),
+(128, repeat('b',1000)),
+(-128, null),
+(128, 'hello world'),
+(-2147483648, 'z'),
+(-32768, null),
+(-2147483648, 'z'),
+(128, null),
+(0, 'z'),
+(-128, 'hello world'),
+(-32768, repeat('b',1000)),
+(-32768, null),
+(-32768, 'hello world'),
+(32767, 'hello world'),
+(128, 'hello world'),
+(-2147483648, 'z'),
+(32767, 'z'),
+(32767, 'hello world'),
+(0, 'z'),
+(32767, null),
+(2147483647, null),
+(-128, 'hello world'),
+(null, null),
+(0, 'hello world'),
+(-2147483648, 'z'),
+(32767, null),
+(-2147483648, repeat('b',1000)),
+(32767, ''),
+(2147483647, ''),
+(0, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(128, null),
+(32767, ''),
+(2147483647, repeat('b',1000)),
+(128, ''),
+(null, repeat('b',1000)),
+(0, ''),
+(-2147483648, repeat('b',1000)),
+(-128, 'hello world'),
+(0, '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_zlib_4/test_ao_zlib_4.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.yaml
b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.yaml
new file mode 100644
index 0000000..bcf9979
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_4/test_ao_zlib_4.yaml
@@ -0,0 +1,23 @@
+AO_FileLocations:
+  Blocksize: 32768
+  Checksum: false
+  CompressionLevel: 4
+  CompressionType: zlib
+  Files:
+  - path: test-data/hawq-data/gpseg0/16385/179545/179566.1
+    size: 720
+  - path: test-data/hawq-data/gpseg1/16385/179545/179566.1
+    size: 2944
+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_4
+Version: 1.0.0


Mime
View raw message