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:08 UTC
[06/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/golden/join_reorder4-8-4bbb8e937245e2fa7cafbb423814754
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_reorder4-8-4bbb8e937245e2fa7cafbb423814754 b/sql/hive/src/test/resources/golden/join_reorder4-8-4bbb8e937245e2fa7cafbb423814754
new file mode 100644
index 0000000..8721465
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_reorder4-8-4bbb8e937245e2fa7cafbb423814754
@@ -0,0 +1 @@
+2 12 2 22 2 12
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_reorder4-9-b401eef67c1c04f875c084c9e0fda9ba
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_reorder4-9-b401eef67c1c04f875c084c9e0fda9ba b/sql/hive/src/test/resources/golden/join_reorder4-9-b401eef67c1c04f875c084c9e0fda9ba
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-0-6001f83f7780835737e3262a34c2b832
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-0-6001f83f7780835737e3262a34c2b832 b/sql/hive/src/test/resources/golden/join_star-0-6001f83f7780835737e3262a34c2b832
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-1-9f29849fe78f15b7594378a10fe3ed9d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-1-9f29849fe78f15b7594378a10fe3ed9d b/sql/hive/src/test/resources/golden/join_star-1-9f29849fe78f15b7594378a10fe3ed9d
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-10-57ce75f989b3b3bfd2f2eceb228e892e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-10-57ce75f989b3b3bfd2f2eceb228e892e b/sql/hive/src/test/resources/golden/join_star-10-57ce75f989b3b3bfd2f2eceb228e892e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-11-eba1397e66f25cba4fd264209cc92bae
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-11-eba1397e66f25cba4fd264209cc92bae b/sql/hive/src/test/resources/golden/join_star-11-eba1397e66f25cba4fd264209cc92bae
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-12-89b53ae954ec88171ef87e0459f6eb82
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-12-89b53ae954ec88171ef87e0459f6eb82 b/sql/hive/src/test/resources/golden/join_star-12-89b53ae954ec88171ef87e0459f6eb82
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-13-342b7249c9ce1484869169b1b33191cb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-13-342b7249c9ce1484869169b1b33191cb b/sql/hive/src/test/resources/golden/join_star-13-342b7249c9ce1484869169b1b33191cb
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-14-75513308d30b781fd2e06d81963c4363
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-14-75513308d30b781fd2e06d81963c4363 b/sql/hive/src/test/resources/golden/join_star-14-75513308d30b781fd2e06d81963c4363
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-15-24a0b1d0257bad4f85b3a122acf6bef9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-15-24a0b1d0257bad4f85b3a122acf6bef9 b/sql/hive/src/test/resources/golden/join_star-15-24a0b1d0257bad4f85b3a122acf6bef9
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-16-24ca942f094b14b92086305cc125e833
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-16-24ca942f094b14b92086305cc125e833 b/sql/hive/src/test/resources/golden/join_star-16-24ca942f094b14b92086305cc125e833
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-16-24ca942f094b14b92086305cc125e833
@@ -0,0 +1 @@
+0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-17-44d382ce6848d3f0b900b0808747d8e9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-17-44d382ce6848d3f0b900b0808747d8e9 b/sql/hive/src/test/resources/golden/join_star-17-44d382ce6848d3f0b900b0808747d8e9
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-17-44d382ce6848d3f0b900b0808747d8e9
@@ -0,0 +1 @@
+0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-18-1c22e451845667bd6b4eac3c49c36965
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-18-1c22e451845667bd6b4eac3c49c36965 b/sql/hive/src/test/resources/golden/join_star-18-1c22e451845667bd6b4eac3c49c36965
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-18-1c22e451845667bd6b4eac3c49c36965
@@ -0,0 +1 @@
+0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-19-a1209595ce68e24a111c2a0d27863bfa
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-19-a1209595ce68e24a111c2a0d27863bfa b/sql/hive/src/test/resources/golden/join_star-19-a1209595ce68e24a111c2a0d27863bfa
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-2-75d7e03808482c11361ce72f2dd38de0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-2-75d7e03808482c11361ce72f2dd38de0 b/sql/hive/src/test/resources/golden/join_star-2-75d7e03808482c11361ce72f2dd38de0
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-20-76473cb68a69b9408207fd43ddae9339
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-20-76473cb68a69b9408207fd43ddae9339 b/sql/hive/src/test/resources/golden/join_star-20-76473cb68a69b9408207fd43ddae9339
new file mode 100644
index 0000000..e60bca6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-20-76473cb68a69b9408207fd43ddae9339
@@ -0,0 +1,10 @@
+1 2 1
+11 12 1
+21 22 1
+31 32 1
+41 42 1
+51 52 3
+61 62 3
+71 72 3
+81 82 3
+91 92 3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-21-6b8dbb1dbcf0096f0af3209bb6efd2c6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-21-6b8dbb1dbcf0096f0af3209bb6efd2c6 b/sql/hive/src/test/resources/golden/join_star-21-6b8dbb1dbcf0096f0af3209bb6efd2c6
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-22-429cfd140488242d569aee6594aae76b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-22-429cfd140488242d569aee6594aae76b b/sql/hive/src/test/resources/golden/join_star-22-429cfd140488242d569aee6594aae76b
new file mode 100644
index 0000000..e08d049
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-22-429cfd140488242d569aee6594aae76b
@@ -0,0 +1,10 @@
+1 2 1 2
+11 12 1 2
+21 22 1 2
+31 32 1 2
+41 42 1 2
+51 52 3 4
+61 62 3 4
+71 72 3 4
+81 82 3 4
+91 92 3 4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-23-bada259628918dbfb4837bcb58258530
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-23-bada259628918dbfb4837bcb58258530 b/sql/hive/src/test/resources/golden/join_star-23-bada259628918dbfb4837bcb58258530
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-24-e11ab68d72d874c7c6c658c1018f5a49
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-24-e11ab68d72d874c7c6c658c1018f5a49 b/sql/hive/src/test/resources/golden/join_star-24-e11ab68d72d874c7c6c658c1018f5a49
new file mode 100644
index 0000000..b899111
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-24-e11ab68d72d874c7c6c658c1018f5a49
@@ -0,0 +1,10 @@
+1 2 1 1
+11 12 1 1
+21 22 1 1
+31 32 1 1
+41 42 1 1
+51 52 3 3
+61 62 3 3
+71 72 3 3
+81 82 3 3
+91 92 3 3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-25-be5af28b6bccf529a31ef68619de699e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-25-be5af28b6bccf529a31ef68619de699e b/sql/hive/src/test/resources/golden/join_star-25-be5af28b6bccf529a31ef68619de699e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-26-a412a0620a359a62e2ab4e45fa8e0330
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-26-a412a0620a359a62e2ab4e45fa8e0330 b/sql/hive/src/test/resources/golden/join_star-26-a412a0620a359a62e2ab4e45fa8e0330
new file mode 100644
index 0000000..b899111
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-26-a412a0620a359a62e2ab4e45fa8e0330
@@ -0,0 +1,10 @@
+1 2 1 1
+11 12 1 1
+21 22 1 1
+31 32 1 1
+41 42 1 1
+51 52 3 3
+61 62 3 3
+71 72 3 3
+81 82 3 3
+91 92 3 3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-27-9ae4ebb8ceaa724bdbc88126f86692f1
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-27-9ae4ebb8ceaa724bdbc88126f86692f1 b/sql/hive/src/test/resources/golden/join_star-27-9ae4ebb8ceaa724bdbc88126f86692f1
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-28-98a3f4d8a2209e771c57462d4b723ff9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-28-98a3f4d8a2209e771c57462d4b723ff9 b/sql/hive/src/test/resources/golden/join_star-28-98a3f4d8a2209e771c57462d4b723ff9
new file mode 100644
index 0000000..19611e7
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_star-28-98a3f4d8a2209e771c57462d4b723ff9
@@ -0,0 +1,10 @@
+1 2 1 1 2 2 2 2 2
+11 12 1 1 2 2 2 2 2
+21 22 1 1 2 2 2 2 2
+31 32 1 1 2 2 2 2 2
+41 42 1 1 2 2 2 2 2
+51 52 3 3 4 4 4 4 4
+61 62 3 3 4 4 4 4 4
+71 72 3 3 4 4 4 4 4
+81 82 3 3 4 4 4 4 4
+91 92 3 3 4 4 4 4 4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-3-4f4ca11033af3894cc2e720ebb69e5da
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-3-4f4ca11033af3894cc2e720ebb69e5da b/sql/hive/src/test/resources/golden/join_star-3-4f4ca11033af3894cc2e720ebb69e5da
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-4-aaba115af7543b214820a48a694f2463
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-4-aaba115af7543b214820a48a694f2463 b/sql/hive/src/test/resources/golden/join_star-4-aaba115af7543b214820a48a694f2463
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-5-c72a8aff3a51f9e59bb62fd99807d8da
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-5-c72a8aff3a51f9e59bb62fd99807d8da b/sql/hive/src/test/resources/golden/join_star-5-c72a8aff3a51f9e59bb62fd99807d8da
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-6-73d96ed451a4964e5c364dbdb56d487a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-6-73d96ed451a4964e5c364dbdb56d487a b/sql/hive/src/test/resources/golden/join_star-6-73d96ed451a4964e5c364dbdb56d487a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-7-b007c3d4b6ed10df9e875e23644b673a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-7-b007c3d4b6ed10df9e875e23644b673a b/sql/hive/src/test/resources/golden/join_star-7-b007c3d4b6ed10df9e875e23644b673a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-8-a957982d8981ff0a35397ca449297024
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-8-a957982d8981ff0a35397ca449297024 b/sql/hive/src/test/resources/golden/join_star-8-a957982d8981ff0a35397ca449297024
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_star-9-904e30d8615eb411fb24c2cc08df94f4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_star-9-904e30d8615eb411fb24c2cc08df94f4 b/sql/hive/src/test/resources/golden/join_star-9-904e30d8615eb411fb24c2cc08df94f4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_thrift-0-811b62ecbacdb26c67fa260ff3747a41
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_thrift-0-811b62ecbacdb26c67fa260ff3747a41 b/sql/hive/src/test/resources/golden/join_thrift-0-811b62ecbacdb26c67fa260ff3747a41
new file mode 100644
index 0000000..0743329
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_thrift-0-811b62ecbacdb26c67fa260ff3747a41
@@ -0,0 +1,6 @@
+aint int from deserializer
+astring string from deserializer
+lint array<int> from deserializer
+lstring array<string> from deserializer
+lintstring array<struct<myint:int,mystring:string,underscore_int:int>> from deserializer
+mstringstring map<string,string> from deserializer
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_thrift-1-4f47dd107d2be1212411bda214c0d1db
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_thrift-1-4f47dd107d2be1212411bda214c0d1db b/sql/hive/src/test/resources/golden/join_thrift-1-4f47dd107d2be1212411bda214c0d1db
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_thrift-2-d4bfb7bab262dc2898431680711dec1b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_thrift-2-d4bfb7bab262dc2898431680711dec1b b/sql/hive/src/test/resources/golden/join_thrift-2-d4bfb7bab262dc2898431680711dec1b
new file mode 100644
index 0000000..4aeaf4f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_thrift-2-d4bfb7bab262dc2898431680711dec1b
@@ -0,0 +1,11 @@
+1712634731 [{"myint":0,"mystring":"0","underscore_int":0}]
+465985200 [{"myint":1,"mystring":"1","underscore_int":1}]
+-751827638 [{"myint":4,"mystring":"8","underscore_int":2}]
+477111222 [{"myint":9,"mystring":"27","underscore_int":3}]
+-734328909 [{"myint":16,"mystring":"64","underscore_int":4}]
+-1952710710 [{"myint":25,"mystring":"125","underscore_int":5}]
+1244525190 [{"myint":36,"mystring":"216","underscore_int":6}]
+-1461153973 [{"myint":49,"mystring":"343","underscore_int":7}]
+1638581578 [{"myint":64,"mystring":"512","underscore_int":8}]
+336964413 [{"myint":81,"mystring":"729","underscore_int":9}]
+0 NULL
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_vc-0-f6269c9b545c9f908ef9aebf1a2ac097
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_vc-0-f6269c9b545c9f908ef9aebf1a2ac097 b/sql/hive/src/test/resources/golden/join_vc-0-f6269c9b545c9f908ef9aebf1a2ac097
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-0-d286410aa1d5f5c8d91b863a6d6e29c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-0-d286410aa1d5f5c8d91b863a6d6e29c5 b/sql/hive/src/test/resources/golden/join_view-0-d286410aa1d5f5c8d91b863a6d6e29c5
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-1-4e6a4fd729bac739f5f9b9e2c42b2467
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-1-4e6a4fd729bac739f5f9b9e2c42b2467 b/sql/hive/src/test/resources/golden/join_view-1-4e6a4fd729bac739f5f9b9e2c42b2467
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-2-eda40dba9678df62dde73fc5dafb2b44
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-2-eda40dba9678df62dde73fc5dafb2b44 b/sql/hive/src/test/resources/golden/join_view-2-eda40dba9678df62dde73fc5dafb2b44
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-3-eccb00d8dada8ab56a48c373e381e02b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-3-eccb00d8dada8ab56a48c373e381e02b b/sql/hive/src/test/resources/golden/join_view-3-eccb00d8dada8ab56a48c373e381e02b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-4-763ab5853bff619e6525c01e46b2a923
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-4-763ab5853bff619e6525c01e46b2a923 b/sql/hive/src/test/resources/golden/join_view-4-763ab5853bff619e6525c01e46b2a923
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/join_view-4-763ab5853bff619e6525c01e46b2a923
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-5-85baeea910adc4589bc3ec2ce0b1e856
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-5-85baeea910adc4589bc3ec2ce0b1e856 b/sql/hive/src/test/resources/golden/join_view-5-85baeea910adc4589bc3ec2ce0b1e856
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-6-c37b7962ab7371f94a9c54d61f7638ef
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-6-c37b7962ab7371f94a9c54d61f7638ef b/sql/hive/src/test/resources/golden/join_view-6-c37b7962ab7371f94a9c54d61f7638ef
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-7-a14cfe3eff322066e61023ec06c7735d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-7-a14cfe3eff322066e61023ec06c7735d b/sql/hive/src/test/resources/golden/join_view-7-a14cfe3eff322066e61023ec06c7735d
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-8-d286410aa1d5f5c8d91b863a6d6e29c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-8-d286410aa1d5f5c8d91b863a6d6e29c5 b/sql/hive/src/test/resources/golden/join_view-8-d286410aa1d5f5c8d91b863a6d6e29c5
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/join_view-9-4e6a4fd729bac739f5f9b9e2c42b2467
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/join_view-9-4e6a4fd729bac739f5f9b9e2c42b2467 b/sql/hive/src/test/resources/golden/join_view-9-4e6a4fd729bac739f5f9b9e2c42b2467
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view1-0-85bfbfd635aee807ede359073fb26dee
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view1-0-85bfbfd635aee807ede359073fb26dee b/sql/hive/src/test/resources/golden/lateral view1-0-85bfbfd635aee807ede359073fb26dee
new file mode 100644
index 0000000..1b89427
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral view1-0-85bfbfd635aee807ede359073fb26dee
@@ -0,0 +1,1000 @@
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
+1
+2
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view2-0-6d92d10040c715df89db0f61ae4250bb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view2-0-6d92d10040c715df89db0f61ae4250bb b/sql/hive/src/test/resources/golden/lateral view2-0-6d92d10040c715df89db0f61ae4250bb
new file mode 100644
index 0000000..86296b9
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral view2-0-6d92d10040c715df89db0f61ae4250bb
@@ -0,0 +1,1000 @@
+238 val_238 1
+238 val_238 2
+86 val_86 1
+86 val_86 2
+311 val_311 1
+311 val_311 2
+27 val_27 1
+27 val_27 2
+165 val_165 1
+165 val_165 2
+409 val_409 1
+409 val_409 2
+255 val_255 1
+255 val_255 2
+278 val_278 1
+278 val_278 2
+98 val_98 1
+98 val_98 2
+484 val_484 1
+484 val_484 2
+265 val_265 1
+265 val_265 2
+193 val_193 1
+193 val_193 2
+401 val_401 1
+401 val_401 2
+150 val_150 1
+150 val_150 2
+273 val_273 1
+273 val_273 2
+224 val_224 1
+224 val_224 2
+369 val_369 1
+369 val_369 2
+66 val_66 1
+66 val_66 2
+128 val_128 1
+128 val_128 2
+213 val_213 1
+213 val_213 2
+146 val_146 1
+146 val_146 2
+406 val_406 1
+406 val_406 2
+429 val_429 1
+429 val_429 2
+374 val_374 1
+374 val_374 2
+152 val_152 1
+152 val_152 2
+469 val_469 1
+469 val_469 2
+145 val_145 1
+145 val_145 2
+495 val_495 1
+495 val_495 2
+37 val_37 1
+37 val_37 2
+327 val_327 1
+327 val_327 2
+281 val_281 1
+281 val_281 2
+277 val_277 1
+277 val_277 2
+209 val_209 1
+209 val_209 2
+15 val_15 1
+15 val_15 2
+82 val_82 1
+82 val_82 2
+403 val_403 1
+403 val_403 2
+166 val_166 1
+166 val_166 2
+417 val_417 1
+417 val_417 2
+430 val_430 1
+430 val_430 2
+252 val_252 1
+252 val_252 2
+292 val_292 1
+292 val_292 2
+219 val_219 1
+219 val_219 2
+287 val_287 1
+287 val_287 2
+153 val_153 1
+153 val_153 2
+193 val_193 1
+193 val_193 2
+338 val_338 1
+338 val_338 2
+446 val_446 1
+446 val_446 2
+459 val_459 1
+459 val_459 2
+394 val_394 1
+394 val_394 2
+237 val_237 1
+237 val_237 2
+482 val_482 1
+482 val_482 2
+174 val_174 1
+174 val_174 2
+413 val_413 1
+413 val_413 2
+494 val_494 1
+494 val_494 2
+207 val_207 1
+207 val_207 2
+199 val_199 1
+199 val_199 2
+466 val_466 1
+466 val_466 2
+208 val_208 1
+208 val_208 2
+174 val_174 1
+174 val_174 2
+399 val_399 1
+399 val_399 2
+396 val_396 1
+396 val_396 2
+247 val_247 1
+247 val_247 2
+417 val_417 1
+417 val_417 2
+489 val_489 1
+489 val_489 2
+162 val_162 1
+162 val_162 2
+377 val_377 1
+377 val_377 2
+397 val_397 1
+397 val_397 2
+309 val_309 1
+309 val_309 2
+365 val_365 1
+365 val_365 2
+266 val_266 1
+266 val_266 2
+439 val_439 1
+439 val_439 2
+342 val_342 1
+342 val_342 2
+367 val_367 1
+367 val_367 2
+325 val_325 1
+325 val_325 2
+167 val_167 1
+167 val_167 2
+195 val_195 1
+195 val_195 2
+475 val_475 1
+475 val_475 2
+17 val_17 1
+17 val_17 2
+113 val_113 1
+113 val_113 2
+155 val_155 1
+155 val_155 2
+203 val_203 1
+203 val_203 2
+339 val_339 1
+339 val_339 2
+0 val_0 1
+0 val_0 2
+455 val_455 1
+455 val_455 2
+128 val_128 1
+128 val_128 2
+311 val_311 1
+311 val_311 2
+316 val_316 1
+316 val_316 2
+57 val_57 1
+57 val_57 2
+302 val_302 1
+302 val_302 2
+205 val_205 1
+205 val_205 2
+149 val_149 1
+149 val_149 2
+438 val_438 1
+438 val_438 2
+345 val_345 1
+345 val_345 2
+129 val_129 1
+129 val_129 2
+170 val_170 1
+170 val_170 2
+20 val_20 1
+20 val_20 2
+489 val_489 1
+489 val_489 2
+157 val_157 1
+157 val_157 2
+378 val_378 1
+378 val_378 2
+221 val_221 1
+221 val_221 2
+92 val_92 1
+92 val_92 2
+111 val_111 1
+111 val_111 2
+47 val_47 1
+47 val_47 2
+72 val_72 1
+72 val_72 2
+4 val_4 1
+4 val_4 2
+280 val_280 1
+280 val_280 2
+35 val_35 1
+35 val_35 2
+427 val_427 1
+427 val_427 2
+277 val_277 1
+277 val_277 2
+208 val_208 1
+208 val_208 2
+356 val_356 1
+356 val_356 2
+399 val_399 1
+399 val_399 2
+169 val_169 1
+169 val_169 2
+382 val_382 1
+382 val_382 2
+498 val_498 1
+498 val_498 2
+125 val_125 1
+125 val_125 2
+386 val_386 1
+386 val_386 2
+437 val_437 1
+437 val_437 2
+469 val_469 1
+469 val_469 2
+192 val_192 1
+192 val_192 2
+286 val_286 1
+286 val_286 2
+187 val_187 1
+187 val_187 2
+176 val_176 1
+176 val_176 2
+54 val_54 1
+54 val_54 2
+459 val_459 1
+459 val_459 2
+51 val_51 1
+51 val_51 2
+138 val_138 1
+138 val_138 2
+103 val_103 1
+103 val_103 2
+239 val_239 1
+239 val_239 2
+213 val_213 1
+213 val_213 2
+216 val_216 1
+216 val_216 2
+430 val_430 1
+430 val_430 2
+278 val_278 1
+278 val_278 2
+176 val_176 1
+176 val_176 2
+289 val_289 1
+289 val_289 2
+221 val_221 1
+221 val_221 2
+65 val_65 1
+65 val_65 2
+318 val_318 1
+318 val_318 2
+332 val_332 1
+332 val_332 2
+311 val_311 1
+311 val_311 2
+275 val_275 1
+275 val_275 2
+137 val_137 1
+137 val_137 2
+241 val_241 1
+241 val_241 2
+83 val_83 1
+83 val_83 2
+333 val_333 1
+333 val_333 2
+180 val_180 1
+180 val_180 2
+284 val_284 1
+284 val_284 2
+12 val_12 1
+12 val_12 2
+230 val_230 1
+230 val_230 2
+181 val_181 1
+181 val_181 2
+67 val_67 1
+67 val_67 2
+260 val_260 1
+260 val_260 2
+404 val_404 1
+404 val_404 2
+384 val_384 1
+384 val_384 2
+489 val_489 1
+489 val_489 2
+353 val_353 1
+353 val_353 2
+373 val_373 1
+373 val_373 2
+272 val_272 1
+272 val_272 2
+138 val_138 1
+138 val_138 2
+217 val_217 1
+217 val_217 2
+84 val_84 1
+84 val_84 2
+348 val_348 1
+348 val_348 2
+466 val_466 1
+466 val_466 2
+58 val_58 1
+58 val_58 2
+8 val_8 1
+8 val_8 2
+411 val_411 1
+411 val_411 2
+230 val_230 1
+230 val_230 2
+208 val_208 1
+208 val_208 2
+348 val_348 1
+348 val_348 2
+24 val_24 1
+24 val_24 2
+463 val_463 1
+463 val_463 2
+431 val_431 1
+431 val_431 2
+179 val_179 1
+179 val_179 2
+172 val_172 1
+172 val_172 2
+42 val_42 1
+42 val_42 2
+129 val_129 1
+129 val_129 2
+158 val_158 1
+158 val_158 2
+119 val_119 1
+119 val_119 2
+496 val_496 1
+496 val_496 2
+0 val_0 1
+0 val_0 2
+322 val_322 1
+322 val_322 2
+197 val_197 1
+197 val_197 2
+468 val_468 1
+468 val_468 2
+393 val_393 1
+393 val_393 2
+454 val_454 1
+454 val_454 2
+100 val_100 1
+100 val_100 2
+298 val_298 1
+298 val_298 2
+199 val_199 1
+199 val_199 2
+191 val_191 1
+191 val_191 2
+418 val_418 1
+418 val_418 2
+96 val_96 1
+96 val_96 2
+26 val_26 1
+26 val_26 2
+165 val_165 1
+165 val_165 2
+327 val_327 1
+327 val_327 2
+230 val_230 1
+230 val_230 2
+205 val_205 1
+205 val_205 2
+120 val_120 1
+120 val_120 2
+131 val_131 1
+131 val_131 2
+51 val_51 1
+51 val_51 2
+404 val_404 1
+404 val_404 2
+43 val_43 1
+43 val_43 2
+436 val_436 1
+436 val_436 2
+156 val_156 1
+156 val_156 2
+469 val_469 1
+469 val_469 2
+468 val_468 1
+468 val_468 2
+308 val_308 1
+308 val_308 2
+95 val_95 1
+95 val_95 2
+196 val_196 1
+196 val_196 2
+288 val_288 1
+288 val_288 2
+481 val_481 1
+481 val_481 2
+457 val_457 1
+457 val_457 2
+98 val_98 1
+98 val_98 2
+282 val_282 1
+282 val_282 2
+197 val_197 1
+197 val_197 2
+187 val_187 1
+187 val_187 2
+318 val_318 1
+318 val_318 2
+318 val_318 1
+318 val_318 2
+409 val_409 1
+409 val_409 2
+470 val_470 1
+470 val_470 2
+137 val_137 1
+137 val_137 2
+369 val_369 1
+369 val_369 2
+316 val_316 1
+316 val_316 2
+169 val_169 1
+169 val_169 2
+413 val_413 1
+413 val_413 2
+85 val_85 1
+85 val_85 2
+77 val_77 1
+77 val_77 2
+0 val_0 1
+0 val_0 2
+490 val_490 1
+490 val_490 2
+87 val_87 1
+87 val_87 2
+364 val_364 1
+364 val_364 2
+179 val_179 1
+179 val_179 2
+118 val_118 1
+118 val_118 2
+134 val_134 1
+134 val_134 2
+395 val_395 1
+395 val_395 2
+282 val_282 1
+282 val_282 2
+138 val_138 1
+138 val_138 2
+238 val_238 1
+238 val_238 2
+419 val_419 1
+419 val_419 2
+15 val_15 1
+15 val_15 2
+118 val_118 1
+118 val_118 2
+72 val_72 1
+72 val_72 2
+90 val_90 1
+90 val_90 2
+307 val_307 1
+307 val_307 2
+19 val_19 1
+19 val_19 2
+435 val_435 1
+435 val_435 2
+10 val_10 1
+10 val_10 2
+277 val_277 1
+277 val_277 2
+273 val_273 1
+273 val_273 2
+306 val_306 1
+306 val_306 2
+224 val_224 1
+224 val_224 2
+309 val_309 1
+309 val_309 2
+389 val_389 1
+389 val_389 2
+327 val_327 1
+327 val_327 2
+242 val_242 1
+242 val_242 2
+369 val_369 1
+369 val_369 2
+392 val_392 1
+392 val_392 2
+272 val_272 1
+272 val_272 2
+331 val_331 1
+331 val_331 2
+401 val_401 1
+401 val_401 2
+242 val_242 1
+242 val_242 2
+452 val_452 1
+452 val_452 2
+177 val_177 1
+177 val_177 2
+226 val_226 1
+226 val_226 2
+5 val_5 1
+5 val_5 2
+497 val_497 1
+497 val_497 2
+402 val_402 1
+402 val_402 2
+396 val_396 1
+396 val_396 2
+317 val_317 1
+317 val_317 2
+395 val_395 1
+395 val_395 2
+58 val_58 1
+58 val_58 2
+35 val_35 1
+35 val_35 2
+336 val_336 1
+336 val_336 2
+95 val_95 1
+95 val_95 2
+11 val_11 1
+11 val_11 2
+168 val_168 1
+168 val_168 2
+34 val_34 1
+34 val_34 2
+229 val_229 1
+229 val_229 2
+233 val_233 1
+233 val_233 2
+143 val_143 1
+143 val_143 2
+472 val_472 1
+472 val_472 2
+322 val_322 1
+322 val_322 2
+498 val_498 1
+498 val_498 2
+160 val_160 1
+160 val_160 2
+195 val_195 1
+195 val_195 2
+42 val_42 1
+42 val_42 2
+321 val_321 1
+321 val_321 2
+430 val_430 1
+430 val_430 2
+119 val_119 1
+119 val_119 2
+489 val_489 1
+489 val_489 2
+458 val_458 1
+458 val_458 2
+78 val_78 1
+78 val_78 2
+76 val_76 1
+76 val_76 2
+41 val_41 1
+41 val_41 2
+223 val_223 1
+223 val_223 2
+492 val_492 1
+492 val_492 2
+149 val_149 1
+149 val_149 2
+449 val_449 1
+449 val_449 2
+218 val_218 1
+218 val_218 2
+228 val_228 1
+228 val_228 2
+138 val_138 1
+138 val_138 2
+453 val_453 1
+453 val_453 2
+30 val_30 1
+30 val_30 2
+209 val_209 1
+209 val_209 2
+64 val_64 1
+64 val_64 2
+468 val_468 1
+468 val_468 2
+76 val_76 1
+76 val_76 2
+74 val_74 1
+74 val_74 2
+342 val_342 1
+342 val_342 2
+69 val_69 1
+69 val_69 2
+230 val_230 1
+230 val_230 2
+33 val_33 1
+33 val_33 2
+368 val_368 1
+368 val_368 2
+103 val_103 1
+103 val_103 2
+296 val_296 1
+296 val_296 2
+113 val_113 1
+113 val_113 2
+216 val_216 1
+216 val_216 2
+367 val_367 1
+367 val_367 2
+344 val_344 1
+344 val_344 2
+167 val_167 1
+167 val_167 2
+274 val_274 1
+274 val_274 2
+219 val_219 1
+219 val_219 2
+239 val_239 1
+239 val_239 2
+485 val_485 1
+485 val_485 2
+116 val_116 1
+116 val_116 2
+223 val_223 1
+223 val_223 2
+256 val_256 1
+256 val_256 2
+263 val_263 1
+263 val_263 2
+70 val_70 1
+70 val_70 2
+487 val_487 1
+487 val_487 2
+480 val_480 1
+480 val_480 2
+401 val_401 1
+401 val_401 2
+288 val_288 1
+288 val_288 2
+191 val_191 1
+191 val_191 2
+5 val_5 1
+5 val_5 2
+244 val_244 1
+244 val_244 2
+438 val_438 1
+438 val_438 2
+128 val_128 1
+128 val_128 2
+467 val_467 1
+467 val_467 2
+432 val_432 1
+432 val_432 2
+202 val_202 1
+202 val_202 2
+316 val_316 1
+316 val_316 2
+229 val_229 1
+229 val_229 2
+469 val_469 1
+469 val_469 2
+463 val_463 1
+463 val_463 2
+280 val_280 1
+280 val_280 2
+2 val_2 1
+2 val_2 2
+35 val_35 1
+35 val_35 2
+283 val_283 1
+283 val_283 2
+331 val_331 1
+331 val_331 2
+235 val_235 1
+235 val_235 2
+80 val_80 1
+80 val_80 2
+44 val_44 1
+44 val_44 2
+193 val_193 1
+193 val_193 2
+321 val_321 1
+321 val_321 2
+335 val_335 1
+335 val_335 2
+104 val_104 1
+104 val_104 2
+466 val_466 1
+466 val_466 2
+366 val_366 1
+366 val_366 2
+175 val_175 1
+175 val_175 2
+403 val_403 1
+403 val_403 2
+483 val_483 1
+483 val_483 2
+53 val_53 1
+53 val_53 2
+105 val_105 1
+105 val_105 2
+257 val_257 1
+257 val_257 2
+406 val_406 1
+406 val_406 2
+409 val_409 1
+409 val_409 2
+190 val_190 1
+190 val_190 2
+406 val_406 1
+406 val_406 2
+401 val_401 1
+401 val_401 2
+114 val_114 1
+114 val_114 2
+258 val_258 1
+258 val_258 2
+90 val_90 1
+90 val_90 2
+203 val_203 1
+203 val_203 2
+262 val_262 1
+262 val_262 2
+348 val_348 1
+348 val_348 2
+424 val_424 1
+424 val_424 2
+12 val_12 1
+12 val_12 2
+396 val_396 1
+396 val_396 2
+201 val_201 1
+201 val_201 2
+217 val_217 1
+217 val_217 2
+164 val_164 1
+164 val_164 2
+431 val_431 1
+431 val_431 2
+454 val_454 1
+454 val_454 2
+478 val_478 1
+478 val_478 2
+298 val_298 1
+298 val_298 2
+125 val_125 1
+125 val_125 2
+431 val_431 1
+431 val_431 2
+164 val_164 1
+164 val_164 2
+424 val_424 1
+424 val_424 2
+187 val_187 1
+187 val_187 2
+382 val_382 1
+382 val_382 2
+5 val_5 1
+5 val_5 2
+70 val_70 1
+70 val_70 2
+397 val_397 1
+397 val_397 2
+480 val_480 1
+480 val_480 2
+291 val_291 1
+291 val_291 2
+24 val_24 1
+24 val_24 2
+351 val_351 1
+351 val_351 2
+255 val_255 1
+255 val_255 2
+104 val_104 1
+104 val_104 2
+70 val_70 1
+70 val_70 2
+163 val_163 1
+163 val_163 2
+438 val_438 1
+438 val_438 2
+119 val_119 1
+119 val_119 2
+414 val_414 1
+414 val_414 2
+200 val_200 1
+200 val_200 2
+491 val_491 1
+491 val_491 2
+237 val_237 1
+237 val_237 2
+439 val_439 1
+439 val_439 2
+360 val_360 1
+360 val_360 2
+248 val_248 1
+248 val_248 2
+479 val_479 1
+479 val_479 2
+305 val_305 1
+305 val_305 2
+417 val_417 1
+417 val_417 2
+199 val_199 1
+199 val_199 2
+444 val_444 1
+444 val_444 2
+120 val_120 1
+120 val_120 2
+429 val_429 1
+429 val_429 2
+169 val_169 1
+169 val_169 2
+443 val_443 1
+443 val_443 2
+323 val_323 1
+323 val_323 2
+325 val_325 1
+325 val_325 2
+277 val_277 1
+277 val_277 2
+230 val_230 1
+230 val_230 2
+478 val_478 1
+478 val_478 2
+178 val_178 1
+178 val_178 2
+468 val_468 1
+468 val_468 2
+310 val_310 1
+310 val_310 2
+317 val_317 1
+317 val_317 2
+333 val_333 1
+333 val_333 2
+493 val_493 1
+493 val_493 2
+460 val_460 1
+460 val_460 2
+207 val_207 1
+207 val_207 2
+249 val_249 1
+249 val_249 2
+265 val_265 1
+265 val_265 2
+480 val_480 1
+480 val_480 2
+83 val_83 1
+83 val_83 2
+136 val_136 1
+136 val_136 2
+353 val_353 1
+353 val_353 2
+172 val_172 1
+172 val_172 2
+214 val_214 1
+214 val_214 2
+462 val_462 1
+462 val_462 2
+233 val_233 1
+233 val_233 2
+406 val_406 1
+406 val_406 2
+133 val_133 1
+133 val_133 2
+175 val_175 1
+175 val_175 2
+189 val_189 1
+189 val_189 2
+454 val_454 1
+454 val_454 2
+375 val_375 1
+375 val_375 2
+401 val_401 1
+401 val_401 2
+421 val_421 1
+421 val_421 2
+407 val_407 1
+407 val_407 2
+384 val_384 1
+384 val_384 2
+256 val_256 1
+256 val_256 2
+26 val_26 1
+26 val_26 2
+134 val_134 1
+134 val_134 2
+67 val_67 1
+67 val_67 2
+384 val_384 1
+384 val_384 2
+379 val_379 1
+379 val_379 2
+18 val_18 1
+18 val_18 2
+462 val_462 1
+462 val_462 2
+492 val_492 1
+492 val_492 2
+100 val_100 1
+100 val_100 2
+298 val_298 1
+298 val_298 2
+9 val_9 1
+9 val_9 2
+341 val_341 1
+341 val_341 2
+498 val_498 1
+498 val_498 2
+146 val_146 1
+146 val_146 2
+458 val_458 1
+458 val_458 2
+362 val_362 1
+362 val_362 2
+186 val_186 1
+186 val_186 2
+285 val_285 1
+285 val_285 2
+348 val_348 1
+348 val_348 2
+167 val_167 1
+167 val_167 2
+18 val_18 1
+18 val_18 2
+273 val_273 1
+273 val_273 2
+183 val_183 1
+183 val_183 2
+281 val_281 1
+281 val_281 2
+344 val_344 1
+344 val_344 2
+97 val_97 1
+97 val_97 2
+469 val_469 1
+469 val_469 2
+315 val_315 1
+315 val_315 2
+84 val_84 1
+84 val_84 2
+28 val_28 1
+28 val_28 2
+37 val_37 1
+37 val_37 2
+448 val_448 1
+448 val_448 2
+152 val_152 1
+152 val_152 2
+348 val_348 1
+348 val_348 2
+307 val_307 1
+307 val_307 2
+194 val_194 1
+194 val_194 2
+414 val_414 1
+414 val_414 2
+477 val_477 1
+477 val_477 2
+222 val_222 1
+222 val_222 2
+126 val_126 1
+126 val_126 2
+90 val_90 1
+90 val_90 2
+169 val_169 1
+169 val_169 2
+403 val_403 1
+403 val_403 2
+400 val_400 1
+400 val_400 2
+200 val_200 1
+200 val_200 2
+97 val_97 1
+97 val_97 2
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view3-0-55b6de1dbad92682804e98524c0d6c12
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view3-0-55b6de1dbad92682804e98524c0d6c12 b/sql/hive/src/test/resources/golden/lateral view3-0-55b6de1dbad92682804e98524c0d6c12
new file mode 100644
index 0000000..8216956
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral view3-0-55b6de1dbad92682804e98524c0d6c12
@@ -0,0 +1,1000 @@
+238 241
+238 242
+86 89
+86 90
+311 314
+311 315
+27 30
+27 31
+165 168
+165 169
+409 412
+409 413
+255 258
+255 259
+278 281
+278 282
+98 101
+98 102
+484 487
+484 488
+265 268
+265 269
+193 196
+193 197
+401 404
+401 405
+150 153
+150 154
+273 276
+273 277
+224 227
+224 228
+369 372
+369 373
+66 69
+66 70
+128 131
+128 132
+213 216
+213 217
+146 149
+146 150
+406 409
+406 410
+429 432
+429 433
+374 377
+374 378
+152 155
+152 156
+469 472
+469 473
+145 148
+145 149
+495 498
+495 499
+37 40
+37 41
+327 330
+327 331
+281 284
+281 285
+277 280
+277 281
+209 212
+209 213
+15 18
+15 19
+82 85
+82 86
+403 406
+403 407
+166 169
+166 170
+417 420
+417 421
+430 433
+430 434
+252 255
+252 256
+292 295
+292 296
+219 222
+219 223
+287 290
+287 291
+153 156
+153 157
+193 196
+193 197
+338 341
+338 342
+446 449
+446 450
+459 462
+459 463
+394 397
+394 398
+237 240
+237 241
+482 485
+482 486
+174 177
+174 178
+413 416
+413 417
+494 497
+494 498
+207 210
+207 211
+199 202
+199 203
+466 469
+466 470
+208 211
+208 212
+174 177
+174 178
+399 402
+399 403
+396 399
+396 400
+247 250
+247 251
+417 420
+417 421
+489 492
+489 493
+162 165
+162 166
+377 380
+377 381
+397 400
+397 401
+309 312
+309 313
+365 368
+365 369
+266 269
+266 270
+439 442
+439 443
+342 345
+342 346
+367 370
+367 371
+325 328
+325 329
+167 170
+167 171
+195 198
+195 199
+475 478
+475 479
+17 20
+17 21
+113 116
+113 117
+155 158
+155 159
+203 206
+203 207
+339 342
+339 343
+0 3
+0 4
+455 458
+455 459
+128 131
+128 132
+311 314
+311 315
+316 319
+316 320
+57 60
+57 61
+302 305
+302 306
+205 208
+205 209
+149 152
+149 153
+438 441
+438 442
+345 348
+345 349
+129 132
+129 133
+170 173
+170 174
+20 23
+20 24
+489 492
+489 493
+157 160
+157 161
+378 381
+378 382
+221 224
+221 225
+92 95
+92 96
+111 114
+111 115
+47 50
+47 51
+72 75
+72 76
+4 7
+4 8
+280 283
+280 284
+35 38
+35 39
+427 430
+427 431
+277 280
+277 281
+208 211
+208 212
+356 359
+356 360
+399 402
+399 403
+169 172
+169 173
+382 385
+382 386
+498 501
+498 502
+125 128
+125 129
+386 389
+386 390
+437 440
+437 441
+469 472
+469 473
+192 195
+192 196
+286 289
+286 290
+187 190
+187 191
+176 179
+176 180
+54 57
+54 58
+459 462
+459 463
+51 54
+51 55
+138 141
+138 142
+103 106
+103 107
+239 242
+239 243
+213 216
+213 217
+216 219
+216 220
+430 433
+430 434
+278 281
+278 282
+176 179
+176 180
+289 292
+289 293
+221 224
+221 225
+65 68
+65 69
+318 321
+318 322
+332 335
+332 336
+311 314
+311 315
+275 278
+275 279
+137 140
+137 141
+241 244
+241 245
+83 86
+83 87
+333 336
+333 337
+180 183
+180 184
+284 287
+284 288
+12 15
+12 16
+230 233
+230 234
+181 184
+181 185
+67 70
+67 71
+260 263
+260 264
+404 407
+404 408
+384 387
+384 388
+489 492
+489 493
+353 356
+353 357
+373 376
+373 377
+272 275
+272 276
+138 141
+138 142
+217 220
+217 221
+84 87
+84 88
+348 351
+348 352
+466 469
+466 470
+58 61
+58 62
+8 11
+8 12
+411 414
+411 415
+230 233
+230 234
+208 211
+208 212
+348 351
+348 352
+24 27
+24 28
+463 466
+463 467
+431 434
+431 435
+179 182
+179 183
+172 175
+172 176
+42 45
+42 46
+129 132
+129 133
+158 161
+158 162
+119 122
+119 123
+496 499
+496 500
+0 3
+0 4
+322 325
+322 326
+197 200
+197 201
+468 471
+468 472
+393 396
+393 397
+454 457
+454 458
+100 103
+100 104
+298 301
+298 302
+199 202
+199 203
+191 194
+191 195
+418 421
+418 422
+96 99
+96 100
+26 29
+26 30
+165 168
+165 169
+327 330
+327 331
+230 233
+230 234
+205 208
+205 209
+120 123
+120 124
+131 134
+131 135
+51 54
+51 55
+404 407
+404 408
+43 46
+43 47
+436 439
+436 440
+156 159
+156 160
+469 472
+469 473
+468 471
+468 472
+308 311
+308 312
+95 98
+95 99
+196 199
+196 200
+288 291
+288 292
+481 484
+481 485
+457 460
+457 461
+98 101
+98 102
+282 285
+282 286
+197 200
+197 201
+187 190
+187 191
+318 321
+318 322
+318 321
+318 322
+409 412
+409 413
+470 473
+470 474
+137 140
+137 141
+369 372
+369 373
+316 319
+316 320
+169 172
+169 173
+413 416
+413 417
+85 88
+85 89
+77 80
+77 81
+0 3
+0 4
+490 493
+490 494
+87 90
+87 91
+364 367
+364 368
+179 182
+179 183
+118 121
+118 122
+134 137
+134 138
+395 398
+395 399
+282 285
+282 286
+138 141
+138 142
+238 241
+238 242
+419 422
+419 423
+15 18
+15 19
+118 121
+118 122
+72 75
+72 76
+90 93
+90 94
+307 310
+307 311
+19 22
+19 23
+435 438
+435 439
+10 13
+10 14
+277 280
+277 281
+273 276
+273 277
+306 309
+306 310
+224 227
+224 228
+309 312
+309 313
+389 392
+389 393
+327 330
+327 331
+242 245
+242 246
+369 372
+369 373
+392 395
+392 396
+272 275
+272 276
+331 334
+331 335
+401 404
+401 405
+242 245
+242 246
+452 455
+452 456
+177 180
+177 181
+226 229
+226 230
+5 8
+5 9
+497 500
+497 501
+402 405
+402 406
+396 399
+396 400
+317 320
+317 321
+395 398
+395 399
+58 61
+58 62
+35 38
+35 39
+336 339
+336 340
+95 98
+95 99
+11 14
+11 15
+168 171
+168 172
+34 37
+34 38
+229 232
+229 233
+233 236
+233 237
+143 146
+143 147
+472 475
+472 476
+322 325
+322 326
+498 501
+498 502
+160 163
+160 164
+195 198
+195 199
+42 45
+42 46
+321 324
+321 325
+430 433
+430 434
+119 122
+119 123
+489 492
+489 493
+458 461
+458 462
+78 81
+78 82
+76 79
+76 80
+41 44
+41 45
+223 226
+223 227
+492 495
+492 496
+149 152
+149 153
+449 452
+449 453
+218 221
+218 222
+228 231
+228 232
+138 141
+138 142
+453 456
+453 457
+30 33
+30 34
+209 212
+209 213
+64 67
+64 68
+468 471
+468 472
+76 79
+76 80
+74 77
+74 78
+342 345
+342 346
+69 72
+69 73
+230 233
+230 234
+33 36
+33 37
+368 371
+368 372
+103 106
+103 107
+296 299
+296 300
+113 116
+113 117
+216 219
+216 220
+367 370
+367 371
+344 347
+344 348
+167 170
+167 171
+274 277
+274 278
+219 222
+219 223
+239 242
+239 243
+485 488
+485 489
+116 119
+116 120
+223 226
+223 227
+256 259
+256 260
+263 266
+263 267
+70 73
+70 74
+487 490
+487 491
+480 483
+480 484
+401 404
+401 405
+288 291
+288 292
+191 194
+191 195
+5 8
+5 9
+244 247
+244 248
+438 441
+438 442
+128 131
+128 132
+467 470
+467 471
+432 435
+432 436
+202 205
+202 206
+316 319
+316 320
+229 232
+229 233
+469 472
+469 473
+463 466
+463 467
+280 283
+280 284
+2 5
+2 6
+35 38
+35 39
+283 286
+283 287
+331 334
+331 335
+235 238
+235 239
+80 83
+80 84
+44 47
+44 48
+193 196
+193 197
+321 324
+321 325
+335 338
+335 339
+104 107
+104 108
+466 469
+466 470
+366 369
+366 370
+175 178
+175 179
+403 406
+403 407
+483 486
+483 487
+53 56
+53 57
+105 108
+105 109
+257 260
+257 261
+406 409
+406 410
+409 412
+409 413
+190 193
+190 194
+406 409
+406 410
+401 404
+401 405
+114 117
+114 118
+258 261
+258 262
+90 93
+90 94
+203 206
+203 207
+262 265
+262 266
+348 351
+348 352
+424 427
+424 428
+12 15
+12 16
+396 399
+396 400
+201 204
+201 205
+217 220
+217 221
+164 167
+164 168
+431 434
+431 435
+454 457
+454 458
+478 481
+478 482
+298 301
+298 302
+125 128
+125 129
+431 434
+431 435
+164 167
+164 168
+424 427
+424 428
+187 190
+187 191
+382 385
+382 386
+5 8
+5 9
+70 73
+70 74
+397 400
+397 401
+480 483
+480 484
+291 294
+291 295
+24 27
+24 28
+351 354
+351 355
+255 258
+255 259
+104 107
+104 108
+70 73
+70 74
+163 166
+163 167
+438 441
+438 442
+119 122
+119 123
+414 417
+414 418
+200 203
+200 204
+491 494
+491 495
+237 240
+237 241
+439 442
+439 443
+360 363
+360 364
+248 251
+248 252
+479 482
+479 483
+305 308
+305 309
+417 420
+417 421
+199 202
+199 203
+444 447
+444 448
+120 123
+120 124
+429 432
+429 433
+169 172
+169 173
+443 446
+443 447
+323 326
+323 327
+325 328
+325 329
+277 280
+277 281
+230 233
+230 234
+478 481
+478 482
+178 181
+178 182
+468 471
+468 472
+310 313
+310 314
+317 320
+317 321
+333 336
+333 337
+493 496
+493 497
+460 463
+460 464
+207 210
+207 211
+249 252
+249 253
+265 268
+265 269
+480 483
+480 484
+83 86
+83 87
+136 139
+136 140
+353 356
+353 357
+172 175
+172 176
+214 217
+214 218
+462 465
+462 466
+233 236
+233 237
+406 409
+406 410
+133 136
+133 137
+175 178
+175 179
+189 192
+189 193
+454 457
+454 458
+375 378
+375 379
+401 404
+401 405
+421 424
+421 425
+407 410
+407 411
+384 387
+384 388
+256 259
+256 260
+26 29
+26 30
+134 137
+134 138
+67 70
+67 71
+384 387
+384 388
+379 382
+379 383
+18 21
+18 22
+462 465
+462 466
+492 495
+492 496
+100 103
+100 104
+298 301
+298 302
+9 12
+9 13
+341 344
+341 345
+498 501
+498 502
+146 149
+146 150
+458 461
+458 462
+362 365
+362 366
+186 189
+186 190
+285 288
+285 289
+348 351
+348 352
+167 170
+167 171
+18 21
+18 22
+273 276
+273 277
+183 186
+183 187
+281 284
+281 285
+344 347
+344 348
+97 100
+97 101
+469 472
+469 473
+315 318
+315 319
+84 87
+84 88
+28 31
+28 32
+37 40
+37 41
+448 451
+448 452
+152 155
+152 156
+348 351
+348 352
+307 310
+307 311
+194 197
+194 198
+414 417
+414 418
+477 480
+477 481
+222 225
+222 226
+126 129
+126 130
+90 93
+90 94
+169 172
+169 173
+403 406
+403 407
+400 403
+400 404
+200 203
+200 204
+97 100
+97 101
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view4-0-3ed6bfa23add415990b443fc232b4ba0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view4-0-3ed6bfa23add415990b443fc232b4ba0 b/sql/hive/src/test/resources/golden/lateral view4-0-3ed6bfa23add415990b443fc232b4ba0
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view4-1-6ced0ab5d543a2c5c6c7f7e27ed04814
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view4-1-6ced0ab5d543a2c5c6c7f7e27ed04814 b/sql/hive/src/test/resources/golden/lateral view4-1-6ced0ab5d543a2c5c6c7f7e27ed04814
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view4-2-ed9961425eee97a5f35c5b6e69dc368e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view4-2-ed9961425eee97a5f35c5b6e69dc368e b/sql/hive/src/test/resources/golden/lateral view4-2-ed9961425eee97a5f35c5b6e69dc368e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view5-0-f797cf9d04a98cfe477d14703aeb294b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view5-0-f797cf9d04a98cfe477d14703aeb294b b/sql/hive/src/test/resources/golden/lateral view5-0-f797cf9d04a98cfe477d14703aeb294b
new file mode 100644
index 0000000..4895558
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral view5-0-f797cf9d04a98cfe477d14703aeb294b
@@ -0,0 +1,1000 @@
+241
+242
+89
+90
+314
+315
+30
+31
+168
+169
+412
+413
+258
+259
+281
+282
+101
+102
+487
+488
+268
+269
+196
+197
+404
+405
+153
+154
+276
+277
+227
+228
+372
+373
+69
+70
+131
+132
+216
+217
+149
+150
+409
+410
+432
+433
+377
+378
+155
+156
+472
+473
+148
+149
+498
+499
+40
+41
+330
+331
+284
+285
+280
+281
+212
+213
+18
+19
+85
+86
+406
+407
+169
+170
+420
+421
+433
+434
+255
+256
+295
+296
+222
+223
+290
+291
+156
+157
+196
+197
+341
+342
+449
+450
+462
+463
+397
+398
+240
+241
+485
+486
+177
+178
+416
+417
+497
+498
+210
+211
+202
+203
+469
+470
+211
+212
+177
+178
+402
+403
+399
+400
+250
+251
+420
+421
+492
+493
+165
+166
+380
+381
+400
+401
+312
+313
+368
+369
+269
+270
+442
+443
+345
+346
+370
+371
+328
+329
+170
+171
+198
+199
+478
+479
+20
+21
+116
+117
+158
+159
+206
+207
+342
+343
+3
+4
+458
+459
+131
+132
+314
+315
+319
+320
+60
+61
+305
+306
+208
+209
+152
+153
+441
+442
+348
+349
+132
+133
+173
+174
+23
+24
+492
+493
+160
+161
+381
+382
+224
+225
+95
+96
+114
+115
+50
+51
+75
+76
+7
+8
+283
+284
+38
+39
+430
+431
+280
+281
+211
+212
+359
+360
+402
+403
+172
+173
+385
+386
+501
+502
+128
+129
+389
+390
+440
+441
+472
+473
+195
+196
+289
+290
+190
+191
+179
+180
+57
+58
+462
+463
+54
+55
+141
+142
+106
+107
+242
+243
+216
+217
+219
+220
+433
+434
+281
+282
+179
+180
+292
+293
+224
+225
+68
+69
+321
+322
+335
+336
+314
+315
+278
+279
+140
+141
+244
+245
+86
+87
+336
+337
+183
+184
+287
+288
+15
+16
+233
+234
+184
+185
+70
+71
+263
+264
+407
+408
+387
+388
+492
+493
+356
+357
+376
+377
+275
+276
+141
+142
+220
+221
+87
+88
+351
+352
+469
+470
+61
+62
+11
+12
+414
+415
+233
+234
+211
+212
+351
+352
+27
+28
+466
+467
+434
+435
+182
+183
+175
+176
+45
+46
+132
+133
+161
+162
+122
+123
+499
+500
+3
+4
+325
+326
+200
+201
+471
+472
+396
+397
+457
+458
+103
+104
+301
+302
+202
+203
+194
+195
+421
+422
+99
+100
+29
+30
+168
+169
+330
+331
+233
+234
+208
+209
+123
+124
+134
+135
+54
+55
+407
+408
+46
+47
+439
+440
+159
+160
+472
+473
+471
+472
+311
+312
+98
+99
+199
+200
+291
+292
+484
+485
+460
+461
+101
+102
+285
+286
+200
+201
+190
+191
+321
+322
+321
+322
+412
+413
+473
+474
+140
+141
+372
+373
+319
+320
+172
+173
+416
+417
+88
+89
+80
+81
+3
+4
+493
+494
+90
+91
+367
+368
+182
+183
+121
+122
+137
+138
+398
+399
+285
+286
+141
+142
+241
+242
+422
+423
+18
+19
+121
+122
+75
+76
+93
+94
+310
+311
+22
+23
+438
+439
+13
+14
+280
+281
+276
+277
+309
+310
+227
+228
+312
+313
+392
+393
+330
+331
+245
+246
+372
+373
+395
+396
+275
+276
+334
+335
+404
+405
+245
+246
+455
+456
+180
+181
+229
+230
+8
+9
+500
+501
+405
+406
+399
+400
+320
+321
+398
+399
+61
+62
+38
+39
+339
+340
+98
+99
+14
+15
+171
+172
+37
+38
+232
+233
+236
+237
+146
+147
+475
+476
+325
+326
+501
+502
+163
+164
+198
+199
+45
+46
+324
+325
+433
+434
+122
+123
+492
+493
+461
+462
+81
+82
+79
+80
+44
+45
+226
+227
+495
+496
+152
+153
+452
+453
+221
+222
+231
+232
+141
+142
+456
+457
+33
+34
+212
+213
+67
+68
+471
+472
+79
+80
+77
+78
+345
+346
+72
+73
+233
+234
+36
+37
+371
+372
+106
+107
+299
+300
+116
+117
+219
+220
+370
+371
+347
+348
+170
+171
+277
+278
+222
+223
+242
+243
+488
+489
+119
+120
+226
+227
+259
+260
+266
+267
+73
+74
+490
+491
+483
+484
+404
+405
+291
+292
+194
+195
+8
+9
+247
+248
+441
+442
+131
+132
+470
+471
+435
+436
+205
+206
+319
+320
+232
+233
+472
+473
+466
+467
+283
+284
+5
+6
+38
+39
+286
+287
+334
+335
+238
+239
+83
+84
+47
+48
+196
+197
+324
+325
+338
+339
+107
+108
+469
+470
+369
+370
+178
+179
+406
+407
+486
+487
+56
+57
+108
+109
+260
+261
+409
+410
+412
+413
+193
+194
+409
+410
+404
+405
+117
+118
+261
+262
+93
+94
+206
+207
+265
+266
+351
+352
+427
+428
+15
+16
+399
+400
+204
+205
+220
+221
+167
+168
+434
+435
+457
+458
+481
+482
+301
+302
+128
+129
+434
+435
+167
+168
+427
+428
+190
+191
+385
+386
+8
+9
+73
+74
+400
+401
+483
+484
+294
+295
+27
+28
+354
+355
+258
+259
+107
+108
+73
+74
+166
+167
+441
+442
+122
+123
+417
+418
+203
+204
+494
+495
+240
+241
+442
+443
+363
+364
+251
+252
+482
+483
+308
+309
+420
+421
+202
+203
+447
+448
+123
+124
+432
+433
+172
+173
+446
+447
+326
+327
+328
+329
+280
+281
+233
+234
+481
+482
+181
+182
+471
+472
+313
+314
+320
+321
+336
+337
+496
+497
+463
+464
+210
+211
+252
+253
+268
+269
+483
+484
+86
+87
+139
+140
+356
+357
+175
+176
+217
+218
+465
+466
+236
+237
+409
+410
+136
+137
+178
+179
+192
+193
+457
+458
+378
+379
+404
+405
+424
+425
+410
+411
+387
+388
+259
+260
+29
+30
+137
+138
+70
+71
+387
+388
+382
+383
+21
+22
+465
+466
+495
+496
+103
+104
+301
+302
+12
+13
+344
+345
+501
+502
+149
+150
+461
+462
+365
+366
+189
+190
+288
+289
+351
+352
+170
+171
+21
+22
+276
+277
+186
+187
+284
+285
+347
+348
+100
+101
+472
+473
+318
+319
+87
+88
+31
+32
+40
+41
+451
+452
+155
+156
+351
+352
+310
+311
+197
+198
+417
+418
+480
+481
+225
+226
+129
+130
+93
+94
+172
+173
+406
+407
+403
+404
+203
+204
+100
+101
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral view6-0-f92fe6429a6630d4991f8ad76ff1d79a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral view6-0-f92fe6429a6630d4991f8ad76ff1d79a b/sql/hive/src/test/resources/golden/lateral view6-0-f92fe6429a6630d4991f8ad76ff1d79a
new file mode 100644
index 0000000..269df08
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral view6-0-f92fe6429a6630d4991f8ad76ff1d79a
@@ -0,0 +1,500 @@
+238 val_238 241 242
+86 val_86 89 90
+311 val_311 314 315
+27 val_27 30 31
+165 val_165 168 169
+409 val_409 412 413
+255 val_255 258 259
+278 val_278 281 282
+98 val_98 101 102
+484 val_484 487 488
+265 val_265 268 269
+193 val_193 196 197
+401 val_401 404 405
+150 val_150 153 154
+273 val_273 276 277
+224 val_224 227 228
+369 val_369 372 373
+66 val_66 69 70
+128 val_128 131 132
+213 val_213 216 217
+146 val_146 149 150
+406 val_406 409 410
+429 val_429 432 433
+374 val_374 377 378
+152 val_152 155 156
+469 val_469 472 473
+145 val_145 148 149
+495 val_495 498 499
+37 val_37 40 41
+327 val_327 330 331
+281 val_281 284 285
+277 val_277 280 281
+209 val_209 212 213
+15 val_15 18 19
+82 val_82 85 86
+403 val_403 406 407
+166 val_166 169 170
+417 val_417 420 421
+430 val_430 433 434
+252 val_252 255 256
+292 val_292 295 296
+219 val_219 222 223
+287 val_287 290 291
+153 val_153 156 157
+193 val_193 196 197
+338 val_338 341 342
+446 val_446 449 450
+459 val_459 462 463
+394 val_394 397 398
+237 val_237 240 241
+482 val_482 485 486
+174 val_174 177 178
+413 val_413 416 417
+494 val_494 497 498
+207 val_207 210 211
+199 val_199 202 203
+466 val_466 469 470
+208 val_208 211 212
+174 val_174 177 178
+399 val_399 402 403
+396 val_396 399 400
+247 val_247 250 251
+417 val_417 420 421
+489 val_489 492 493
+162 val_162 165 166
+377 val_377 380 381
+397 val_397 400 401
+309 val_309 312 313
+365 val_365 368 369
+266 val_266 269 270
+439 val_439 442 443
+342 val_342 345 346
+367 val_367 370 371
+325 val_325 328 329
+167 val_167 170 171
+195 val_195 198 199
+475 val_475 478 479
+17 val_17 20 21
+113 val_113 116 117
+155 val_155 158 159
+203 val_203 206 207
+339 val_339 342 343
+0 val_0 3 4
+455 val_455 458 459
+128 val_128 131 132
+311 val_311 314 315
+316 val_316 319 320
+57 val_57 60 61
+302 val_302 305 306
+205 val_205 208 209
+149 val_149 152 153
+438 val_438 441 442
+345 val_345 348 349
+129 val_129 132 133
+170 val_170 173 174
+20 val_20 23 24
+489 val_489 492 493
+157 val_157 160 161
+378 val_378 381 382
+221 val_221 224 225
+92 val_92 95 96
+111 val_111 114 115
+47 val_47 50 51
+72 val_72 75 76
+4 val_4 7 8
+280 val_280 283 284
+35 val_35 38 39
+427 val_427 430 431
+277 val_277 280 281
+208 val_208 211 212
+356 val_356 359 360
+399 val_399 402 403
+169 val_169 172 173
+382 val_382 385 386
+498 val_498 501 502
+125 val_125 128 129
+386 val_386 389 390
+437 val_437 440 441
+469 val_469 472 473
+192 val_192 195 196
+286 val_286 289 290
+187 val_187 190 191
+176 val_176 179 180
+54 val_54 57 58
+459 val_459 462 463
+51 val_51 54 55
+138 val_138 141 142
+103 val_103 106 107
+239 val_239 242 243
+213 val_213 216 217
+216 val_216 219 220
+430 val_430 433 434
+278 val_278 281 282
+176 val_176 179 180
+289 val_289 292 293
+221 val_221 224 225
+65 val_65 68 69
+318 val_318 321 322
+332 val_332 335 336
+311 val_311 314 315
+275 val_275 278 279
+137 val_137 140 141
+241 val_241 244 245
+83 val_83 86 87
+333 val_333 336 337
+180 val_180 183 184
+284 val_284 287 288
+12 val_12 15 16
+230 val_230 233 234
+181 val_181 184 185
+67 val_67 70 71
+260 val_260 263 264
+404 val_404 407 408
+384 val_384 387 388
+489 val_489 492 493
+353 val_353 356 357
+373 val_373 376 377
+272 val_272 275 276
+138 val_138 141 142
+217 val_217 220 221
+84 val_84 87 88
+348 val_348 351 352
+466 val_466 469 470
+58 val_58 61 62
+8 val_8 11 12
+411 val_411 414 415
+230 val_230 233 234
+208 val_208 211 212
+348 val_348 351 352
+24 val_24 27 28
+463 val_463 466 467
+431 val_431 434 435
+179 val_179 182 183
+172 val_172 175 176
+42 val_42 45 46
+129 val_129 132 133
+158 val_158 161 162
+119 val_119 122 123
+496 val_496 499 500
+0 val_0 3 4
+322 val_322 325 326
+197 val_197 200 201
+468 val_468 471 472
+393 val_393 396 397
+454 val_454 457 458
+100 val_100 103 104
+298 val_298 301 302
+199 val_199 202 203
+191 val_191 194 195
+418 val_418 421 422
+96 val_96 99 100
+26 val_26 29 30
+165 val_165 168 169
+327 val_327 330 331
+230 val_230 233 234
+205 val_205 208 209
+120 val_120 123 124
+131 val_131 134 135
+51 val_51 54 55
+404 val_404 407 408
+43 val_43 46 47
+436 val_436 439 440
+156 val_156 159 160
+469 val_469 472 473
+468 val_468 471 472
+308 val_308 311 312
+95 val_95 98 99
+196 val_196 199 200
+288 val_288 291 292
+481 val_481 484 485
+457 val_457 460 461
+98 val_98 101 102
+282 val_282 285 286
+197 val_197 200 201
+187 val_187 190 191
+318 val_318 321 322
+318 val_318 321 322
+409 val_409 412 413
+470 val_470 473 474
+137 val_137 140 141
+369 val_369 372 373
+316 val_316 319 320
+169 val_169 172 173
+413 val_413 416 417
+85 val_85 88 89
+77 val_77 80 81
+0 val_0 3 4
+490 val_490 493 494
+87 val_87 90 91
+364 val_364 367 368
+179 val_179 182 183
+118 val_118 121 122
+134 val_134 137 138
+395 val_395 398 399
+282 val_282 285 286
+138 val_138 141 142
+238 val_238 241 242
+419 val_419 422 423
+15 val_15 18 19
+118 val_118 121 122
+72 val_72 75 76
+90 val_90 93 94
+307 val_307 310 311
+19 val_19 22 23
+435 val_435 438 439
+10 val_10 13 14
+277 val_277 280 281
+273 val_273 276 277
+306 val_306 309 310
+224 val_224 227 228
+309 val_309 312 313
+389 val_389 392 393
+327 val_327 330 331
+242 val_242 245 246
+369 val_369 372 373
+392 val_392 395 396
+272 val_272 275 276
+331 val_331 334 335
+401 val_401 404 405
+242 val_242 245 246
+452 val_452 455 456
+177 val_177 180 181
+226 val_226 229 230
+5 val_5 8 9
+497 val_497 500 501
+402 val_402 405 406
+396 val_396 399 400
+317 val_317 320 321
+395 val_395 398 399
+58 val_58 61 62
+35 val_35 38 39
+336 val_336 339 340
+95 val_95 98 99
+11 val_11 14 15
+168 val_168 171 172
+34 val_34 37 38
+229 val_229 232 233
+233 val_233 236 237
+143 val_143 146 147
+472 val_472 475 476
+322 val_322 325 326
+498 val_498 501 502
+160 val_160 163 164
+195 val_195 198 199
+42 val_42 45 46
+321 val_321 324 325
+430 val_430 433 434
+119 val_119 122 123
+489 val_489 492 493
+458 val_458 461 462
+78 val_78 81 82
+76 val_76 79 80
+41 val_41 44 45
+223 val_223 226 227
+492 val_492 495 496
+149 val_149 152 153
+449 val_449 452 453
+218 val_218 221 222
+228 val_228 231 232
+138 val_138 141 142
+453 val_453 456 457
+30 val_30 33 34
+209 val_209 212 213
+64 val_64 67 68
+468 val_468 471 472
+76 val_76 79 80
+74 val_74 77 78
+342 val_342 345 346
+69 val_69 72 73
+230 val_230 233 234
+33 val_33 36 37
+368 val_368 371 372
+103 val_103 106 107
+296 val_296 299 300
+113 val_113 116 117
+216 val_216 219 220
+367 val_367 370 371
+344 val_344 347 348
+167 val_167 170 171
+274 val_274 277 278
+219 val_219 222 223
+239 val_239 242 243
+485 val_485 488 489
+116 val_116 119 120
+223 val_223 226 227
+256 val_256 259 260
+263 val_263 266 267
+70 val_70 73 74
+487 val_487 490 491
+480 val_480 483 484
+401 val_401 404 405
+288 val_288 291 292
+191 val_191 194 195
+5 val_5 8 9
+244 val_244 247 248
+438 val_438 441 442
+128 val_128 131 132
+467 val_467 470 471
+432 val_432 435 436
+202 val_202 205 206
+316 val_316 319 320
+229 val_229 232 233
+469 val_469 472 473
+463 val_463 466 467
+280 val_280 283 284
+2 val_2 5 6
+35 val_35 38 39
+283 val_283 286 287
+331 val_331 334 335
+235 val_235 238 239
+80 val_80 83 84
+44 val_44 47 48
+193 val_193 196 197
+321 val_321 324 325
+335 val_335 338 339
+104 val_104 107 108
+466 val_466 469 470
+366 val_366 369 370
+175 val_175 178 179
+403 val_403 406 407
+483 val_483 486 487
+53 val_53 56 57
+105 val_105 108 109
+257 val_257 260 261
+406 val_406 409 410
+409 val_409 412 413
+190 val_190 193 194
+406 val_406 409 410
+401 val_401 404 405
+114 val_114 117 118
+258 val_258 261 262
+90 val_90 93 94
+203 val_203 206 207
+262 val_262 265 266
+348 val_348 351 352
+424 val_424 427 428
+12 val_12 15 16
+396 val_396 399 400
+201 val_201 204 205
+217 val_217 220 221
+164 val_164 167 168
+431 val_431 434 435
+454 val_454 457 458
+478 val_478 481 482
+298 val_298 301 302
+125 val_125 128 129
+431 val_431 434 435
+164 val_164 167 168
+424 val_424 427 428
+187 val_187 190 191
+382 val_382 385 386
+5 val_5 8 9
+70 val_70 73 74
+397 val_397 400 401
+480 val_480 483 484
+291 val_291 294 295
+24 val_24 27 28
+351 val_351 354 355
+255 val_255 258 259
+104 val_104 107 108
+70 val_70 73 74
+163 val_163 166 167
+438 val_438 441 442
+119 val_119 122 123
+414 val_414 417 418
+200 val_200 203 204
+491 val_491 494 495
+237 val_237 240 241
+439 val_439 442 443
+360 val_360 363 364
+248 val_248 251 252
+479 val_479 482 483
+305 val_305 308 309
+417 val_417 420 421
+199 val_199 202 203
+444 val_444 447 448
+120 val_120 123 124
+429 val_429 432 433
+169 val_169 172 173
+443 val_443 446 447
+323 val_323 326 327
+325 val_325 328 329
+277 val_277 280 281
+230 val_230 233 234
+478 val_478 481 482
+178 val_178 181 182
+468 val_468 471 472
+310 val_310 313 314
+317 val_317 320 321
+333 val_333 336 337
+493 val_493 496 497
+460 val_460 463 464
+207 val_207 210 211
+249 val_249 252 253
+265 val_265 268 269
+480 val_480 483 484
+83 val_83 86 87
+136 val_136 139 140
+353 val_353 356 357
+172 val_172 175 176
+214 val_214 217 218
+462 val_462 465 466
+233 val_233 236 237
+406 val_406 409 410
+133 val_133 136 137
+175 val_175 178 179
+189 val_189 192 193
+454 val_454 457 458
+375 val_375 378 379
+401 val_401 404 405
+421 val_421 424 425
+407 val_407 410 411
+384 val_384 387 388
+256 val_256 259 260
+26 val_26 29 30
+134 val_134 137 138
+67 val_67 70 71
+384 val_384 387 388
+379 val_379 382 383
+18 val_18 21 22
+462 val_462 465 466
+492 val_492 495 496
+100 val_100 103 104
+298 val_298 301 302
+9 val_9 12 13
+341 val_341 344 345
+498 val_498 501 502
+146 val_146 149 150
+458 val_458 461 462
+362 val_362 365 366
+186 val_186 189 190
+285 val_285 288 289
+348 val_348 351 352
+167 val_167 170 171
+18 val_18 21 22
+273 val_273 276 277
+183 val_183 186 187
+281 val_281 284 285
+344 val_344 347 348
+97 val_97 100 101
+469 val_469 472 473
+315 val_315 318 319
+84 val_84 87 88
+28 val_28 31 32
+37 val_37 40 41
+448 val_448 451 452
+152 val_152 155 156
+348 val_348 351 352
+307 val_307 310 311
+194 val_194 197 198
+414 val_414 417 418
+477 val_477 480 481
+222 val_222 225 226
+126 val_126 129 130
+90 val_90 93 94
+169 val_169 172 173
+403 val_403 406 407
+400 val_400 403 404
+200 val_200 203 204
+97 val_97 100 101
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-0-bc2e73d1da334f7bf550244ce6f6e77b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-0-bc2e73d1da334f7bf550244ce6f6e77b b/sql/hive/src/test/resources/golden/lateral_view-0-bc2e73d1da334f7bf550244ce6f6e77b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-1-82287db1270c77c3af7a60d65c4bdc80
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-1-82287db1270c77c3af7a60d65c4bdc80 b/sql/hive/src/test/resources/golden/lateral_view-1-82287db1270c77c3af7a60d65c4bdc80
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-10-1f2df08433fe12a9ae086e3d9309039e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-10-1f2df08433fe12a9ae086e3d9309039e b/sql/hive/src/test/resources/golden/lateral_view-10-1f2df08433fe12a9ae086e3d9309039e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-11-d884acac077c5a02ef048069dd8c16d7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-11-d884acac077c5a02ef048069dd8c16d7 b/sql/hive/src/test/resources/golden/lateral_view-11-d884acac077c5a02ef048069dd8c16d7
new file mode 100644
index 0000000..01e79c3
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-11-d884acac077c5a02ef048069dd8c16d7
@@ -0,0 +1,3 @@
+1
+2
+3
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-12-f539cc98118a276d38c61fcc0ad0b09
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-12-f539cc98118a276d38c61fcc0ad0b09 b/sql/hive/src/test/resources/golden/lateral_view-12-f539cc98118a276d38c61fcc0ad0b09
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-13-f1ca785bf643a4a3cd1f2f823da158ba
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-13-f1ca785bf643a4a3cd1f2f823da158ba b/sql/hive/src/test/resources/golden/lateral_view-13-f1ca785bf643a4a3cd1f2f823da158ba
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-14-f29001fbaafbdc4aaa1e0a0c18481aa7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-14-f29001fbaafbdc4aaa1e0a0c18481aa7 b/sql/hive/src/test/resources/golden/lateral_view-14-f29001fbaafbdc4aaa1e0a0c18481aa7
new file mode 100644
index 0000000..fd859fe
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-14-f29001fbaafbdc4aaa1e0a0c18481aa7
@@ -0,0 +1,20 @@
+0 ["val_0"]
+0 ["val_0"]
+0 ["val_0"]
+2 ["val_2"]
+4 ["val_4"]
+5 ["val_5"]
+5 ["val_5"]
+5 ["val_5"]
+8 ["val_8"]
+9 ["val_9"]
+10 ["val_10"]
+11 ["val_11"]
+12 ["val_12"]
+12 ["val_12"]
+15 ["val_15"]
+15 ["val_15"]
+17 ["val_17"]
+18 ["val_18"]
+18 ["val_18"]
+19 ["val_19"]
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-15-e1fad51e2f77de35d5781d788d70057e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-15-e1fad51e2f77de35d5781d788d70057e b/sql/hive/src/test/resources/golden/lateral_view-15-e1fad51e2f77de35d5781d788d70057e
new file mode 100644
index 0000000..512cb49
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-15-e1fad51e2f77de35d5781d788d70057e
@@ -0,0 +1,20 @@
+val_0
+val_0
+val_0
+val_2
+val_4
+val_5
+val_5
+val_5
+val_8
+val_9
+val_10
+val_11
+val_12
+val_12
+val_15
+val_15
+val_17
+val_18
+val_18
+val_19
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-16-5eafb0317b6974eb588075d152719a79
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-16-5eafb0317b6974eb588075d152719a79 b/sql/hive/src/test/resources/golden/lateral_view-16-5eafb0317b6974eb588075d152719a79
new file mode 100644
index 0000000..1f752ac
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-16-5eafb0317b6974eb588075d152719a79
@@ -0,0 +1,20 @@
+0 ["val_0"] val_0
+0 ["val_0"] val_0
+0 ["val_0"] val_0
+2 ["val_2"] val_2
+4 ["val_4"] val_4
+5 ["val_5"] val_5
+5 ["val_5"] val_5
+5 ["val_5"] val_5
+8 ["val_8"] val_8
+9 ["val_9"] val_9
+10 ["val_10"] val_10
+11 ["val_11"] val_11
+12 ["val_12"] val_12
+12 ["val_12"] val_12
+15 ["val_15"] val_15
+15 ["val_15"] val_15
+17 ["val_17"] val_17
+18 ["val_18"] val_18
+18 ["val_18"] val_18
+19 ["val_19"] val_19
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-17-4c6ff06840694c274bf8a91bade677ab
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-17-4c6ff06840694c274bf8a91bade677ab b/sql/hive/src/test/resources/golden/lateral_view-17-4c6ff06840694c274bf8a91bade677ab
new file mode 100644
index 0000000..fd859fe
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-17-4c6ff06840694c274bf8a91bade677ab
@@ -0,0 +1,20 @@
+0 ["val_0"]
+0 ["val_0"]
+0 ["val_0"]
+2 ["val_2"]
+4 ["val_4"]
+5 ["val_5"]
+5 ["val_5"]
+5 ["val_5"]
+8 ["val_8"]
+9 ["val_9"]
+10 ["val_10"]
+11 ["val_11"]
+12 ["val_12"]
+12 ["val_12"]
+15 ["val_15"]
+15 ["val_15"]
+17 ["val_17"]
+18 ["val_18"]
+18 ["val_18"]
+19 ["val_19"]
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-18-a98a136672c920c0463bd49b4ec7b65e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-18-a98a136672c920c0463bd49b4ec7b65e b/sql/hive/src/test/resources/golden/lateral_view-18-a98a136672c920c0463bd49b4ec7b65e
new file mode 100644
index 0000000..512cb49
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-18-a98a136672c920c0463bd49b4ec7b65e
@@ -0,0 +1,20 @@
+val_0
+val_0
+val_0
+val_2
+val_4
+val_5
+val_5
+val_5
+val_8
+val_9
+val_10
+val_11
+val_12
+val_12
+val_15
+val_15
+val_17
+val_18
+val_18
+val_19
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-19-9b417d5554cbeb8f536a1613879295f7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-19-9b417d5554cbeb8f536a1613879295f7 b/sql/hive/src/test/resources/golden/lateral_view-19-9b417d5554cbeb8f536a1613879295f7
new file mode 100644
index 0000000..f372b04
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-19-9b417d5554cbeb8f536a1613879295f7
@@ -0,0 +1,20 @@
+0
+0
+0
+2
+4
+5
+5
+5
+8
+9
+10
+11
+12
+12
+15
+15
+17
+18
+18
+19
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-2-bfd7354229ac8a934c8f978b43b28565
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-2-bfd7354229ac8a934c8f978b43b28565 b/sql/hive/src/test/resources/golden/lateral_view-2-bfd7354229ac8a934c8f978b43b28565
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-20-d75015d8e44499526fec784ec00b905
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-20-d75015d8e44499526fec784ec00b905 b/sql/hive/src/test/resources/golden/lateral_view-20-d75015d8e44499526fec784ec00b905
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-21-9eec1a93e07de6acbc36b1156424ca11
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-21-9eec1a93e07de6acbc36b1156424ca11 b/sql/hive/src/test/resources/golden/lateral_view-21-9eec1a93e07de6acbc36b1156424ca11
new file mode 100644
index 0000000..30e4fa1
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-21-9eec1a93e07de6acbc36b1156424ca11
@@ -0,0 +1,13 @@
+["val_0"] val_0
+["val_10"] val_10
+["val_11"] val_11
+["val_12"] val_12
+["val_15"] val_15
+["val_17"] val_17
+["val_18"] val_18
+["val_19"] val_19
+["val_2"] val_2
+["val_4"] val_4
+["val_5"] val_5
+["val_8"] val_8
+["val_9"] val_9
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-3-16a7be14adbb71fb9e6c7e0f00cfe86e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-3-16a7be14adbb71fb9e6c7e0f00cfe86e b/sql/hive/src/test/resources/golden/lateral_view-3-16a7be14adbb71fb9e6c7e0f00cfe86e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-4-f5855ce2bc7877c698e7f94504d12d62
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-4-f5855ce2bc7877c698e7f94504d12d62 b/sql/hive/src/test/resources/golden/lateral_view-4-f5855ce2bc7877c698e7f94504d12d62
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-5-857f93a5c8d5ba00d214384117147bae
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-5-857f93a5c8d5ba00d214384117147bae b/sql/hive/src/test/resources/golden/lateral_view-5-857f93a5c8d5ba00d214384117147bae
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-6-e78723941c3b42349f9eb804b4b82d15
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-6-e78723941c3b42349f9eb804b4b82d15 b/sql/hive/src/test/resources/golden/lateral_view-6-e78723941c3b42349f9eb804b4b82d15
new file mode 100644
index 0000000..d6426b3
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-6-e78723941c3b42349f9eb804b4b82d15
@@ -0,0 +1 @@
+0 val_0 1
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-7-7c88418f83112c55d08a0727d6248825
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-7-7c88418f83112c55d08a0727d6248825 b/sql/hive/src/test/resources/golden/lateral_view-7-7c88418f83112c55d08a0727d6248825
new file mode 100644
index 0000000..01e79c3
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-7-7c88418f83112c55d08a0727d6248825
@@ -0,0 +1,3 @@
+1
+2
+3
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-8-d2bff21465d3db7bbff8b9913c012452
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-8-d2bff21465d3db7bbff8b9913c012452 b/sql/hive/src/test/resources/golden/lateral_view-8-d2bff21465d3db7bbff8b9913c012452
new file mode 100644
index 0000000..423bb3e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-8-d2bff21465d3db7bbff8b9913c012452
@@ -0,0 +1,9 @@
+1 a
+1 b
+1 c
+2 a
+2 b
+2 c
+3 a
+3 b
+3 c
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view-9-60290e9a3b75a39c21dd44817d90d4a7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view-9-60290e9a3b75a39c21dd44817d90d4a7 b/sql/hive/src/test/resources/golden/lateral_view-9-60290e9a3b75a39c21dd44817d90d4a7
new file mode 100644
index 0000000..01e79c3
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view-9-60290e9a3b75a39c21dd44817d90d4a7
@@ -0,0 +1,3 @@
+1
+2
+3
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_cp-0-6ae48c990343343aad4145203c364f79
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_cp-0-6ae48c990343343aad4145203c364f79 b/sql/hive/src/test/resources/golden/lateral_view_cp-0-6ae48c990343343aad4145203c364f79
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_cp-1-72a14433dd2f25dd8c38107235fe1756
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_cp-1-72a14433dd2f25dd8c38107235fe1756 b/sql/hive/src/test/resources/golden/lateral_view_cp-1-72a14433dd2f25dd8c38107235fe1756
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_cp-2-647d019098d676b2fdb8a5127b633287
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_cp-2-647d019098d676b2fdb8a5127b633287 b/sql/hive/src/test/resources/golden/lateral_view_cp-2-647d019098d676b2fdb8a5127b633287
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_cp-3-3622d591963e6a7f021d07c7c35a1cd2
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_cp-3-3622d591963e6a7f021d07c7c35a1cd2 b/sql/hive/src/test/resources/golden/lateral_view_cp-3-3622d591963e6a7f021d07c7c35a1cd2
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_cp-4-507876b610812506343e9d251645170b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_cp-4-507876b610812506343e9d251645170b b/sql/hive/src/test/resources/golden/lateral_view_cp-4-507876b610812506343e9d251645170b
new file mode 100644
index 0000000..1f3d8a7
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view_cp-4-507876b610812506343e9d251645170b
@@ -0,0 +1 @@
+1028
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-0-72509f06e1f7c5d5ccc292f775f8eea7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-0-72509f06e1f7c5d5ccc292f775f8eea7 b/sql/hive/src/test/resources/golden/lateral_view_noalias-0-72509f06e1f7c5d5ccc292f775f8eea7
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-1-6d5806dd1d2511911a5de1e205523f42
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-1-6d5806dd1d2511911a5de1e205523f42 b/sql/hive/src/test/resources/golden/lateral_view_noalias-1-6d5806dd1d2511911a5de1e205523f42
new file mode 100644
index 0000000..0da0d93
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view_noalias-1-6d5806dd1d2511911a5de1e205523f42
@@ -0,0 +1,2 @@
+key1 100
+key2 200
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-2-155b3cc2f5054725a9c2acca3c38c00a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-2-155b3cc2f5054725a9c2acca3c38c00a b/sql/hive/src/test/resources/golden/lateral_view_noalias-2-155b3cc2f5054725a9c2acca3c38c00a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-3-3b7045ace234af8e5e86d8ac23ccee56
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-3-3b7045ace234af8e5e86d8ac23ccee56 b/sql/hive/src/test/resources/golden/lateral_view_noalias-3-3b7045ace234af8e5e86d8ac23ccee56
new file mode 100644
index 0000000..0da0d93
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view_noalias-3-3b7045ace234af8e5e86d8ac23ccee56
@@ -0,0 +1,2 @@
+key1 100
+key2 200
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-4-e1eca4e08216897d090259d4fd1e3fe
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-4-e1eca4e08216897d090259d4fd1e3fe b/sql/hive/src/test/resources/golden/lateral_view_noalias-4-e1eca4e08216897d090259d4fd1e3fe
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_noalias-5-16d227442dd775615c6ecfceedc6c612
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_noalias-5-16d227442dd775615c6ecfceedc6c612 b/sql/hive/src/test/resources/golden/lateral_view_noalias-5-16d227442dd775615c6ecfceedc6c612
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-0-b66c363516d1f717765df9b91da3b5b4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-0-b66c363516d1f717765df9b91da3b5b4 b/sql/hive/src/test/resources/golden/lateral_view_outer-0-b66c363516d1f717765df9b91da3b5b4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-1-8d4332785ff69bb86607700c133d0baa
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-1-8d4332785ff69bb86607700c133d0baa b/sql/hive/src/test/resources/golden/lateral_view_outer-1-8d4332785ff69bb86607700c133d0baa
new file mode 100644
index 0000000..a2a7fdd
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view_outer-1-8d4332785ff69bb86607700c133d0baa
@@ -0,0 +1,10 @@
+238 val_238 NULL
+86 val_86 NULL
+311 val_311 NULL
+27 val_27 NULL
+165 val_165 NULL
+409 val_409 NULL
+255 val_255 NULL
+278 val_278 NULL
+98 val_98 NULL
+484 val_484 NULL
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-2-b4474ec12d042fca7a21a2cd551c1068
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-2-b4474ec12d042fca7a21a2cd551c1068 b/sql/hive/src/test/resources/golden/lateral_view_outer-2-b4474ec12d042fca7a21a2cd551c1068
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-3-57b2ffd7b60708551238c491a2a8685d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-3-57b2ffd7b60708551238c491a2a8685d b/sql/hive/src/test/resources/golden/lateral_view_outer-3-57b2ffd7b60708551238c491a2a8685d
new file mode 100644
index 0000000..37d918a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/lateral_view_outer-3-57b2ffd7b60708551238c491a2a8685d
@@ -0,0 +1,10 @@
+238 val_238 4
+238 val_238 5
+86 val_86 4
+86 val_86 5
+311 val_311 4
+311 val_311 5
+27 val_27 4
+27 val_27 5
+165 val_165 4
+165 val_165 5
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-4-96fe3dc4f8116e535c322437a59b5e4e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-4-96fe3dc4f8116e535c322437a59b5e4e b/sql/hive/src/test/resources/golden/lateral_view_outer-4-96fe3dc4f8116e535c322437a59b5e4e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/lateral_view_outer-5-2ec3aeb923621c64da042402709e64e9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/lateral_view_outer-5-2ec3aeb923621c64da042402709e64e9 b/sql/hive/src/test/resources/golden/lateral_view_outer-5-2ec3aeb923621c64da042402709e64e9
new file mode 100644
index 0000000..e69de29