You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by pw...@apache.org on 2014/03/21 23:08:47 UTC
[45/51] [partial] Add hive test files to repository. Remove download
script.
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/types/primitives/090401.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/types/primitives/090401.txt b/sql/hive/src/test/resources/data/files/types/primitives/090401.txt
new file mode 100644
index 0000000..a3a0d69
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/types/primitives/090401.txt
@@ -0,0 +1,25 @@
+75,false,0,\N,0,0,0.0,0.0,04/01/09,0,2009-04-01 00:00:00.0
+76,true,1,1,\N,10,1.1,10.1,04/01/09,1,2009-04-01 00:01:00.0
+77,false,2,2,2,\N,2.2,20.2,04/01/09,2,2009-04-01 00:02:00.10
+78,true,3,3,3,30,\N,30.299999999999997,04/01/09,3,2009-04-01 00:03:00.30
+79,false,4,4,4,40,4.4,\N,04/01/09,4,2009-04-01 00:04:00.60
+80,true,5,5,5,50,5.5,50.5,\N,5,2009-04-01 00:05:00.100
+81,false,6,6,6,60,6.6,60.599999999999994,04/01/09,\N,2009-04-01 00:06:00.150
+82,true,7,7,7,70,7.7,70.7,04/01/09,7,\N
+83,\N,8,8,8,80,8.8,80.8,04/01/09,8,2009-04-01 00:08:00.280
+84,true,\N,9,9,90,9.9,90.89999999999999,04/01/09,9,2009-04-01 00:09:00.360
+85,false,0,\N,0,0,0.0,0.0,04/02/09,0,2009-04-02 00:10:00.450
+86,true,1,1,\N,10,1.1,10.1,04/02/09,1,2009-04-02 00:11:00.450
+87,false,2,2,2,\N,2.2,20.2,04/02/09,2,2009-04-02 00:12:00.460
+88,true,3,3,3,30,\N,30.299999999999997,04/02/09,3,2009-04-02 00:13:00.480
+89,false,4,4,4,40,4.4,\N,04/02/09,4,2009-04-02 00:14:00.510
+90,true,5,5,5,50,5.5,50.5,\N,5,2009-04-02 00:15:00.550
+91,false,6,6,6,60,6.6,60.599999999999994,04/02/09,\N,2009-04-02 00:16:00.600
+92,true,7,7,7,70,7.7,70.7,04/02/09,7,\N
+93,\N,8,8,8,80,8.8,80.8,04/02/09,8,2009-04-02 00:18:00.730
+94,true,\N,9,9,90,9.9,90.89999999999999,04/02/09,9,2009-04-02 00:19:00.810
+95,false,0,\N,0,0,0.0,0.0,04/03/09,0,2009-04-03 00:20:00.900
+96,true,1,1,\N,10,1.1,10.1,04/03/09,1,2009-04-03 00:21:00.900
+97,false,2,2,2,\N,2.2,20.2,04/03/09,2,2009-04-03 00:22:00.910
+98,true,3,3,3,30,\N,30.299999999999997,04/03/09,3,2009-04-03 00:23:00.930
+99,false,4,4,4,40,4.4,\N,04/03/09,4,2009-04-03 00:24:00.960
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/union_input.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/union_input.txt b/sql/hive/src/test/resources/data/files/union_input.txt
new file mode 100644
index 0000000..e3020be
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/union_input.txt
@@ -0,0 +1,8 @@
+011oneone
+12.02twotwo
+2threefour3threefour
+35five5fivefive
+2sixseven6sixseven
+38eight8eighteight
+099ninenine
+110.010tenten
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/v1.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/v1.txt b/sql/hive/src/test/resources/data/files/v1.txt
new file mode 100644
index 0000000..1ce8833
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/v1.txt
@@ -0,0 +1,4 @@
+1111fooabc2013-10-10 12:12:12xyzfunbar2013-10-10 12:12:12lmn2013-11-11 12:12:1292222
+2222fooabc2013-10-10 12:12:12xyzfunbar2013-10-10 12:12:12lmn2013-11-11 12:12:1294444
+3333fooabc2013-10-10 12:12:12xyzfunbar2013-10-10 12:12:12lmn2013-11-11 12:12:1296666
+4444fooabc2013-10-10 12:12:12xyzfunbar2013-10-10 12:12:12lmn2013-11-11 12:12:1298888
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/v2.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/v2.txt b/sql/hive/src/test/resources/data/files/v2.txt
new file mode 100644
index 0000000..5e4c94c
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/v2.txt
@@ -0,0 +1,9 @@
+111199999
+222299999
+222299999
+444499999
+555599999
+666699999
+666699999
+666699999
+888899999
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/vc1.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/vc1.txt b/sql/hive/src/test/resources/data/files/vc1.txt
new file mode 100644
index 0000000..d0f9952
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/vc1.txt
@@ -0,0 +1,3 @@
+1abc
+2abc
+3 abc
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/x.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/x.txt b/sql/hive/src/test/resources/data/files/x.txt
new file mode 100644
index 0000000..6407b72
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/x.txt
@@ -0,0 +1,2 @@
+Joe 2
+Hank 2
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/y.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/y.txt b/sql/hive/src/test/resources/data/files/y.txt
new file mode 100644
index 0000000..7eedbcf
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/y.txt
@@ -0,0 +1 @@
+2 Tie
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/z.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/z.txt b/sql/hive/src/test/resources/data/files/z.txt
new file mode 100644
index 0000000..7eedbcf
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/z.txt
@@ -0,0 +1 @@
+2 Tie
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/metadb/.gitignore
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/metadb/.gitignore b/sql/hive/src/test/resources/data/metadb/.gitignore
new file mode 100644
index 0000000..0dd9890
--- /dev/null
+++ b/sql/hive/src/test/resources/data/metadb/.gitignore
@@ -0,0 +1 @@
+# Dummy file to make Git recognize this empty directory
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/cat.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/cat.py b/sql/hive/src/test/resources/data/scripts/cat.py
new file mode 100644
index 0000000..2395b2c
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/cat.py
@@ -0,0 +1,29 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys, re
+import datetime
+import os
+
+table_name=None
+if os.environ.has_key('hive_streaming_tablename'):
+ table_name=os.environ['hive_streaming_tablename']
+
+for line in sys.stdin:
+ print line
+ print >> sys.stderr, "dummy"
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/cat_error.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/cat_error.py b/sql/hive/src/test/resources/data/scripts/cat_error.py
new file mode 100644
index 0000000..9642efe
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/cat_error.py
@@ -0,0 +1,24 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print line
+
+sys.exit(1)
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/doubleescapedtab.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/doubleescapedtab.py b/sql/hive/src/test/resources/data/scripts/doubleescapedtab.py
new file mode 100644
index 0000000..d373067
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/doubleescapedtab.py
@@ -0,0 +1,24 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print "1\\\\\\t2"
+ print "1\\\\\\\\t2"
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/dumpdata_script.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/dumpdata_script.py b/sql/hive/src/test/resources/data/scripts/dumpdata_script.py
new file mode 100644
index 0000000..c96c9e5
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/dumpdata_script.py
@@ -0,0 +1,27 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for i in xrange(50):
+ for j in xrange(5):
+ for k in xrange(20022):
+ print 20000 * i + k
+
+for line in sys.stdin:
+ pass
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/error_script
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/error_script b/sql/hive/src/test/resources/data/scripts/error_script
new file mode 100755
index 0000000..8d86b62
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/error_script
@@ -0,0 +1,26 @@
+#! /bin/bash
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+exit 1
+ret=0
+while [ "$ret" = "0" ];
+do
+ read -t 1 -a v
+ ret=$?
+done
+
+exit 1
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/escapedcarriagereturn.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/escapedcarriagereturn.py b/sql/hive/src/test/resources/data/scripts/escapedcarriagereturn.py
new file mode 100644
index 0000000..475928a
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/escapedcarriagereturn.py
@@ -0,0 +1,23 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print "1\\\\r2"
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/escapednewline.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/escapednewline.py b/sql/hive/src/test/resources/data/scripts/escapednewline.py
new file mode 100644
index 0000000..0d57514
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/escapednewline.py
@@ -0,0 +1,23 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print "1\\\\n2"
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/escapedtab.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/escapedtab.py b/sql/hive/src/test/resources/data/scripts/escapedtab.py
new file mode 100644
index 0000000..549c91e
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/escapedtab.py
@@ -0,0 +1,23 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print "1\\\\t2"
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/input20_script
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/input20_script b/sql/hive/src/test/resources/data/scripts/input20_script
new file mode 100755
index 0000000..e8e4118
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/input20_script
@@ -0,0 +1,20 @@
+#! /bin/bash
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+# This script outputs a row of the following format
+# <# of values for the key> <key>_<key>
+uniq -c | sed "s@^ *@@" | sed "s@ @_@" | sed "s@ @ @"
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/newline.py
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/newline.py b/sql/hive/src/test/resources/data/scripts/newline.py
new file mode 100644
index 0000000..6500d90
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/newline.py
@@ -0,0 +1,24 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+import sys
+
+for line in sys.stdin:
+ print "1\\n2"
+ print "1\\r2"
+ print "1\\t2"
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/q_test_cleanup.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/q_test_cleanup.sql b/sql/hive/src/test/resources/data/scripts/q_test_cleanup.sql
new file mode 100644
index 0000000..31bd720
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/q_test_cleanup.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS src;
+DROP TABLE IF EXISTS src1;
+DROP TABLE IF EXISTS src_json;
+DROP TABLE IF EXISTS src_sequencefile;
+DROP TABLE IF EXISTS src_thrift;
+DROP TABLE IF EXISTS srcbucket;
+DROP TABLE IF EXISTS srcbucket2;
+DROP TABLE IF EXISTS srcpart;
+DROP TABLE IF EXISTS primitives;
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/q_test_init.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/q_test_init.sql b/sql/hive/src/test/resources/data/scripts/q_test_init.sql
new file mode 100644
index 0000000..12afdf3
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/q_test_init.sql
@@ -0,0 +1,132 @@
+--
+-- Table src
+--
+DROP TABLE IF EXISTS src;
+
+CREATE TABLE src (key STRING, value STRING) STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt" INTO TABLE src;
+
+--
+-- Table src1
+--
+DROP TABLE IF EXISTS src1;
+
+CREATE TABLE src1 (key STRING, value STRING) STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv3.txt" INTO TABLE src1;
+
+--
+-- Table src_json
+--
+DROP TABLE IF EXISTS src_json;
+
+CREATE TABLE src_json (json STRING) STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/json.txt" INTO TABLE src_json;
+
+
+--
+-- Table src_sequencefile
+--
+DROP TABLE IF EXISTS src_sequencefile;
+
+CREATE TABLE src_sequencefile (key STRING, value STRING) STORED AS SEQUENCEFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.seq" INTO TABLE src_sequencefile;
+
+
+--
+-- Table src_thrift
+--
+DROP TABLE IF EXISTS src_thrift;
+
+CREATE TABLE src_thrift
+ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer'
+WITH SERDEPROPERTIES (
+ 'serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex',
+ 'serialization.format' = 'com.facebook.thrift.protocol.TBinaryProtocol')
+STORED AS SEQUENCEFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/complex.seq" INTO TABLE src_thrift;
+
+
+--
+-- Table srcbucket
+--
+DROP TABLE IF EXISTS srcbucket;
+
+CREATE TABLE srcbucket (key INT, value STRING)
+CLUSTERED BY (key) INTO 2 BUCKETS
+STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/srcbucket0.txt" INTO TABLE srcbucket;
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/srcbucket1.txt" INTO TABLE srcbucket;
+
+
+--
+-- Table srcbucket2
+--
+DROP TABLE IF EXISTS srcbucket2;
+
+CREATE TABLE srcbucket2 (key INT, value STRING)
+CLUSTERED BY (key) INTO 4 BUCKETS
+STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/srcbucket20.txt" INTO TABLE srcbucket2;
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/srcbucket21.txt" INTO TABLE srcbucket2;
+
+
+--
+-- Table srcpart
+--
+DROP TABLE IF EXISTS srcpart;
+
+CREATE TABLE srcpart (key STRING, value STRING)
+PARTITIONED BY (ds STRING, hr STRING)
+STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
+OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="11");
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
+OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-08", hr="12");
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
+OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="11");
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/kv1.txt"
+OVERWRITE INTO TABLE srcpart PARTITION (ds="2008-04-09", hr="12");
+
+
+DROP TABLE IF EXISTS primitives;
+CREATE TABLE primitives (
+ id INT,
+ bool_col BOOLEAN,
+ tinyint_col TINYINT,
+ smallint_col SMALLINT,
+ int_col INT,
+ bigint_col BIGINT,
+ float_col FLOAT,
+ double_col DOUBLE,
+ date_string_col STRING,
+ string_col STRING,
+ timestamp_col TIMESTAMP)
+PARTITIONED BY (year INT, month INT)
+ROW FORMAT DELIMITED
+ FIELDS TERMINATED BY ','
+ ESCAPED BY '\\'
+STORED AS TEXTFILE;
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/types/primitives/090101.txt"
+OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=1);
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/types/primitives/090201.txt"
+OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=2);
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/types/primitives/090301.txt"
+OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=3);
+
+LOAD DATA LOCAL INPATH "${hiveconf:test.data.dir}/types/primitives/090401.txt"
+OVERWRITE INTO TABLE primitives PARTITION(year=2009, month=4);
+
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/scripts/test_init_file.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/scripts/test_init_file.sql b/sql/hive/src/test/resources/data/scripts/test_init_file.sql
new file mode 100644
index 0000000..776a46b
--- /dev/null
+++ b/sql/hive/src/test/resources/data/scripts/test_init_file.sql
@@ -0,0 +1 @@
+create table tbl_created_by_init(i int);
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + '1'-0-77504a9f3d712143beb52f3c25a904cb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + '1'-0-77504a9f3d712143beb52f3c25a904cb b/sql/hive/src/test/resources/golden/'1' + '1'-0-77504a9f3d712143beb52f3c25a904cb
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + '1'-0-77504a9f3d712143beb52f3c25a904cb
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + 1-0-130514c6116c311d808590a075b187b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + 1-0-130514c6116c311d808590a075b187b b/sql/hive/src/test/resources/golden/'1' + 1-0-130514c6116c311d808590a075b187b
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + 1-0-130514c6116c311d808590a075b187b
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + 1.0-0-5db3b55120a19863d96460d399c2d0e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + 1.0-0-5db3b55120a19863d96460d399c2d0e b/sql/hive/src/test/resources/golden/'1' + 1.0-0-5db3b55120a19863d96460d399c2d0e
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + 1.0-0-5db3b55120a19863d96460d399c2d0e
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + 1L-0-657763a2cfaa4fe3f73c5b68bc84a548
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + 1L-0-657763a2cfaa4fe3f73c5b68bc84a548 b/sql/hive/src/test/resources/golden/'1' + 1L-0-657763a2cfaa4fe3f73c5b68bc84a548
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + 1L-0-657763a2cfaa4fe3f73c5b68bc84a548
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + 1S-0-c3a1c44bebcde38c4d43bd73e3849630
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + 1S-0-c3a1c44bebcde38c4d43bd73e3849630 b/sql/hive/src/test/resources/golden/'1' + 1S-0-c3a1c44bebcde38c4d43bd73e3849630
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + 1S-0-c3a1c44bebcde38c4d43bd73e3849630
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/'1' + 1Y-0-aa608227a4f07c5cb98fcafe1e20488a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/'1' + 1Y-0-aa608227a4f07c5cb98fcafe1e20488a b/sql/hive/src/test/resources/golden/'1' + 1Y-0-aa608227a4f07c5cb98fcafe1e20488a
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/'1' + 1Y-0-aa608227a4f07c5cb98fcafe1e20488a
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + '1'-0-4d39227e4121e2dc9a25f21fa27f89a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + '1'-0-4d39227e4121e2dc9a25f21fa27f89a b/sql/hive/src/test/resources/golden/1 + '1'-0-4d39227e4121e2dc9a25f21fa27f89a
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + '1'-0-4d39227e4121e2dc9a25f21fa27f89a
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + 1-0-83de1c24fd6dee00409e8fdd99306ed6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + 1-0-83de1c24fd6dee00409e8fdd99306ed6 b/sql/hive/src/test/resources/golden/1 + 1-0-83de1c24fd6dee00409e8fdd99306ed6
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + 1-0-83de1c24fd6dee00409e8fdd99306ed6
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + 1.0-0-4f5da98a11db8e7192423c27db767ca6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + 1.0-0-4f5da98a11db8e7192423c27db767ca6 b/sql/hive/src/test/resources/golden/1 + 1.0-0-4f5da98a11db8e7192423c27db767ca6
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + 1.0-0-4f5da98a11db8e7192423c27db767ca6
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + 1L-0-917a033ac7f8f8b3a2e8e961dc91f35e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + 1L-0-917a033ac7f8f8b3a2e8e961dc91f35e b/sql/hive/src/test/resources/golden/1 + 1L-0-917a033ac7f8f8b3a2e8e961dc91f35e
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + 1L-0-917a033ac7f8f8b3a2e8e961dc91f35e
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + 1S-0-2e99da48f67f588c9e632a57c713522e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + 1S-0-2e99da48f67f588c9e632a57c713522e b/sql/hive/src/test/resources/golden/1 + 1S-0-2e99da48f67f588c9e632a57c713522e
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + 1S-0-2e99da48f67f588c9e632a57c713522e
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1 + 1Y-0-1ff4db1fdac05de5b092095c2402fc5f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1 + 1Y-0-1ff4db1fdac05de5b092095c2402fc5f b/sql/hive/src/test/resources/golden/1 + 1Y-0-1ff4db1fdac05de5b092095c2402fc5f
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1 + 1Y-0-1ff4db1fdac05de5b092095c2402fc5f
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + '1'-0-a6ec78b3b93d52034aab829d43210e73
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + '1'-0-a6ec78b3b93d52034aab829d43210e73 b/sql/hive/src/test/resources/golden/1.0 + '1'-0-a6ec78b3b93d52034aab829d43210e73
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + '1'-0-a6ec78b3b93d52034aab829d43210e73
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + 1-0-30a4b1c8227906931cd0532367bebc43
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + 1-0-30a4b1c8227906931cd0532367bebc43 b/sql/hive/src/test/resources/golden/1.0 + 1-0-30a4b1c8227906931cd0532367bebc43
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + 1-0-30a4b1c8227906931cd0532367bebc43
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + 1.0-0-87321b2e30ee2986b00b631d0e4f4d8d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + 1.0-0-87321b2e30ee2986b00b631d0e4f4d8d b/sql/hive/src/test/resources/golden/1.0 + 1.0-0-87321b2e30ee2986b00b631d0e4f4d8d
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + 1.0-0-87321b2e30ee2986b00b631d0e4f4d8d
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + 1L-0-44bb88a1c9280952e8119a3ab1bb4205
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + 1L-0-44bb88a1c9280952e8119a3ab1bb4205 b/sql/hive/src/test/resources/golden/1.0 + 1L-0-44bb88a1c9280952e8119a3ab1bb4205
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + 1L-0-44bb88a1c9280952e8119a3ab1bb4205
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + 1S-0-31fbe14d01fb532176c1689680398368
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + 1S-0-31fbe14d01fb532176c1689680398368 b/sql/hive/src/test/resources/golden/1.0 + 1S-0-31fbe14d01fb532176c1689680398368
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + 1S-0-31fbe14d01fb532176c1689680398368
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1.0 + 1Y-0-12bcf6e49e83abd2aa36ea612b418d43
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1.0 + 1Y-0-12bcf6e49e83abd2aa36ea612b418d43 b/sql/hive/src/test/resources/golden/1.0 + 1Y-0-12bcf6e49e83abd2aa36ea612b418d43
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1.0 + 1Y-0-12bcf6e49e83abd2aa36ea612b418d43
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + '1'-0-6e39c7be301f3846efa9b4c939815b4a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + '1'-0-6e39c7be301f3846efa9b4c939815b4a b/sql/hive/src/test/resources/golden/1L + '1'-0-6e39c7be301f3846efa9b4c939815b4a
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + '1'-0-6e39c7be301f3846efa9b4c939815b4a
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + 1-0-1864a260554255a09e4f28b8551eef9d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + 1-0-1864a260554255a09e4f28b8551eef9d b/sql/hive/src/test/resources/golden/1L + 1-0-1864a260554255a09e4f28b8551eef9d
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + 1-0-1864a260554255a09e4f28b8551eef9d
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + 1.0-0-95a30c4b746f520f1251981a66cef5c8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + 1.0-0-95a30c4b746f520f1251981a66cef5c8 b/sql/hive/src/test/resources/golden/1L + 1.0-0-95a30c4b746f520f1251981a66cef5c8
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + 1.0-0-95a30c4b746f520f1251981a66cef5c8
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + 1L-0-e54a673c779f31597acdc5bd7d315d9f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + 1L-0-e54a673c779f31597acdc5bd7d315d9f b/sql/hive/src/test/resources/golden/1L + 1L-0-e54a673c779f31597acdc5bd7d315d9f
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + 1L-0-e54a673c779f31597acdc5bd7d315d9f
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + 1S-0-b8e70f71c32aac77e2683ba20ab99688
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + 1S-0-b8e70f71c32aac77e2683ba20ab99688 b/sql/hive/src/test/resources/golden/1L + 1S-0-b8e70f71c32aac77e2683ba20ab99688
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + 1S-0-b8e70f71c32aac77e2683ba20ab99688
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1L + 1Y-0-55de31e21660fa7d213b1f68d636cbf9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1L + 1Y-0-55de31e21660fa7d213b1f68d636cbf9 b/sql/hive/src/test/resources/golden/1L + 1Y-0-55de31e21660fa7d213b1f68d636cbf9
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1L + 1Y-0-55de31e21660fa7d213b1f68d636cbf9
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + '1'-0-c3cf30b2c4bffc76100e7b43e7b2aec5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + '1'-0-c3cf30b2c4bffc76100e7b43e7b2aec5 b/sql/hive/src/test/resources/golden/1S + '1'-0-c3cf30b2c4bffc76100e7b43e7b2aec5
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + '1'-0-c3cf30b2c4bffc76100e7b43e7b2aec5
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + 1-0-c378b0b2a57c54b3815e8a64686756d3
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + 1-0-c378b0b2a57c54b3815e8a64686756d3 b/sql/hive/src/test/resources/golden/1S + 1-0-c378b0b2a57c54b3815e8a64686756d3
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + 1-0-c378b0b2a57c54b3815e8a64686756d3
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + 1.0-0-8dfa46ec33c1be5ffba2e40cbfe5349e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + 1.0-0-8dfa46ec33c1be5ffba2e40cbfe5349e b/sql/hive/src/test/resources/golden/1S + 1.0-0-8dfa46ec33c1be5ffba2e40cbfe5349e
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + 1.0-0-8dfa46ec33c1be5ffba2e40cbfe5349e
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + 1L-0-9d3ff8b5d4883a4a5a1dc0dd4f0c1116
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + 1L-0-9d3ff8b5d4883a4a5a1dc0dd4f0c1116 b/sql/hive/src/test/resources/golden/1S + 1L-0-9d3ff8b5d4883a4a5a1dc0dd4f0c1116
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + 1L-0-9d3ff8b5d4883a4a5a1dc0dd4f0c1116
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + 1S-0-5054df6e72be611d6ee2a4e135bd949e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + 1S-0-5054df6e72be611d6ee2a4e135bd949e b/sql/hive/src/test/resources/golden/1S + 1S-0-5054df6e72be611d6ee2a4e135bd949e
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + 1S-0-5054df6e72be611d6ee2a4e135bd949e
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1S + 1Y-0-e59bc8279cd364224476ffc504c7685b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1S + 1Y-0-e59bc8279cd364224476ffc504c7685b b/sql/hive/src/test/resources/golden/1S + 1Y-0-e59bc8279cd364224476ffc504c7685b
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1S + 1Y-0-e59bc8279cd364224476ffc504c7685b
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + '1'-0-bdc0f1c52b94a852b595e54997eb9dfb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + '1'-0-bdc0f1c52b94a852b595e54997eb9dfb b/sql/hive/src/test/resources/golden/1Y + '1'-0-bdc0f1c52b94a852b595e54997eb9dfb
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + '1'-0-bdc0f1c52b94a852b595e54997eb9dfb
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + 1-0-a4541db51882b19503649138fbb295f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + 1-0-a4541db51882b19503649138fbb295f b/sql/hive/src/test/resources/golden/1Y + 1-0-a4541db51882b19503649138fbb295f
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + 1-0-a4541db51882b19503649138fbb295f
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + 1.0-0-3ad5e3db0d0300312d33231e7c2a6c8d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + 1.0-0-3ad5e3db0d0300312d33231e7c2a6c8d b/sql/hive/src/test/resources/golden/1Y + 1.0-0-3ad5e3db0d0300312d33231e7c2a6c8d
new file mode 100644
index 0000000..415b19f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + 1.0-0-3ad5e3db0d0300312d33231e7c2a6c8d
@@ -0,0 +1 @@
+2.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + 1L-0-2aa9a7b23c741d78032def0641a21cb1
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + 1L-0-2aa9a7b23c741d78032def0641a21cb1 b/sql/hive/src/test/resources/golden/1Y + 1L-0-2aa9a7b23c741d78032def0641a21cb1
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + 1L-0-2aa9a7b23c741d78032def0641a21cb1
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + 1S-0-93a44c4952c4d343d3885edfc95b4b80
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + 1S-0-93a44c4952c4d343d3885edfc95b4b80 b/sql/hive/src/test/resources/golden/1Y + 1S-0-93a44c4952c4d343d3885edfc95b4b80
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + 1S-0-93a44c4952c4d343d3885edfc95b4b80
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/1Y + 1Y-0-3d9619d963e7f1cb4ab3e8b5e24ff0d5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/1Y + 1Y-0-3d9619d963e7f1cb4ab3e8b5e24ff0d5 b/sql/hive/src/test/resources/golden/1Y + 1Y-0-3d9619d963e7f1cb4ab3e8b5e24ff0d5
new file mode 100644
index 0000000..d8263ee
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/1Y + 1Y-0-3d9619d963e7f1cb4ab3e8b5e24ff0d5
@@ -0,0 +1 @@
+2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be b/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be
new file mode 100644
index 0000000..913a609
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be
@@ -0,0 +1,3 @@
+86
+27
+98
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 b/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35
new file mode 100644
index 0000000..9a276bc
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35
@@ -0,0 +1,3 @@
+476
+172
+622
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa b/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa
new file mode 100644
index 0000000..1c8e285
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa
@@ -0,0 +1,3 @@
+238
+86
+311
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 b/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494
new file mode 100644
index 0000000..913a609
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494
@@ -0,0 +1,3 @@
+86
+27
+98
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 b/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477
new file mode 100644
index 0000000..1c8e285
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477
@@ -0,0 +1,3 @@
+238
+86
+311
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee b/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee
new file mode 100644
index 0000000..1c8e285
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee
@@ -0,0 +1,3 @@
+238
+86
+311
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 b/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91
new file mode 100644
index 0000000..1c8e285
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91
@@ -0,0 +1,3 @@
+238
+86
+311
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 b/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049
new file mode 100644
index 0000000..1c8e285
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049
@@ -0,0 +1,3 @@
+238
+86
+311
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/DISTINCT-0-3af674dcb5dd91ad17722d2022a8d59a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/DISTINCT-0-3af674dcb5dd91ad17722d2022a8d59a b/sql/hive/src/test/resources/golden/DISTINCT-0-3af674dcb5dd91ad17722d2022a8d59a
new file mode 100644
index 0000000..5710fb2
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/DISTINCT-0-3af674dcb5dd91ad17722d2022a8d59a
@@ -0,0 +1,309 @@
+0 val_0
+2 val_2
+4 val_4
+5 val_5
+8 val_8
+9 val_9
+10 val_10
+11 val_11
+12 val_12
+15 val_15
+17 val_17
+18 val_18
+19 val_19
+20 val_20
+24 val_24
+26 val_26
+27 val_27
+28 val_28
+30 val_30
+33 val_33
+34 val_34
+35 val_35
+37 val_37
+41 val_41
+42 val_42
+43 val_43
+44 val_44
+47 val_47
+51 val_51
+53 val_53
+54 val_54
+57 val_57
+58 val_58
+64 val_64
+65 val_65
+66 val_66
+67 val_67
+69 val_69
+70 val_70
+72 val_72
+74 val_74
+76 val_76
+77 val_77
+78 val_78
+80 val_80
+82 val_82
+83 val_83
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+90 val_90
+92 val_92
+95 val_95
+96 val_96
+97 val_97
+98 val_98
+100 val_100
+103 val_103
+104 val_104
+105 val_105
+111 val_111
+113 val_113
+114 val_114
+116 val_116
+118 val_118
+119 val_119
+120 val_120
+125 val_125
+126 val_126
+128 val_128
+129 val_129
+131 val_131
+133 val_133
+134 val_134
+136 val_136
+137 val_137
+138 val_138
+143 val_143
+145 val_145
+146 val_146
+149 val_149
+150 val_150
+152 val_152
+153 val_153
+155 val_155
+156 val_156
+157 val_157
+158 val_158
+160 val_160
+162 val_162
+163 val_163
+164 val_164
+165 val_165
+166 val_166
+167 val_167
+168 val_168
+169 val_169
+170 val_170
+172 val_172
+174 val_174
+175 val_175
+176 val_176
+177 val_177
+178 val_178
+179 val_179
+180 val_180
+181 val_181
+183 val_183
+186 val_186
+187 val_187
+189 val_189
+190 val_190
+191 val_191
+192 val_192
+193 val_193
+194 val_194
+195 val_195
+196 val_196
+197 val_197
+199 val_199
+200 val_200
+201 val_201
+202 val_202
+203 val_203
+205 val_205
+207 val_207
+208 val_208
+209 val_209
+213 val_213
+214 val_214
+216 val_216
+217 val_217
+218 val_218
+219 val_219
+221 val_221
+222 val_222
+223 val_223
+224 val_224
+226 val_226
+228 val_228
+229 val_229
+230 val_230
+233 val_233
+235 val_235
+237 val_237
+238 val_238
+239 val_239
+241 val_241
+242 val_242
+244 val_244
+247 val_247
+248 val_248
+249 val_249
+252 val_252
+255 val_255
+256 val_256
+257 val_257
+258 val_258
+260 val_260
+262 val_262
+263 val_263
+265 val_265
+266 val_266
+272 val_272
+273 val_273
+274 val_274
+275 val_275
+277 val_277
+278 val_278
+280 val_280
+281 val_281
+282 val_282
+283 val_283
+284 val_284
+285 val_285
+286 val_286
+287 val_287
+288 val_288
+289 val_289
+291 val_291
+292 val_292
+296 val_296
+298 val_298
+302 val_302
+305 val_305
+306 val_306
+307 val_307
+308 val_308
+309 val_309
+310 val_310
+311 val_311
+315 val_315
+316 val_316
+317 val_317
+318 val_318
+321 val_321
+322 val_322
+323 val_323
+325 val_325
+327 val_327
+331 val_331
+332 val_332
+333 val_333
+335 val_335
+336 val_336
+338 val_338
+339 val_339
+341 val_341
+342 val_342
+344 val_344
+345 val_345
+348 val_348
+351 val_351
+353 val_353
+356 val_356
+360 val_360
+362 val_362
+364 val_364
+365 val_365
+366 val_366
+367 val_367
+368 val_368
+369 val_369
+373 val_373
+374 val_374
+375 val_375
+377 val_377
+378 val_378
+379 val_379
+382 val_382
+384 val_384
+386 val_386
+389 val_389
+392 val_392
+393 val_393
+394 val_394
+395 val_395
+396 val_396
+397 val_397
+399 val_399
+400 val_400
+401 val_401
+402 val_402
+403 val_403
+404 val_404
+406 val_406
+407 val_407
+409 val_409
+411 val_411
+413 val_413
+414 val_414
+417 val_417
+418 val_418
+419 val_419
+421 val_421
+424 val_424
+427 val_427
+429 val_429
+430 val_430
+431 val_431
+432 val_432
+435 val_435
+436 val_436
+437 val_437
+438 val_438
+439 val_439
+443 val_443
+444 val_444
+446 val_446
+448 val_448
+449 val_449
+452 val_452
+453 val_453
+454 val_454
+455 val_455
+457 val_457
+458 val_458
+459 val_459
+460 val_460
+462 val_462
+463 val_463
+466 val_466
+467 val_467
+468 val_468
+469 val_469
+470 val_470
+472 val_472
+475 val_475
+477 val_477
+478 val_478
+479 val_479
+480 val_480
+481 val_481
+482 val_482
+483 val_483
+484 val_484
+485 val_485
+487 val_487
+489 val_489
+490 val_490
+491 val_491
+492 val_492
+493 val_493
+494 val_494
+495 val_495
+496 val_496
+497 val_497
+498 val_498
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Escape sequences-0-2f25c33d97c43f3276171624d988a286
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Escape sequences-0-2f25c33d97c43f3276171624d988a286 b/sql/hive/src/test/resources/golden/Escape sequences-0-2f25c33d97c43f3276171624d988a286
new file mode 100644
index 0000000..bbe37f8
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Escape sequences-0-2f25c33d97c43f3276171624d988a286
@@ -0,0 +1 @@
+86 \ \
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/IgnoreExplain-0-85d398864d4aa1d0e10ffd668fdf1a59
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/IgnoreExplain-0-85d398864d4aa1d0e10ffd668fdf1a59 b/sql/hive/src/test/resources/golden/IgnoreExplain-0-85d398864d4aa1d0e10ffd668fdf1a59
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/LIKE-0-8a6078c9da5f15ea95ba3682fd66e672
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/LIKE-0-8a6078c9da5f15ea95ba3682fd66e672 b/sql/hive/src/test/resources/golden/LIKE-0-8a6078c9da5f15ea95ba3682fd66e672
new file mode 100644
index 0000000..8007988
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/LIKE-0-8a6078c9da5f15ea95ba3682fd66e672
@@ -0,0 +1,175 @@
+311 val_311
+165 val_165
+193 val_193
+401 val_401
+150 val_150
+128 val_128
+213 val_213
+146 val_146
+152 val_152
+145 val_145
+281 val_281
+15 val_15
+166 val_166
+417 val_417
+219 val_219
+153 val_153
+193 val_193
+174 val_174
+413 val_413
+199 val_199
+174 val_174
+417 val_417
+162 val_162
+167 val_167
+195 val_195
+17 val_17
+113 val_113
+155 val_155
+128 val_128
+311 val_311
+316 val_316
+149 val_149
+129 val_129
+170 val_170
+157 val_157
+221 val_221
+111 val_111
+169 val_169
+125 val_125
+192 val_192
+187 val_187
+176 val_176
+51 val_51
+138 val_138
+103 val_103
+213 val_213
+216 val_216
+176 val_176
+221 val_221
+318 val_318
+311 val_311
+137 val_137
+241 val_241
+180 val_180
+12 val_12
+181 val_181
+138 val_138
+217 val_217
+411 val_411
+431 val_431
+179 val_179
+172 val_172
+129 val_129
+158 val_158
+119 val_119
+197 val_197
+100 val_100
+199 val_199
+191 val_191
+418 val_418
+165 val_165
+120 val_120
+131 val_131
+51 val_51
+156 val_156
+196 val_196
+481 val_481
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+137 val_137
+316 val_316
+169 val_169
+413 val_413
+179 val_179
+118 val_118
+134 val_134
+138 val_138
+419 val_419
+15 val_15
+118 val_118
+19 val_19
+10 val_10
+331 val_331
+401 val_401
+177 val_177
+317 val_317
+11 val_11
+168 val_168
+143 val_143
+160 val_160
+195 val_195
+321 val_321
+119 val_119
+41 val_41
+149 val_149
+218 val_218
+138 val_138
+103 val_103
+113 val_113
+216 val_216
+167 val_167
+219 val_219
+116 val_116
+401 val_401
+191 val_191
+128 val_128
+316 val_316
+331 val_331
+193 val_193
+321 val_321
+104 val_104
+175 val_175
+105 val_105
+190 val_190
+401 val_401
+114 val_114
+12 val_12
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+125 val_125
+431 val_431
+164 val_164
+187 val_187
+291 val_291
+351 val_351
+104 val_104
+163 val_163
+119 val_119
+414 val_414
+491 val_491
+417 val_417
+199 val_199
+120 val_120
+169 val_169
+178 val_178
+310 val_310
+317 val_317
+136 val_136
+172 val_172
+214 val_214
+133 val_133
+175 val_175
+189 val_189
+401 val_401
+421 val_421
+134 val_134
+18 val_18
+100 val_100
+341 val_341
+146 val_146
+186 val_186
+167 val_167
+18 val_18
+183 val_183
+281 val_281
+315 val_315
+152 val_152
+194 val_194
+414 val_414
+126 val_126
+169 val_169
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 b/sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 b/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3
new file mode 100644
index 0000000..0fe6b90
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3
@@ -0,0 +1,500 @@
+val_238 11
+val_86 11
+val_311 11
+val_27 11
+val_165 11
+val_409 11
+val_255 11
+val_278 11
+val_98 11
+val_484 11
+val_265 11
+val_193 11
+val_401 11
+val_150 11
+val_273 11
+val_224 11
+val_369 11
+val_66 11
+val_128 11
+val_213 11
+val_146 11
+val_406 11
+val_429 11
+val_374 11
+val_152 11
+val_469 11
+val_145 11
+val_495 11
+val_37 11
+val_327 11
+val_281 11
+val_277 11
+val_209 11
+val_15 11
+val_82 11
+val_403 11
+val_166 11
+val_417 11
+val_430 11
+val_252 11
+val_292 11
+val_219 11
+val_287 11
+val_153 11
+val_193 11
+val_338 11
+val_446 11
+val_459 11
+val_394 11
+val_237 11
+val_482 11
+val_174 11
+val_413 11
+val_494 11
+val_207 11
+val_199 11
+val_466 11
+val_208 11
+val_174 11
+val_399 11
+val_396 11
+val_247 11
+val_417 11
+val_489 11
+val_162 11
+val_377 11
+val_397 11
+val_309 11
+val_365 11
+val_266 11
+val_439 11
+val_342 11
+val_367 11
+val_325 11
+val_167 11
+val_195 11
+val_475 11
+val_17 11
+val_113 11
+val_155 11
+val_203 11
+val_339 11
+val_0 11
+val_455 11
+val_128 11
+val_311 11
+val_316 11
+val_57 11
+val_302 11
+val_205 11
+val_149 11
+val_438 11
+val_345 11
+val_129 11
+val_170 11
+val_20 11
+val_489 11
+val_157 11
+val_378 11
+val_221 11
+val_92 11
+val_111 11
+val_47 11
+val_72 11
+val_4 11
+val_280 11
+val_35 11
+val_427 11
+val_277 11
+val_208 11
+val_356 11
+val_399 11
+val_169 11
+val_382 11
+val_498 11
+val_125 11
+val_386 11
+val_437 11
+val_469 11
+val_192 11
+val_286 11
+val_187 11
+val_176 11
+val_54 11
+val_459 11
+val_51 11
+val_138 11
+val_103 11
+val_239 11
+val_213 11
+val_216 11
+val_430 11
+val_278 11
+val_176 11
+val_289 11
+val_221 11
+val_65 11
+val_318 11
+val_332 11
+val_311 11
+val_275 11
+val_137 11
+val_241 11
+val_83 11
+val_333 11
+val_180 11
+val_284 11
+val_12 11
+val_230 11
+val_181 11
+val_67 11
+val_260 11
+val_404 11
+val_384 11
+val_489 11
+val_353 11
+val_373 11
+val_272 11
+val_138 11
+val_217 11
+val_84 11
+val_348 11
+val_466 11
+val_58 11
+val_8 11
+val_411 11
+val_230 11
+val_208 11
+val_348 11
+val_24 11
+val_463 11
+val_431 11
+val_179 11
+val_172 11
+val_42 11
+val_129 11
+val_158 11
+val_119 11
+val_496 11
+val_0 11
+val_322 11
+val_197 11
+val_468 11
+val_393 11
+val_454 11
+val_100 11
+val_298 11
+val_199 11
+val_191 11
+val_418 11
+val_96 11
+val_26 11
+val_165 11
+val_327 11
+val_230 11
+val_205 11
+val_120 11
+val_131 11
+val_51 11
+val_404 11
+val_43 11
+val_436 11
+val_156 11
+val_469 11
+val_468 11
+val_308 11
+val_95 11
+val_196 11
+val_288 11
+val_481 11
+val_457 11
+val_98 11
+val_282 11
+val_197 11
+val_187 11
+val_318 11
+val_318 11
+val_409 11
+val_470 11
+val_137 11
+val_369 11
+val_316 11
+val_169 11
+val_413 11
+val_85 11
+val_77 11
+val_0 11
+val_490 11
+val_87 11
+val_364 11
+val_179 11
+val_118 11
+val_134 11
+val_395 11
+val_282 11
+val_138 11
+val_238 11
+val_419 11
+val_15 11
+val_118 11
+val_72 11
+val_90 11
+val_307 11
+val_19 11
+val_435 11
+val_10 11
+val_277 11
+val_273 11
+val_306 11
+val_224 11
+val_309 11
+val_389 11
+val_327 11
+val_242 11
+val_369 11
+val_392 11
+val_272 11
+val_331 11
+val_401 11
+val_242 11
+val_452 11
+val_177 11
+val_226 11
+val_5 11
+val_497 11
+val_402 11
+val_396 11
+val_317 11
+val_395 11
+val_58 11
+val_35 11
+val_336 11
+val_95 11
+val_11 11
+val_168 11
+val_34 11
+val_229 11
+val_233 11
+val_143 11
+val_472 11
+val_322 11
+val_498 11
+val_160 11
+val_195 11
+val_42 11
+val_321 11
+val_430 11
+val_119 11
+val_489 11
+val_458 11
+val_78 11
+val_76 11
+val_41 11
+val_223 11
+val_492 11
+val_149 11
+val_449 11
+val_218 11
+val_228 11
+val_138 11
+val_453 11
+val_30 11
+val_209 11
+val_64 11
+val_468 11
+val_76 11
+val_74 11
+val_342 11
+val_69 11
+val_230 11
+val_33 11
+val_368 11
+val_103 11
+val_296 11
+val_113 11
+val_216 11
+val_367 11
+val_344 11
+val_167 11
+val_274 11
+val_219 11
+val_239 11
+val_485 11
+val_116 11
+val_223 11
+val_256 11
+val_263 11
+val_70 11
+val_487 11
+val_480 11
+val_401 11
+val_288 11
+val_191 11
+val_5 11
+val_244 11
+val_438 11
+val_128 11
+val_467 11
+val_432 11
+val_202 11
+val_316 11
+val_229 11
+val_469 11
+val_463 11
+val_280 11
+val_2 11
+val_35 11
+val_283 11
+val_331 11
+val_235 11
+val_80 11
+val_44 11
+val_193 11
+val_321 11
+val_335 11
+val_104 11
+val_466 11
+val_366 11
+val_175 11
+val_403 11
+val_483 11
+val_53 11
+val_105 11
+val_257 11
+val_406 11
+val_409 11
+val_190 11
+val_406 11
+val_401 11
+val_114 11
+val_258 11
+val_90 11
+val_203 11
+val_262 11
+val_348 11
+val_424 11
+val_12 11
+val_396 11
+val_201 11
+val_217 11
+val_164 11
+val_431 11
+val_454 11
+val_478 11
+val_298 11
+val_125 11
+val_431 11
+val_164 11
+val_424 11
+val_187 11
+val_382 11
+val_5 11
+val_70 11
+val_397 11
+val_480 11
+val_291 11
+val_24 11
+val_351 11
+val_255 11
+val_104 11
+val_70 11
+val_163 11
+val_438 11
+val_119 11
+val_414 11
+val_200 11
+val_491 11
+val_237 11
+val_439 11
+val_360 11
+val_248 11
+val_479 11
+val_305 11
+val_417 11
+val_199 11
+val_444 11
+val_120 11
+val_429 11
+val_169 11
+val_443 11
+val_323 11
+val_325 11
+val_277 11
+val_230 11
+val_478 11
+val_178 11
+val_468 11
+val_310 11
+val_317 11
+val_333 11
+val_493 11
+val_460 11
+val_207 11
+val_249 11
+val_265 11
+val_480 11
+val_83 11
+val_136 11
+val_353 11
+val_172 11
+val_214 11
+val_462 11
+val_233 11
+val_406 11
+val_133 11
+val_175 11
+val_189 11
+val_454 11
+val_375 11
+val_401 11
+val_421 11
+val_407 11
+val_384 11
+val_256 11
+val_26 11
+val_134 11
+val_67 11
+val_384 11
+val_379 11
+val_18 11
+val_462 11
+val_492 11
+val_100 11
+val_298 11
+val_9 11
+val_341 11
+val_498 11
+val_146 11
+val_458 11
+val_362 11
+val_186 11
+val_285 11
+val_348 11
+val_167 11
+val_18 11
+val_273 11
+val_183 11
+val_281 11
+val_344 11
+val_97 11
+val_469 11
+val_315 11
+val_84 11
+val_28 11
+val_37 11
+val_448 11
+val_152 11
+val_348 11
+val_307 11
+val_194 11
+val_414 11
+val_477 11
+val_222 11
+val_126 11
+val_90 11
+val_169 11
+val_403 11
+val_400 11
+val_200 11
+val_97 11
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb b/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb
new file mode 100644
index 0000000..444039e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb
@@ -0,0 +1,500 @@
+476
+172
+622
+54
+330
+818
+510
+556
+196
+968
+530
+386
+802
+300
+546
+448
+738
+132
+256
+426
+292
+812
+858
+748
+304
+938
+290
+990
+74
+654
+562
+554
+418
+30
+164
+806
+332
+834
+860
+504
+584
+438
+574
+306
+386
+676
+892
+918
+788
+474
+964
+348
+826
+988
+414
+398
+932
+416
+348
+798
+792
+494
+834
+978
+324
+754
+794
+618
+730
+532
+878
+684
+734
+650
+334
+390
+950
+34
+226
+310
+406
+678
+0
+910
+256
+622
+632
+114
+604
+410
+298
+876
+690
+258
+340
+40
+978
+314
+756
+442
+184
+222
+94
+144
+8
+560
+70
+854
+554
+416
+712
+798
+338
+764
+996
+250
+772
+874
+938
+384
+572
+374
+352
+108
+918
+102
+276
+206
+478
+426
+432
+860
+556
+352
+578
+442
+130
+636
+664
+622
+550
+274
+482
+166
+666
+360
+568
+24
+460
+362
+134
+520
+808
+768
+978
+706
+746
+544
+276
+434
+168
+696
+932
+116
+16
+822
+460
+416
+696
+48
+926
+862
+358
+344
+84
+258
+316
+238
+992
+0
+644
+394
+936
+786
+908
+200
+596
+398
+382
+836
+192
+52
+330
+654
+460
+410
+240
+262
+102
+808
+86
+872
+312
+938
+936
+616
+190
+392
+576
+962
+914
+196
+564
+394
+374
+636
+636
+818
+940
+274
+738
+632
+338
+826
+170
+154
+0
+980
+174
+728
+358
+236
+268
+790
+564
+276
+476
+838
+30
+236
+144
+180
+614
+38
+870
+20
+554
+546
+612
+448
+618
+778
+654
+484
+738
+784
+544
+662
+802
+484
+904
+354
+452
+10
+994
+804
+792
+634
+790
+116
+70
+672
+190
+22
+336
+68
+458
+466
+286
+944
+644
+996
+320
+390
+84
+642
+860
+238
+978
+916
+156
+152
+82
+446
+984
+298
+898
+436
+456
+276
+906
+60
+418
+128
+936
+152
+148
+684
+138
+460
+66
+736
+206
+592
+226
+432
+734
+688
+334
+548
+438
+478
+970
+232
+446
+512
+526
+140
+974
+960
+802
+576
+382
+10
+488
+876
+256
+934
+864
+404
+632
+458
+938
+926
+560
+4
+70
+566
+662
+470
+160
+88
+386
+642
+670
+208
+932
+732
+350
+806
+966
+106
+210
+514
+812
+818
+380
+812
+802
+228
+516
+180
+406
+524
+696
+848
+24
+792
+402
+434
+328
+862
+908
+956
+596
+250
+862
+328
+848
+374
+764
+10
+140
+794
+960
+582
+48
+702
+510
+208
+140
+326
+876
+238
+828
+400
+982
+474
+878
+720
+496
+958
+610
+834
+398
+888
+240
+858
+338
+886
+646
+650
+554
+460
+956
+356
+936
+620
+634
+666
+986
+920
+414
+498
+530
+960
+166
+272
+706
+344
+428
+924
+466
+812
+266
+350
+378
+908
+750
+802
+842
+814
+768
+512
+52
+268
+134
+768
+758
+36
+924
+984
+200
+596
+18
+682
+996
+292
+916
+724
+372
+570
+696
+334
+36
+546
+366
+562
+688
+194
+938
+630
+168
+56
+74
+896
+304
+696
+614
+388
+828
+954
+444
+252
+180
+338
+806
+800
+400
+194
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 b/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10
new file mode 100644
index 0000000..d83d8b6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10
@@ -0,0 +1,1000 @@
+val_238 11
+val_86 11
+val_311 11
+val_27 11
+val_165 11
+val_409 11
+val_255 11
+val_278 11
+val_98 11
+val_484 11
+val_265 11
+val_193 11
+val_401 11
+val_150 11
+val_273 11
+val_224 11
+val_369 11
+val_66 11
+val_128 11
+val_213 11
+val_146 11
+val_406 11
+val_429 11
+val_374 11
+val_152 11
+val_469 11
+val_145 11
+val_495 11
+val_37 11
+val_327 11
+val_281 11
+val_277 11
+val_209 11
+val_15 11
+val_82 11
+val_403 11
+val_166 11
+val_417 11
+val_430 11
+val_252 11
+val_292 11
+val_219 11
+val_287 11
+val_153 11
+val_193 11
+val_338 11
+val_446 11
+val_459 11
+val_394 11
+val_237 11
+val_482 11
+val_174 11
+val_413 11
+val_494 11
+val_207 11
+val_199 11
+val_466 11
+val_208 11
+val_174 11
+val_399 11
+val_396 11
+val_247 11
+val_417 11
+val_489 11
+val_162 11
+val_377 11
+val_397 11
+val_309 11
+val_365 11
+val_266 11
+val_439 11
+val_342 11
+val_367 11
+val_325 11
+val_167 11
+val_195 11
+val_475 11
+val_17 11
+val_113 11
+val_155 11
+val_203 11
+val_339 11
+val_0 11
+val_455 11
+val_128 11
+val_311 11
+val_316 11
+val_57 11
+val_302 11
+val_205 11
+val_149 11
+val_438 11
+val_345 11
+val_129 11
+val_170 11
+val_20 11
+val_489 11
+val_157 11
+val_378 11
+val_221 11
+val_92 11
+val_111 11
+val_47 11
+val_72 11
+val_4 11
+val_280 11
+val_35 11
+val_427 11
+val_277 11
+val_208 11
+val_356 11
+val_399 11
+val_169 11
+val_382 11
+val_498 11
+val_125 11
+val_386 11
+val_437 11
+val_469 11
+val_192 11
+val_286 11
+val_187 11
+val_176 11
+val_54 11
+val_459 11
+val_51 11
+val_138 11
+val_103 11
+val_239 11
+val_213 11
+val_216 11
+val_430 11
+val_278 11
+val_176 11
+val_289 11
+val_221 11
+val_65 11
+val_318 11
+val_332 11
+val_311 11
+val_275 11
+val_137 11
+val_241 11
+val_83 11
+val_333 11
+val_180 11
+val_284 11
+val_12 11
+val_230 11
+val_181 11
+val_67 11
+val_260 11
+val_404 11
+val_384 11
+val_489 11
+val_353 11
+val_373 11
+val_272 11
+val_138 11
+val_217 11
+val_84 11
+val_348 11
+val_466 11
+val_58 11
+val_8 11
+val_411 11
+val_230 11
+val_208 11
+val_348 11
+val_24 11
+val_463 11
+val_431 11
+val_179 11
+val_172 11
+val_42 11
+val_129 11
+val_158 11
+val_119 11
+val_496 11
+val_0 11
+val_322 11
+val_197 11
+val_468 11
+val_393 11
+val_454 11
+val_100 11
+val_298 11
+val_199 11
+val_191 11
+val_418 11
+val_96 11
+val_26 11
+val_165 11
+val_327 11
+val_230 11
+val_205 11
+val_120 11
+val_131 11
+val_51 11
+val_404 11
+val_43 11
+val_436 11
+val_156 11
+val_469 11
+val_468 11
+val_308 11
+val_95 11
+val_196 11
+val_288 11
+val_481 11
+val_457 11
+val_98 11
+val_282 11
+val_197 11
+val_187 11
+val_318 11
+val_318 11
+val_409 11
+val_470 11
+val_137 11
+val_369 11
+val_316 11
+val_169 11
+val_413 11
+val_85 11
+val_77 11
+val_0 11
+val_490 11
+val_87 11
+val_364 11
+val_179 11
+val_118 11
+val_134 11
+val_395 11
+val_282 11
+val_138 11
+val_238 11
+val_419 11
+val_15 11
+val_118 11
+val_72 11
+val_90 11
+val_307 11
+val_19 11
+val_435 11
+val_10 11
+val_277 11
+val_273 11
+val_306 11
+val_224 11
+val_309 11
+val_389 11
+val_327 11
+val_242 11
+val_369 11
+val_392 11
+val_272 11
+val_331 11
+val_401 11
+val_242 11
+val_452 11
+val_177 11
+val_226 11
+val_5 11
+val_497 11
+val_402 11
+val_396 11
+val_317 11
+val_395 11
+val_58 11
+val_35 11
+val_336 11
+val_95 11
+val_11 11
+val_168 11
+val_34 11
+val_229 11
+val_233 11
+val_143 11
+val_472 11
+val_322 11
+val_498 11
+val_160 11
+val_195 11
+val_42 11
+val_321 11
+val_430 11
+val_119 11
+val_489 11
+val_458 11
+val_78 11
+val_76 11
+val_41 11
+val_223 11
+val_492 11
+val_149 11
+val_449 11
+val_218 11
+val_228 11
+val_138 11
+val_453 11
+val_30 11
+val_209 11
+val_64 11
+val_468 11
+val_76 11
+val_74 11
+val_342 11
+val_69 11
+val_230 11
+val_33 11
+val_368 11
+val_103 11
+val_296 11
+val_113 11
+val_216 11
+val_367 11
+val_344 11
+val_167 11
+val_274 11
+val_219 11
+val_239 11
+val_485 11
+val_116 11
+val_223 11
+val_256 11
+val_263 11
+val_70 11
+val_487 11
+val_480 11
+val_401 11
+val_288 11
+val_191 11
+val_5 11
+val_244 11
+val_438 11
+val_128 11
+val_467 11
+val_432 11
+val_202 11
+val_316 11
+val_229 11
+val_469 11
+val_463 11
+val_280 11
+val_2 11
+val_35 11
+val_283 11
+val_331 11
+val_235 11
+val_80 11
+val_44 11
+val_193 11
+val_321 11
+val_335 11
+val_104 11
+val_466 11
+val_366 11
+val_175 11
+val_403 11
+val_483 11
+val_53 11
+val_105 11
+val_257 11
+val_406 11
+val_409 11
+val_190 11
+val_406 11
+val_401 11
+val_114 11
+val_258 11
+val_90 11
+val_203 11
+val_262 11
+val_348 11
+val_424 11
+val_12 11
+val_396 11
+val_201 11
+val_217 11
+val_164 11
+val_431 11
+val_454 11
+val_478 11
+val_298 11
+val_125 11
+val_431 11
+val_164 11
+val_424 11
+val_187 11
+val_382 11
+val_5 11
+val_70 11
+val_397 11
+val_480 11
+val_291 11
+val_24 11
+val_351 11
+val_255 11
+val_104 11
+val_70 11
+val_163 11
+val_438 11
+val_119 11
+val_414 11
+val_200 11
+val_491 11
+val_237 11
+val_439 11
+val_360 11
+val_248 11
+val_479 11
+val_305 11
+val_417 11
+val_199 11
+val_444 11
+val_120 11
+val_429 11
+val_169 11
+val_443 11
+val_323 11
+val_325 11
+val_277 11
+val_230 11
+val_478 11
+val_178 11
+val_468 11
+val_310 11
+val_317 11
+val_333 11
+val_493 11
+val_460 11
+val_207 11
+val_249 11
+val_265 11
+val_480 11
+val_83 11
+val_136 11
+val_353 11
+val_172 11
+val_214 11
+val_462 11
+val_233 11
+val_406 11
+val_133 11
+val_175 11
+val_189 11
+val_454 11
+val_375 11
+val_401 11
+val_421 11
+val_407 11
+val_384 11
+val_256 11
+val_26 11
+val_134 11
+val_67 11
+val_384 11
+val_379 11
+val_18 11
+val_462 11
+val_492 11
+val_100 11
+val_298 11
+val_9 11
+val_341 11
+val_498 11
+val_146 11
+val_458 11
+val_362 11
+val_186 11
+val_285 11
+val_348 11
+val_167 11
+val_18 11
+val_273 11
+val_183 11
+val_281 11
+val_344 11
+val_97 11
+val_469 11
+val_315 11
+val_84 11
+val_28 11
+val_37 11
+val_448 11
+val_152 11
+val_348 11
+val_307 11
+val_194 11
+val_414 11
+val_477 11
+val_222 11
+val_126 11
+val_90 11
+val_169 11
+val_403 11
+val_400 11
+val_200 11
+val_97 11
+val_238 11
+val_86 11
+val_311 11
+val_27 11
+val_165 11
+val_409 11
+val_255 11
+val_278 11
+val_98 11
+val_484 11
+val_265 11
+val_193 11
+val_401 11
+val_150 11
+val_273 11
+val_224 11
+val_369 11
+val_66 11
+val_128 11
+val_213 11
+val_146 11
+val_406 11
+val_429 11
+val_374 11
+val_152 11
+val_469 11
+val_145 11
+val_495 11
+val_37 11
+val_327 11
+val_281 11
+val_277 11
+val_209 11
+val_15 11
+val_82 11
+val_403 11
+val_166 11
+val_417 11
+val_430 11
+val_252 11
+val_292 11
+val_219 11
+val_287 11
+val_153 11
+val_193 11
+val_338 11
+val_446 11
+val_459 11
+val_394 11
+val_237 11
+val_482 11
+val_174 11
+val_413 11
+val_494 11
+val_207 11
+val_199 11
+val_466 11
+val_208 11
+val_174 11
+val_399 11
+val_396 11
+val_247 11
+val_417 11
+val_489 11
+val_162 11
+val_377 11
+val_397 11
+val_309 11
+val_365 11
+val_266 11
+val_439 11
+val_342 11
+val_367 11
+val_325 11
+val_167 11
+val_195 11
+val_475 11
+val_17 11
+val_113 11
+val_155 11
+val_203 11
+val_339 11
+val_0 11
+val_455 11
+val_128 11
+val_311 11
+val_316 11
+val_57 11
+val_302 11
+val_205 11
+val_149 11
+val_438 11
+val_345 11
+val_129 11
+val_170 11
+val_20 11
+val_489 11
+val_157 11
+val_378 11
+val_221 11
+val_92 11
+val_111 11
+val_47 11
+val_72 11
+val_4 11
+val_280 11
+val_35 11
+val_427 11
+val_277 11
+val_208 11
+val_356 11
+val_399 11
+val_169 11
+val_382 11
+val_498 11
+val_125 11
+val_386 11
+val_437 11
+val_469 11
+val_192 11
+val_286 11
+val_187 11
+val_176 11
+val_54 11
+val_459 11
+val_51 11
+val_138 11
+val_103 11
+val_239 11
+val_213 11
+val_216 11
+val_430 11
+val_278 11
+val_176 11
+val_289 11
+val_221 11
+val_65 11
+val_318 11
+val_332 11
+val_311 11
+val_275 11
+val_137 11
+val_241 11
+val_83 11
+val_333 11
+val_180 11
+val_284 11
+val_12 11
+val_230 11
+val_181 11
+val_67 11
+val_260 11
+val_404 11
+val_384 11
+val_489 11
+val_353 11
+val_373 11
+val_272 11
+val_138 11
+val_217 11
+val_84 11
+val_348 11
+val_466 11
+val_58 11
+val_8 11
+val_411 11
+val_230 11
+val_208 11
+val_348 11
+val_24 11
+val_463 11
+val_431 11
+val_179 11
+val_172 11
+val_42 11
+val_129 11
+val_158 11
+val_119 11
+val_496 11
+val_0 11
+val_322 11
+val_197 11
+val_468 11
+val_393 11
+val_454 11
+val_100 11
+val_298 11
+val_199 11
+val_191 11
+val_418 11
+val_96 11
+val_26 11
+val_165 11
+val_327 11
+val_230 11
+val_205 11
+val_120 11
+val_131 11
+val_51 11
+val_404 11
+val_43 11
+val_436 11
+val_156 11
+val_469 11
+val_468 11
+val_308 11
+val_95 11
+val_196 11
+val_288 11
+val_481 11
+val_457 11
+val_98 11
+val_282 11
+val_197 11
+val_187 11
+val_318 11
+val_318 11
+val_409 11
+val_470 11
+val_137 11
+val_369 11
+val_316 11
+val_169 11
+val_413 11
+val_85 11
+val_77 11
+val_0 11
+val_490 11
+val_87 11
+val_364 11
+val_179 11
+val_118 11
+val_134 11
+val_395 11
+val_282 11
+val_138 11
+val_238 11
+val_419 11
+val_15 11
+val_118 11
+val_72 11
+val_90 11
+val_307 11
+val_19 11
+val_435 11
+val_10 11
+val_277 11
+val_273 11
+val_306 11
+val_224 11
+val_309 11
+val_389 11
+val_327 11
+val_242 11
+val_369 11
+val_392 11
+val_272 11
+val_331 11
+val_401 11
+val_242 11
+val_452 11
+val_177 11
+val_226 11
+val_5 11
+val_497 11
+val_402 11
+val_396 11
+val_317 11
+val_395 11
+val_58 11
+val_35 11
+val_336 11
+val_95 11
+val_11 11
+val_168 11
+val_34 11
+val_229 11
+val_233 11
+val_143 11
+val_472 11
+val_322 11
+val_498 11
+val_160 11
+val_195 11
+val_42 11
+val_321 11
+val_430 11
+val_119 11
+val_489 11
+val_458 11
+val_78 11
+val_76 11
+val_41 11
+val_223 11
+val_492 11
+val_149 11
+val_449 11
+val_218 11
+val_228 11
+val_138 11
+val_453 11
+val_30 11
+val_209 11
+val_64 11
+val_468 11
+val_76 11
+val_74 11
+val_342 11
+val_69 11
+val_230 11
+val_33 11
+val_368 11
+val_103 11
+val_296 11
+val_113 11
+val_216 11
+val_367 11
+val_344 11
+val_167 11
+val_274 11
+val_219 11
+val_239 11
+val_485 11
+val_116 11
+val_223 11
+val_256 11
+val_263 11
+val_70 11
+val_487 11
+val_480 11
+val_401 11
+val_288 11
+val_191 11
+val_5 11
+val_244 11
+val_438 11
+val_128 11
+val_467 11
+val_432 11
+val_202 11
+val_316 11
+val_229 11
+val_469 11
+val_463 11
+val_280 11
+val_2 11
+val_35 11
+val_283 11
+val_331 11
+val_235 11
+val_80 11
+val_44 11
+val_193 11
+val_321 11
+val_335 11
+val_104 11
+val_466 11
+val_366 11
+val_175 11
+val_403 11
+val_483 11
+val_53 11
+val_105 11
+val_257 11
+val_406 11
+val_409 11
+val_190 11
+val_406 11
+val_401 11
+val_114 11
+val_258 11
+val_90 11
+val_203 11
+val_262 11
+val_348 11
+val_424 11
+val_12 11
+val_396 11
+val_201 11
+val_217 11
+val_164 11
+val_431 11
+val_454 11
+val_478 11
+val_298 11
+val_125 11
+val_431 11
+val_164 11
+val_424 11
+val_187 11
+val_382 11
+val_5 11
+val_70 11
+val_397 11
+val_480 11
+val_291 11
+val_24 11
+val_351 11
+val_255 11
+val_104 11
+val_70 11
+val_163 11
+val_438 11
+val_119 11
+val_414 11
+val_200 11
+val_491 11
+val_237 11
+val_439 11
+val_360 11
+val_248 11
+val_479 11
+val_305 11
+val_417 11
+val_199 11
+val_444 11
+val_120 11
+val_429 11
+val_169 11
+val_443 11
+val_323 11
+val_325 11
+val_277 11
+val_230 11
+val_478 11
+val_178 11
+val_468 11
+val_310 11
+val_317 11
+val_333 11
+val_493 11
+val_460 11
+val_207 11
+val_249 11
+val_265 11
+val_480 11
+val_83 11
+val_136 11
+val_353 11
+val_172 11
+val_214 11
+val_462 11
+val_233 11
+val_406 11
+val_133 11
+val_175 11
+val_189 11
+val_454 11
+val_375 11
+val_401 11
+val_421 11
+val_407 11
+val_384 11
+val_256 11
+val_26 11
+val_134 11
+val_67 11
+val_384 11
+val_379 11
+val_18 11
+val_462 11
+val_492 11
+val_100 11
+val_298 11
+val_9 11
+val_341 11
+val_498 11
+val_146 11
+val_458 11
+val_362 11
+val_186 11
+val_285 11
+val_348 11
+val_167 11
+val_18 11
+val_273 11
+val_183 11
+val_281 11
+val_344 11
+val_97 11
+val_469 11
+val_315 11
+val_84 11
+val_28 11
+val_37 11
+val_448 11
+val_152 11
+val_348 11
+val_307 11
+val_194 11
+val_414 11
+val_477 11
+val_222 11
+val_126 11
+val_90 11
+val_169 11
+val_403 11
+val_400 11
+val_200 11
+val_97 11