You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by ma...@apache.org on 2014/11/14 22:51:31 UTC
[1/2] spark git commit: [SPARK-4239] [SQL] support view in HiveQl
Repository: spark
Updated Branches:
refs/heads/master c258db9ed -> ade72c436
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-8-2cc0c576f0a008abf5bdf3308d500869
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-8-2cc0c576f0a008abf5bdf3308d500869 b/sql/hive/src/test/resources/golden/view_cast-8-2cc0c576f0a008abf5bdf3308d500869
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-9-f306bf3ad1c2a99f6f1843db44d7dfb4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-9-f306bf3ad1c2a99f6f1843db44d7dfb4 b/sql/hive/src/test/resources/golden/view_cast-9-f306bf3ad1c2a99f6f1843db44d7dfb4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_inputs-0-9e67dfd1d595ab8b1935b789645f76c0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_inputs-0-9e67dfd1d595ab8b1935b789645f76c0 b/sql/hive/src/test/resources/golden/view_inputs-0-9e67dfd1d595ab8b1935b789645f76c0
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_inputs-1-5af97e73bc3841793440105aae766bbe
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_inputs-1-5af97e73bc3841793440105aae766bbe b/sql/hive/src/test/resources/golden/view_inputs-1-5af97e73bc3841793440105aae766bbe
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_inputs-2-626fa3664754125edc44b7ca7f8630db
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_inputs-2-626fa3664754125edc44b7ca7f8630db b/sql/hive/src/test/resources/golden/view_inputs-2-626fa3664754125edc44b7ca7f8630db
new file mode 100644
index 0000000..1f3d8a7
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view_inputs-2-626fa3664754125edc44b7ca7f8630db
@@ -0,0 +1 @@
+1028
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org
[2/2] spark git commit: [SPARK-4239] [SQL] support view in HiveQl
Posted by ma...@apache.org.
[SPARK-4239] [SQL] support view in HiveQl
Currently still not support view like
CREATE VIEW view3(valoo)
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86;
because the text in metastore for this view is like
select \`_c0\` as \`valoo\` from (select upper(\`src\`.\`value\`) from \`default\`.\`src\` where ...) \`view3\`
while catalyst cannot resolve \`_c0\` for this query.
For view without colname definition in parentheses, it works fine.
Author: Daoyuan Wang <da...@intel.com>
Closes #3131 from adrian-wang/view and squashes the following commits:
8a56fd6 [Daoyuan Wang] michael's comments
e46c056 [Daoyuan Wang] add some golden file
079290a [Daoyuan Wang] remove useless import
88afcad [Daoyuan Wang] support view in HiveQl
Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/ade72c43
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/ade72c43
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/ade72c43
Branch: refs/heads/master
Commit: ade72c436276237f305d6a6aa4b594d43bcc4743
Parents: c258db9
Author: Daoyuan Wang <da...@intel.com>
Authored: Fri Nov 14 13:51:20 2014 -0800
Committer: Michael Armbrust <mi...@databricks.com>
Committed: Fri Nov 14 13:51:20 2014 -0800
----------------------------------------------------------------------
.../hive/execution/HiveCompatibilitySuite.scala | 6 +-
.../spark/sql/hive/HiveMetastoreCatalog.scala | 34 +-
.../org/apache/spark/sql/hive/HiveQl.scala | 10 +-
.../view-0-5528e36b3b0f5b14313898cc45f9c23a | 0
.../view-1-7650b86c86dd6b1a99c86ddc5a31bd63 | 0
.../view-10-7aae4448a05e8a8a3bace7522e952cd0 | 0
.../view-11-dc95343d3e57846485dd543476391376 | 0
.../view-12-371764e1cae31ea0518c03060528d239 | 0
.../view-13-2abce88008f8a19164758ee821aaa8a6 | 0
.../view-14-deb504f4f70fd7db975950c3c47959ee | 0
.../view-15-6f2797b6f81943d3b53b8d247ae8512b | 0
.../view-16-3077fd708f97a03d4151a1a30e4308d8 | 500 +++++++++
.../view-17-544b822e12afa24d2c64d6149e19c12c | 500 +++++++++
.../view-18-cd6a123a71769b082000669292e57add | 1028 ++++++++++++++++++
.../view-19-4a8f62f10a8a7b1f6e0d1c15481590a6 | 500 +++++++++
.../view-2-9c529f486fa81a032bfe1253808fca8 | 0
.../view-20-92aa822cb9dc29a1d3ad37d3ebaa344a | 500 +++++++++
.../view-21-4fa118ed540dfe42748bbed1e7fb513d | 1028 ++++++++++++++++++
.../view-22-f83b15c828d4ec599d7827af8b25f578 | 500 +++++++++
.../view-23-f6a52dd2ff5b11ea3bba2feb867f00c2 | 500 +++++++++
.../view-3-e7dd3b24daa60d8955b22f0441f01a6a | 0
.../view-4-4a64d1a623ca71e515796787dbd0f904 | 0
.../view-5-7abee38ed087f13f03ac216ef0decf4c | 0
.../view-6-47b5043f03a84695b6784682b4402ac8 | 0
.../view-7-8b1bbdadfd1e11af1b56064196164e58 | 0
.../view-8-60d2f3ee552ae7021f9fa72f0dcf2867 | 0
.../view-9-66c68babac10ae0f645fe8334c5a42d4 | 0
...view_cast-0-89bd46ad04f967f1f5ee17c6f201aacf | 0
...view_cast-1-85685a26971fb51ab6e28f9c5e8421bb | 0
...iew_cast-10-a7c865e5180df8d73dba90ede8be0d45 | 0
...iew_cast-11-b809f5d793b072146ccf577abf286003 | 8 +
...view_cast-2-635031c0752d5b30c44dfb3dec759a6c | 0
...view_cast-3-9f675e7edd64a33713e91282dc201867 | 0
...view_cast-4-d9edb83f4cf847e141d97012314917d4 | 0
...view_cast-5-6db508ccd85562a9ca7841fb0a08981a | 0
...view_cast-6-b18da53e46b62d6d91efac88ba62f308 | 0
...view_cast-7-78ac3800b22682b31708b6a09b402bfb | 0
...view_cast-8-2cc0c576f0a008abf5bdf3308d500869 | 0
...view_cast-9-f306bf3ad1c2a99f6f1843db44d7dfb4 | 0
...ew_inputs-0-9e67dfd1d595ab8b1935b789645f76c0 | 0
...ew_inputs-1-5af97e73bc3841793440105aae766bbe | 0
...ew_inputs-2-626fa3664754125edc44b7ca7f8630db | 1 +
42 files changed, 5098 insertions(+), 17 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/compatibility/src/test/scala/org/apache/spark/sql/hive/execution/HiveCompatibilitySuite.scala
----------------------------------------------------------------------
diff --git a/sql/hive/compatibility/src/test/scala/org/apache/spark/sql/hive/execution/HiveCompatibilitySuite.scala b/sql/hive/compatibility/src/test/scala/org/apache/spark/sql/hive/execution/HiveCompatibilitySuite.scala
index 1a3c24b..7c0be48 100644
--- a/sql/hive/compatibility/src/test/scala/org/apache/spark/sql/hive/execution/HiveCompatibilitySuite.scala
+++ b/sql/hive/compatibility/src/test/scala/org/apache/spark/sql/hive/execution/HiveCompatibilitySuite.scala
@@ -103,6 +103,7 @@ class HiveCompatibilitySuite extends HiveQueryFileTest with BeforeAndAfter {
"udf5",
"udf_java_method",
"create_merge_compressed",
+ "create_view_partitioned",
"database_location",
"database_properties",
@@ -969,6 +970,9 @@ class HiveCompatibilitySuite extends HiveQueryFileTest with BeforeAndAfter {
"union_script",
"varchar_2",
"varchar_join1",
- "varchar_union1"
+ "varchar_union1",
+ "view",
+ "view_cast",
+ "view_inputs"
)
}
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveMetastoreCatalog.scala
----------------------------------------------------------------------
diff --git a/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveMetastoreCatalog.scala b/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveMetastoreCatalog.scala
index 9ae0198..d446650 100644
--- a/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveMetastoreCatalog.scala
+++ b/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveMetastoreCatalog.scala
@@ -20,17 +20,15 @@ package org.apache.spark.sql.hive
import java.io.IOException
import java.util.{List => JList}
-import scala.util.matching.Regex
import scala.util.parsing.combinator.RegexParsers
import org.apache.hadoop.util.ReflectionUtils
-import org.apache.hadoop.fs.Path
import org.apache.hadoop.hive.metastore.TableType
import org.apache.hadoop.hive.metastore.api.FieldSchema
import org.apache.hadoop.hive.metastore.api.{Table => TTable, Partition => TPartition}
import org.apache.hadoop.hive.ql.metadata.{Hive, Partition, Table, HiveException}
-import org.apache.hadoop.hive.ql.plan.{TableDesc, CreateTableDesc}
+import org.apache.hadoop.hive.ql.plan.CreateTableDesc
import org.apache.hadoop.hive.serde.serdeConstants
import org.apache.hadoop.hive.serde2.{Deserializer, SerDeException}
import org.apache.hadoop.hive.serde2.`lazy`.LazySimpleSerDe
@@ -67,20 +65,26 @@ private[hive] class HiveMetastoreCatalog(hive: HiveContext) extends Catalog with
db: Option[String],
tableName: String,
alias: Option[String]): LogicalPlan = synchronized {
- val (databaseName, tblName) = processDatabaseAndTableName(
- db.getOrElse(hive.sessionState.getCurrentDatabase), tableName)
+ val (databaseName, tblName) =
+ processDatabaseAndTableName(db.getOrElse(hive.sessionState.getCurrentDatabase), tableName)
val table = client.getTable(databaseName, tblName)
- val partitions: Seq[Partition] =
- if (table.isPartitioned) {
- HiveShim.getAllPartitionsOf(client, table).toSeq
- } else {
- Nil
- }
+ if (table.isView) {
+ // if the unresolved relation is from hive view
+ // parse the text into logic node.
+ HiveQl.createPlanForView(table, alias)
+ } else {
+ val partitions: Seq[Partition] =
+ if (table.isPartitioned) {
+ HiveShim.getAllPartitionsOf(client, table).toSeq
+ } else {
+ Nil
+ }
- // Since HiveQL is case insensitive for table names we make them all lowercase.
- MetastoreRelation(
- databaseName, tblName, alias)(
- table.getTTable, partitions.map(part => part.getTPartition))(hive)
+ // Since HiveQL is case insensitive for table names we make them all lowercase.
+ MetastoreRelation(
+ databaseName, tblName, alias)(
+ table.getTTable, partitions.map(part => part.getTPartition))(hive)
+ }
}
/**
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala
----------------------------------------------------------------------
diff --git a/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala b/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala
index 74f68d0..1ca0403 100644
--- a/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala
+++ b/sql/hive/src/main/scala/org/apache/spark/sql/hive/HiveQl.scala
@@ -21,6 +21,7 @@ import java.sql.Date
import org.apache.hadoop.hive.conf.HiveConf
import org.apache.hadoop.hive.ql.Context
import org.apache.hadoop.hive.ql.lib.Node
+import org.apache.hadoop.hive.ql.metadata.Table
import org.apache.hadoop.hive.ql.parse._
import org.apache.hadoop.hive.ql.plan.PlanUtils
@@ -106,7 +107,6 @@ private[hive] object HiveQl {
"TOK_DROPINDEX",
"TOK_MSCK",
- // TODO(marmbrus): Figure out how view are expanded by hive, as we might need to handle this.
"TOK_ALTERVIEW_ADDPARTS",
"TOK_ALTERVIEW_AS",
"TOK_ALTERVIEW_DROPPARTS",
@@ -259,6 +259,14 @@ private[hive] object HiveQl {
}
}
+ /** Creates LogicalPlan for a given VIEW */
+ def createPlanForView(view: Table, alias: Option[String]) = alias match {
+ // because hive use things like `_c0` to build the expanded text
+ // currently we cannot support view from "create view v1(c1) as ..."
+ case None => Subquery(view.getTableName, createPlan(view.getViewExpandedText))
+ case Some(aliasText) => Subquery(aliasText, createPlan(view.getViewExpandedText))
+ }
+
def parseDdl(ddl: String): Seq[Attribute] = {
val tree =
try {
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-0-5528e36b3b0f5b14313898cc45f9c23a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-0-5528e36b3b0f5b14313898cc45f9c23a b/sql/hive/src/test/resources/golden/view-0-5528e36b3b0f5b14313898cc45f9c23a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-1-7650b86c86dd6b1a99c86ddc5a31bd63
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-1-7650b86c86dd6b1a99c86ddc5a31bd63 b/sql/hive/src/test/resources/golden/view-1-7650b86c86dd6b1a99c86ddc5a31bd63
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-10-7aae4448a05e8a8a3bace7522e952cd0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-10-7aae4448a05e8a8a3bace7522e952cd0 b/sql/hive/src/test/resources/golden/view-10-7aae4448a05e8a8a3bace7522e952cd0
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-11-dc95343d3e57846485dd543476391376
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-11-dc95343d3e57846485dd543476391376 b/sql/hive/src/test/resources/golden/view-11-dc95343d3e57846485dd543476391376
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-12-371764e1cae31ea0518c03060528d239
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-12-371764e1cae31ea0518c03060528d239 b/sql/hive/src/test/resources/golden/view-12-371764e1cae31ea0518c03060528d239
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-13-2abce88008f8a19164758ee821aaa8a6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-13-2abce88008f8a19164758ee821aaa8a6 b/sql/hive/src/test/resources/golden/view-13-2abce88008f8a19164758ee821aaa8a6
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-14-deb504f4f70fd7db975950c3c47959ee
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-14-deb504f4f70fd7db975950c3c47959ee b/sql/hive/src/test/resources/golden/view-14-deb504f4f70fd7db975950c3c47959ee
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-15-6f2797b6f81943d3b53b8d247ae8512b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-15-6f2797b6f81943d3b53b8d247ae8512b b/sql/hive/src/test/resources/golden/view-15-6f2797b6f81943d3b53b8d247ae8512b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-16-3077fd708f97a03d4151a1a30e4308d8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-16-3077fd708f97a03d4151a1a30e4308d8 b/sql/hive/src/test/resources/golden/view-16-3077fd708f97a03d4151a1a30e4308d8
new file mode 100644
index 0000000..7aae61e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-16-3077fd708f97a03d4151a1a30e4308d8
@@ -0,0 +1,500 @@
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+302 val_302
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-17-544b822e12afa24d2c64d6149e19c12c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-17-544b822e12afa24d2c64d6149e19c12c b/sql/hive/src/test/resources/golden/view-17-544b822e12afa24d2c64d6149e19c12c
new file mode 100644
index 0000000..7aae61e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-17-544b822e12afa24d2c64d6149e19c12c
@@ -0,0 +1,500 @@
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+302 val_302
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-18-cd6a123a71769b082000669292e57add
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-18-cd6a123a71769b082000669292e57add b/sql/hive/src/test/resources/golden/view-18-cd6a123a71769b082000669292e57add
new file mode 100644
index 0000000..68782c7
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-18-cd6a123a71769b082000669292e57add
@@ -0,0 +1,1028 @@
+238 val_238 238
+238 val_238 238
+86 val_86 86
+311 val_311 311
+311 val_311 311
+311 val_311 311
+27 val_27 27
+165 val_165 165
+165 val_165 165
+409 val_409 409
+409 val_409 409
+409 val_409 409
+255 val_255 255
+255 val_255 255
+278 val_278 278
+278 val_278 278
+98 val_98 98
+98 val_98 98
+484 val_484 484
+265 val_265 265
+265 val_265 265
+193 val_193 193
+193 val_193 193
+193 val_193 193
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+150 val_150 150
+273 val_273 273
+273 val_273 273
+273 val_273 273
+224 val_224 224
+224 val_224 224
+369 val_369 369
+369 val_369 369
+369 val_369 369
+66 val_66 66
+128 val_128 128
+128 val_128 128
+128 val_128 128
+213 val_213 213
+213 val_213 213
+146 val_146 146
+146 val_146 146
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+429 val_429 429
+429 val_429 429
+374 val_374 374
+152 val_152 152
+152 val_152 152
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+145 val_145 145
+495 val_495 495
+37 val_37 37
+37 val_37 37
+327 val_327 327
+327 val_327 327
+327 val_327 327
+281 val_281 281
+281 val_281 281
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+209 val_209 209
+209 val_209 209
+15 val_15 15
+15 val_15 15
+82 val_82 82
+403 val_403 403
+403 val_403 403
+403 val_403 403
+166 val_166 166
+417 val_417 417
+417 val_417 417
+417 val_417 417
+430 val_430 430
+430 val_430 430
+430 val_430 430
+252 val_252 252
+292 val_292 292
+219 val_219 219
+219 val_219 219
+287 val_287 287
+153 val_153 153
+193 val_193 193
+193 val_193 193
+193 val_193 193
+338 val_338 338
+446 val_446 446
+459 val_459 459
+459 val_459 459
+394 val_394 394
+237 val_237 237
+237 val_237 237
+482 val_482 482
+174 val_174 174
+174 val_174 174
+413 val_413 413
+413 val_413 413
+494 val_494 494
+207 val_207 207
+207 val_207 207
+199 val_199 199
+199 val_199 199
+199 val_199 199
+466 val_466 466
+466 val_466 466
+466 val_466 466
+208 val_208 208
+208 val_208 208
+208 val_208 208
+174 val_174 174
+174 val_174 174
+399 val_399 399
+399 val_399 399
+396 val_396 396
+396 val_396 396
+396 val_396 396
+247 val_247 247
+417 val_417 417
+417 val_417 417
+417 val_417 417
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+162 val_162 162
+377 val_377 377
+397 val_397 397
+397 val_397 397
+309 val_309 309
+309 val_309 309
+365 val_365 365
+266 val_266 266
+439 val_439 439
+439 val_439 439
+342 val_342 342
+342 val_342 342
+367 val_367 367
+367 val_367 367
+325 val_325 325
+325 val_325 325
+167 val_167 167
+167 val_167 167
+167 val_167 167
+195 val_195 195
+195 val_195 195
+475 val_475 475
+17 val_17 17
+113 val_113 113
+113 val_113 113
+155 val_155 155
+203 val_203 203
+203 val_203 203
+339 val_339 339
+0 val_0 0
+0 val_0 0
+0 val_0 0
+455 val_455 455
+128 val_128 128
+128 val_128 128
+128 val_128 128
+311 val_311 311
+311 val_311 311
+311 val_311 311
+316 val_316 316
+316 val_316 316
+316 val_316 316
+57 val_57 57
+302 val_302 302
+205 val_205 205
+205 val_205 205
+149 val_149 149
+149 val_149 149
+438 val_438 438
+438 val_438 438
+438 val_438 438
+345 val_345 345
+129 val_129 129
+129 val_129 129
+170 val_170 170
+20 val_20 20
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+157 val_157 157
+378 val_378 378
+221 val_221 221
+221 val_221 221
+92 val_92 92
+111 val_111 111
+47 val_47 47
+72 val_72 72
+72 val_72 72
+4 val_4 4
+280 val_280 280
+280 val_280 280
+35 val_35 35
+35 val_35 35
+35 val_35 35
+427 val_427 427
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+208 val_208 208
+208 val_208 208
+208 val_208 208
+356 val_356 356
+399 val_399 399
+399 val_399 399
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+382 val_382 382
+382 val_382 382
+498 val_498 498
+498 val_498 498
+498 val_498 498
+125 val_125 125
+125 val_125 125
+386 val_386 386
+437 val_437 437
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+192 val_192 192
+286 val_286 286
+187 val_187 187
+187 val_187 187
+187 val_187 187
+176 val_176 176
+176 val_176 176
+54 val_54 54
+459 val_459 459
+459 val_459 459
+51 val_51 51
+51 val_51 51
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+103 val_103 103
+103 val_103 103
+239 val_239 239
+239 val_239 239
+213 val_213 213
+213 val_213 213
+216 val_216 216
+216 val_216 216
+430 val_430 430
+430 val_430 430
+430 val_430 430
+278 val_278 278
+278 val_278 278
+176 val_176 176
+176 val_176 176
+289 val_289 289
+221 val_221 221
+221 val_221 221
+65 val_65 65
+318 val_318 318
+318 val_318 318
+318 val_318 318
+332 val_332 332
+311 val_311 311
+311 val_311 311
+311 val_311 311
+275 val_275 275
+137 val_137 137
+137 val_137 137
+241 val_241 241
+83 val_83 83
+83 val_83 83
+333 val_333 333
+333 val_333 333
+180 val_180 180
+284 val_284 284
+12 val_12 12
+12 val_12 12
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+181 val_181 181
+67 val_67 67
+67 val_67 67
+260 val_260 260
+404 val_404 404
+404 val_404 404
+384 val_384 384
+384 val_384 384
+384 val_384 384
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+353 val_353 353
+353 val_353 353
+373 val_373 373
+272 val_272 272
+272 val_272 272
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+217 val_217 217
+217 val_217 217
+84 val_84 84
+84 val_84 84
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+466 val_466 466
+466 val_466 466
+466 val_466 466
+58 val_58 58
+58 val_58 58
+8 val_8 8
+411 val_411 411
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+208 val_208 208
+208 val_208 208
+208 val_208 208
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+24 val_24 24
+24 val_24 24
+463 val_463 463
+463 val_463 463
+431 val_431 431
+431 val_431 431
+431 val_431 431
+179 val_179 179
+179 val_179 179
+172 val_172 172
+172 val_172 172
+42 val_42 42
+42 val_42 42
+129 val_129 129
+129 val_129 129
+158 val_158 158
+119 val_119 119
+119 val_119 119
+119 val_119 119
+496 val_496 496
+0 val_0 0
+0 val_0 0
+0 val_0 0
+322 val_322 322
+322 val_322 322
+197 val_197 197
+197 val_197 197
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+393 val_393 393
+454 val_454 454
+454 val_454 454
+454 val_454 454
+100 val_100 100
+100 val_100 100
+298 val_298 298
+298 val_298 298
+298 val_298 298
+199 val_199 199
+199 val_199 199
+199 val_199 199
+191 val_191 191
+191 val_191 191
+418 val_418 418
+96 val_96 96
+26 val_26 26
+26 val_26 26
+165 val_165 165
+165 val_165 165
+327 val_327 327
+327 val_327 327
+327 val_327 327
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+205 val_205 205
+205 val_205 205
+120 val_120 120
+120 val_120 120
+131 val_131 131
+51 val_51 51
+51 val_51 51
+404 val_404 404
+404 val_404 404
+43 val_43 43
+436 val_436 436
+156 val_156 156
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+308 val_308 308
+95 val_95 95
+95 val_95 95
+196 val_196 196
+288 val_288 288
+288 val_288 288
+481 val_481 481
+457 val_457 457
+98 val_98 98
+98 val_98 98
+282 val_282 282
+282 val_282 282
+197 val_197 197
+197 val_197 197
+187 val_187 187
+187 val_187 187
+187 val_187 187
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+409 val_409 409
+409 val_409 409
+409 val_409 409
+470 val_470 470
+137 val_137 137
+137 val_137 137
+369 val_369 369
+369 val_369 369
+369 val_369 369
+316 val_316 316
+316 val_316 316
+316 val_316 316
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+413 val_413 413
+413 val_413 413
+85 val_85 85
+77 val_77 77
+0 val_0 0
+0 val_0 0
+0 val_0 0
+490 val_490 490
+87 val_87 87
+364 val_364 364
+179 val_179 179
+179 val_179 179
+118 val_118 118
+118 val_118 118
+134 val_134 134
+134 val_134 134
+395 val_395 395
+395 val_395 395
+282 val_282 282
+282 val_282 282
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+238 val_238 238
+238 val_238 238
+419 val_419 419
+15 val_15 15
+15 val_15 15
+118 val_118 118
+118 val_118 118
+72 val_72 72
+72 val_72 72
+90 val_90 90
+90 val_90 90
+90 val_90 90
+307 val_307 307
+307 val_307 307
+19 val_19 19
+435 val_435 435
+10 val_10 10
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+273 val_273 273
+273 val_273 273
+273 val_273 273
+306 val_306 306
+224 val_224 224
+224 val_224 224
+309 val_309 309
+309 val_309 309
+389 val_389 389
+327 val_327 327
+327 val_327 327
+327 val_327 327
+242 val_242 242
+242 val_242 242
+369 val_369 369
+369 val_369 369
+369 val_369 369
+392 val_392 392
+272 val_272 272
+272 val_272 272
+331 val_331 331
+331 val_331 331
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+242 val_242 242
+242 val_242 242
+452 val_452 452
+177 val_177 177
+226 val_226 226
+5 val_5 5
+5 val_5 5
+5 val_5 5
+497 val_497 497
+402 val_402 402
+396 val_396 396
+396 val_396 396
+396 val_396 396
+317 val_317 317
+317 val_317 317
+395 val_395 395
+395 val_395 395
+58 val_58 58
+58 val_58 58
+35 val_35 35
+35 val_35 35
+35 val_35 35
+336 val_336 336
+95 val_95 95
+95 val_95 95
+11 val_11 11
+168 val_168 168
+34 val_34 34
+229 val_229 229
+229 val_229 229
+233 val_233 233
+233 val_233 233
+143 val_143 143
+472 val_472 472
+322 val_322 322
+322 val_322 322
+498 val_498 498
+498 val_498 498
+498 val_498 498
+160 val_160 160
+195 val_195 195
+195 val_195 195
+42 val_42 42
+42 val_42 42
+321 val_321 321
+321 val_321 321
+430 val_430 430
+430 val_430 430
+430 val_430 430
+119 val_119 119
+119 val_119 119
+119 val_119 119
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+458 val_458 458
+458 val_458 458
+78 val_78 78
+76 val_76 76
+76 val_76 76
+41 val_41 41
+223 val_223 223
+223 val_223 223
+492 val_492 492
+492 val_492 492
+149 val_149 149
+149 val_149 149
+449 val_449 449
+218 val_218 218
+228 val_228 228
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+453 val_453 453
+30 val_30 30
+209 val_209 209
+209 val_209 209
+64 val_64 64
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+76 val_76 76
+76 val_76 76
+74 val_74 74
+342 val_342 342
+342 val_342 342
+69 val_69 69
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+33 val_33 33
+368 val_368 368
+103 val_103 103
+103 val_103 103
+296 val_296 296
+113 val_113 113
+113 val_113 113
+216 val_216 216
+216 val_216 216
+367 val_367 367
+367 val_367 367
+344 val_344 344
+344 val_344 344
+167 val_167 167
+167 val_167 167
+167 val_167 167
+274 val_274 274
+219 val_219 219
+219 val_219 219
+239 val_239 239
+239 val_239 239
+485 val_485 485
+116 val_116 116
+223 val_223 223
+223 val_223 223
+256 val_256 256
+256 val_256 256
+263 val_263 263
+70 val_70 70
+70 val_70 70
+70 val_70 70
+487 val_487 487
+480 val_480 480
+480 val_480 480
+480 val_480 480
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+288 val_288 288
+288 val_288 288
+191 val_191 191
+191 val_191 191
+5 val_5 5
+5 val_5 5
+5 val_5 5
+244 val_244 244
+438 val_438 438
+438 val_438 438
+438 val_438 438
+128 val_128 128
+128 val_128 128
+128 val_128 128
+467 val_467 467
+432 val_432 432
+202 val_202 202
+316 val_316 316
+316 val_316 316
+316 val_316 316
+229 val_229 229
+229 val_229 229
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+463 val_463 463
+463 val_463 463
+280 val_280 280
+280 val_280 280
+2 val_2 2
+35 val_35 35
+35 val_35 35
+35 val_35 35
+283 val_283 283
+331 val_331 331
+331 val_331 331
+235 val_235 235
+80 val_80 80
+44 val_44 44
+193 val_193 193
+193 val_193 193
+193 val_193 193
+321 val_321 321
+321 val_321 321
+335 val_335 335
+104 val_104 104
+104 val_104 104
+466 val_466 466
+466 val_466 466
+466 val_466 466
+366 val_366 366
+175 val_175 175
+175 val_175 175
+403 val_403 403
+403 val_403 403
+403 val_403 403
+483 val_483 483
+53 val_53 53
+105 val_105 105
+257 val_257 257
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+409 val_409 409
+409 val_409 409
+409 val_409 409
+190 val_190 190
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+114 val_114 114
+258 val_258 258
+90 val_90 90
+90 val_90 90
+90 val_90 90
+203 val_203 203
+203 val_203 203
+262 val_262 262
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+424 val_424 424
+424 val_424 424
+12 val_12 12
+12 val_12 12
+396 val_396 396
+396 val_396 396
+396 val_396 396
+201 val_201 201
+217 val_217 217
+217 val_217 217
+164 val_164 164
+164 val_164 164
+431 val_431 431
+431 val_431 431
+431 val_431 431
+454 val_454 454
+454 val_454 454
+454 val_454 454
+478 val_478 478
+478 val_478 478
+298 val_298 298
+298 val_298 298
+298 val_298 298
+125 val_125 125
+125 val_125 125
+431 val_431 431
+431 val_431 431
+431 val_431 431
+164 val_164 164
+164 val_164 164
+424 val_424 424
+424 val_424 424
+187 val_187 187
+187 val_187 187
+187 val_187 187
+382 val_382 382
+382 val_382 382
+5 val_5 5
+5 val_5 5
+5 val_5 5
+70 val_70 70
+70 val_70 70
+70 val_70 70
+397 val_397 397
+397 val_397 397
+480 val_480 480
+480 val_480 480
+480 val_480 480
+291 val_291 291
+24 val_24 24
+24 val_24 24
+351 val_351 351
+255 val_255 255
+255 val_255 255
+104 val_104 104
+104 val_104 104
+70 val_70 70
+70 val_70 70
+70 val_70 70
+163 val_163 163
+438 val_438 438
+438 val_438 438
+438 val_438 438
+119 val_119 119
+119 val_119 119
+119 val_119 119
+414 val_414 414
+414 val_414 414
+200 val_200 200
+200 val_200 200
+491 val_491 491
+237 val_237 237
+237 val_237 237
+439 val_439 439
+439 val_439 439
+360 val_360 360
+248 val_248 248
+479 val_479 479
+305 val_305 305
+417 val_417 417
+417 val_417 417
+417 val_417 417
+199 val_199 199
+199 val_199 199
+199 val_199 199
+444 val_444 444
+120 val_120 120
+120 val_120 120
+429 val_429 429
+429 val_429 429
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+443 val_443 443
+323 val_323 323
+325 val_325 325
+325 val_325 325
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+478 val_478 478
+478 val_478 478
+178 val_178 178
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+310 val_310 310
+317 val_317 317
+317 val_317 317
+333 val_333 333
+333 val_333 333
+493 val_493 493
+460 val_460 460
+207 val_207 207
+207 val_207 207
+249 val_249 249
+265 val_265 265
+265 val_265 265
+480 val_480 480
+480 val_480 480
+480 val_480 480
+83 val_83 83
+83 val_83 83
+136 val_136 136
+353 val_353 353
+353 val_353 353
+172 val_172 172
+172 val_172 172
+214 val_214 214
+462 val_462 462
+462 val_462 462
+233 val_233 233
+233 val_233 233
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+133 val_133 133
+175 val_175 175
+175 val_175 175
+189 val_189 189
+454 val_454 454
+454 val_454 454
+454 val_454 454
+375 val_375 375
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+421 val_421 421
+407 val_407 407
+384 val_384 384
+384 val_384 384
+384 val_384 384
+256 val_256 256
+256 val_256 256
+26 val_26 26
+26 val_26 26
+134 val_134 134
+134 val_134 134
+67 val_67 67
+67 val_67 67
+384 val_384 384
+384 val_384 384
+384 val_384 384
+379 val_379 379
+18 val_18 18
+18 val_18 18
+462 val_462 462
+462 val_462 462
+492 val_492 492
+492 val_492 492
+100 val_100 100
+100 val_100 100
+298 val_298 298
+298 val_298 298
+298 val_298 298
+9 val_9 9
+341 val_341 341
+498 val_498 498
+498 val_498 498
+498 val_498 498
+146 val_146 146
+146 val_146 146
+458 val_458 458
+458 val_458 458
+362 val_362 362
+186 val_186 186
+285 val_285 285
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+167 val_167 167
+167 val_167 167
+167 val_167 167
+18 val_18 18
+18 val_18 18
+273 val_273 273
+273 val_273 273
+273 val_273 273
+183 val_183 183
+281 val_281 281
+281 val_281 281
+344 val_344 344
+344 val_344 344
+97 val_97 97
+97 val_97 97
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+315 val_315 315
+84 val_84 84
+84 val_84 84
+28 val_28 28
+37 val_37 37
+37 val_37 37
+448 val_448 448
+152 val_152 152
+152 val_152 152
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+307 val_307 307
+307 val_307 307
+194 val_194 194
+414 val_414 414
+414 val_414 414
+477 val_477 477
+222 val_222 222
+126 val_126 126
+90 val_90 90
+90 val_90 90
+90 val_90 90
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+403 val_403 403
+403 val_403 403
+403 val_403 403
+400 val_400 400
+200 val_200 200
+200 val_200 200
+97 val_97 97
+97 val_97 97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-19-4a8f62f10a8a7b1f6e0d1c15481590a6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-19-4a8f62f10a8a7b1f6e0d1c15481590a6 b/sql/hive/src/test/resources/golden/view-19-4a8f62f10a8a7b1f6e0d1c15481590a6
new file mode 100644
index 0000000..7aae61e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-19-4a8f62f10a8a7b1f6e0d1c15481590a6
@@ -0,0 +1,500 @@
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+302 val_302
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-2-9c529f486fa81a032bfe1253808fca8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-2-9c529f486fa81a032bfe1253808fca8 b/sql/hive/src/test/resources/golden/view-2-9c529f486fa81a032bfe1253808fca8
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-20-92aa822cb9dc29a1d3ad37d3ebaa344a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-20-92aa822cb9dc29a1d3ad37d3ebaa344a b/sql/hive/src/test/resources/golden/view-20-92aa822cb9dc29a1d3ad37d3ebaa344a
new file mode 100644
index 0000000..7aae61e
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-20-92aa822cb9dc29a1d3ad37d3ebaa344a
@@ -0,0 +1,500 @@
+238 val_238
+86 val_86
+311 val_311
+27 val_27
+165 val_165
+409 val_409
+255 val_255
+278 val_278
+98 val_98
+484 val_484
+265 val_265
+193 val_193
+401 val_401
+150 val_150
+273 val_273
+224 val_224
+369 val_369
+66 val_66
+128 val_128
+213 val_213
+146 val_146
+406 val_406
+429 val_429
+374 val_374
+152 val_152
+469 val_469
+145 val_145
+495 val_495
+37 val_37
+327 val_327
+281 val_281
+277 val_277
+209 val_209
+15 val_15
+82 val_82
+403 val_403
+166 val_166
+417 val_417
+430 val_430
+252 val_252
+292 val_292
+219 val_219
+287 val_287
+153 val_153
+193 val_193
+338 val_338
+446 val_446
+459 val_459
+394 val_394
+237 val_237
+482 val_482
+174 val_174
+413 val_413
+494 val_494
+207 val_207
+199 val_199
+466 val_466
+208 val_208
+174 val_174
+399 val_399
+396 val_396
+247 val_247
+417 val_417
+489 val_489
+162 val_162
+377 val_377
+397 val_397
+309 val_309
+365 val_365
+266 val_266
+439 val_439
+342 val_342
+367 val_367
+325 val_325
+167 val_167
+195 val_195
+475 val_475
+17 val_17
+113 val_113
+155 val_155
+203 val_203
+339 val_339
+0 val_0
+455 val_455
+128 val_128
+311 val_311
+316 val_316
+57 val_57
+302 val_302
+205 val_205
+149 val_149
+438 val_438
+345 val_345
+129 val_129
+170 val_170
+20 val_20
+489 val_489
+157 val_157
+378 val_378
+221 val_221
+92 val_92
+111 val_111
+47 val_47
+72 val_72
+4 val_4
+280 val_280
+35 val_35
+427 val_427
+277 val_277
+208 val_208
+356 val_356
+399 val_399
+169 val_169
+382 val_382
+498 val_498
+125 val_125
+386 val_386
+437 val_437
+469 val_469
+192 val_192
+286 val_286
+187 val_187
+176 val_176
+54 val_54
+459 val_459
+51 val_51
+138 val_138
+103 val_103
+239 val_239
+213 val_213
+216 val_216
+430 val_430
+278 val_278
+176 val_176
+289 val_289
+221 val_221
+65 val_65
+318 val_318
+332 val_332
+311 val_311
+275 val_275
+137 val_137
+241 val_241
+83 val_83
+333 val_333
+180 val_180
+284 val_284
+12 val_12
+230 val_230
+181 val_181
+67 val_67
+260 val_260
+404 val_404
+384 val_384
+489 val_489
+353 val_353
+373 val_373
+272 val_272
+138 val_138
+217 val_217
+84 val_84
+348 val_348
+466 val_466
+58 val_58
+8 val_8
+411 val_411
+230 val_230
+208 val_208
+348 val_348
+24 val_24
+463 val_463
+431 val_431
+179 val_179
+172 val_172
+42 val_42
+129 val_129
+158 val_158
+119 val_119
+496 val_496
+0 val_0
+322 val_322
+197 val_197
+468 val_468
+393 val_393
+454 val_454
+100 val_100
+298 val_298
+199 val_199
+191 val_191
+418 val_418
+96 val_96
+26 val_26
+165 val_165
+327 val_327
+230 val_230
+205 val_205
+120 val_120
+131 val_131
+51 val_51
+404 val_404
+43 val_43
+436 val_436
+156 val_156
+469 val_469
+468 val_468
+308 val_308
+95 val_95
+196 val_196
+288 val_288
+481 val_481
+457 val_457
+98 val_98
+282 val_282
+197 val_197
+187 val_187
+318 val_318
+318 val_318
+409 val_409
+470 val_470
+137 val_137
+369 val_369
+316 val_316
+169 val_169
+413 val_413
+85 val_85
+77 val_77
+0 val_0
+490 val_490
+87 val_87
+364 val_364
+179 val_179
+118 val_118
+134 val_134
+395 val_395
+282 val_282
+138 val_138
+238 val_238
+419 val_419
+15 val_15
+118 val_118
+72 val_72
+90 val_90
+307 val_307
+19 val_19
+435 val_435
+10 val_10
+277 val_277
+273 val_273
+306 val_306
+224 val_224
+309 val_309
+389 val_389
+327 val_327
+242 val_242
+369 val_369
+392 val_392
+272 val_272
+331 val_331
+401 val_401
+242 val_242
+452 val_452
+177 val_177
+226 val_226
+5 val_5
+497 val_497
+402 val_402
+396 val_396
+317 val_317
+395 val_395
+58 val_58
+35 val_35
+336 val_336
+95 val_95
+11 val_11
+168 val_168
+34 val_34
+229 val_229
+233 val_233
+143 val_143
+472 val_472
+322 val_322
+498 val_498
+160 val_160
+195 val_195
+42 val_42
+321 val_321
+430 val_430
+119 val_119
+489 val_489
+458 val_458
+78 val_78
+76 val_76
+41 val_41
+223 val_223
+492 val_492
+149 val_149
+449 val_449
+218 val_218
+228 val_228
+138 val_138
+453 val_453
+30 val_30
+209 val_209
+64 val_64
+468 val_468
+76 val_76
+74 val_74
+342 val_342
+69 val_69
+230 val_230
+33 val_33
+368 val_368
+103 val_103
+296 val_296
+113 val_113
+216 val_216
+367 val_367
+344 val_344
+167 val_167
+274 val_274
+219 val_219
+239 val_239
+485 val_485
+116 val_116
+223 val_223
+256 val_256
+263 val_263
+70 val_70
+487 val_487
+480 val_480
+401 val_401
+288 val_288
+191 val_191
+5 val_5
+244 val_244
+438 val_438
+128 val_128
+467 val_467
+432 val_432
+202 val_202
+316 val_316
+229 val_229
+469 val_469
+463 val_463
+280 val_280
+2 val_2
+35 val_35
+283 val_283
+331 val_331
+235 val_235
+80 val_80
+44 val_44
+193 val_193
+321 val_321
+335 val_335
+104 val_104
+466 val_466
+366 val_366
+175 val_175
+403 val_403
+483 val_483
+53 val_53
+105 val_105
+257 val_257
+406 val_406
+409 val_409
+190 val_190
+406 val_406
+401 val_401
+114 val_114
+258 val_258
+90 val_90
+203 val_203
+262 val_262
+348 val_348
+424 val_424
+12 val_12
+396 val_396
+201 val_201
+217 val_217
+164 val_164
+431 val_431
+454 val_454
+478 val_478
+298 val_298
+125 val_125
+431 val_431
+164 val_164
+424 val_424
+187 val_187
+382 val_382
+5 val_5
+70 val_70
+397 val_397
+480 val_480
+291 val_291
+24 val_24
+351 val_351
+255 val_255
+104 val_104
+70 val_70
+163 val_163
+438 val_438
+119 val_119
+414 val_414
+200 val_200
+491 val_491
+237 val_237
+439 val_439
+360 val_360
+248 val_248
+479 val_479
+305 val_305
+417 val_417
+199 val_199
+444 val_444
+120 val_120
+429 val_429
+169 val_169
+443 val_443
+323 val_323
+325 val_325
+277 val_277
+230 val_230
+478 val_478
+178 val_178
+468 val_468
+310 val_310
+317 val_317
+333 val_333
+493 val_493
+460 val_460
+207 val_207
+249 val_249
+265 val_265
+480 val_480
+83 val_83
+136 val_136
+353 val_353
+172 val_172
+214 val_214
+462 val_462
+233 val_233
+406 val_406
+133 val_133
+175 val_175
+189 val_189
+454 val_454
+375 val_375
+401 val_401
+421 val_421
+407 val_407
+384 val_384
+256 val_256
+26 val_26
+134 val_134
+67 val_67
+384 val_384
+379 val_379
+18 val_18
+462 val_462
+492 val_492
+100 val_100
+298 val_298
+9 val_9
+341 val_341
+498 val_498
+146 val_146
+458 val_458
+362 val_362
+186 val_186
+285 val_285
+348 val_348
+167 val_167
+18 val_18
+273 val_273
+183 val_183
+281 val_281
+344 val_344
+97 val_97
+469 val_469
+315 val_315
+84 val_84
+28 val_28
+37 val_37
+448 val_448
+152 val_152
+348 val_348
+307 val_307
+194 val_194
+414 val_414
+477 val_477
+222 val_222
+126 val_126
+90 val_90
+169 val_169
+403 val_403
+400 val_400
+200 val_200
+97 val_97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-21-4fa118ed540dfe42748bbed1e7fb513d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-21-4fa118ed540dfe42748bbed1e7fb513d b/sql/hive/src/test/resources/golden/view-21-4fa118ed540dfe42748bbed1e7fb513d
new file mode 100644
index 0000000..68782c7
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-21-4fa118ed540dfe42748bbed1e7fb513d
@@ -0,0 +1,1028 @@
+238 val_238 238
+238 val_238 238
+86 val_86 86
+311 val_311 311
+311 val_311 311
+311 val_311 311
+27 val_27 27
+165 val_165 165
+165 val_165 165
+409 val_409 409
+409 val_409 409
+409 val_409 409
+255 val_255 255
+255 val_255 255
+278 val_278 278
+278 val_278 278
+98 val_98 98
+98 val_98 98
+484 val_484 484
+265 val_265 265
+265 val_265 265
+193 val_193 193
+193 val_193 193
+193 val_193 193
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+150 val_150 150
+273 val_273 273
+273 val_273 273
+273 val_273 273
+224 val_224 224
+224 val_224 224
+369 val_369 369
+369 val_369 369
+369 val_369 369
+66 val_66 66
+128 val_128 128
+128 val_128 128
+128 val_128 128
+213 val_213 213
+213 val_213 213
+146 val_146 146
+146 val_146 146
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+429 val_429 429
+429 val_429 429
+374 val_374 374
+152 val_152 152
+152 val_152 152
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+145 val_145 145
+495 val_495 495
+37 val_37 37
+37 val_37 37
+327 val_327 327
+327 val_327 327
+327 val_327 327
+281 val_281 281
+281 val_281 281
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+209 val_209 209
+209 val_209 209
+15 val_15 15
+15 val_15 15
+82 val_82 82
+403 val_403 403
+403 val_403 403
+403 val_403 403
+166 val_166 166
+417 val_417 417
+417 val_417 417
+417 val_417 417
+430 val_430 430
+430 val_430 430
+430 val_430 430
+252 val_252 252
+292 val_292 292
+219 val_219 219
+219 val_219 219
+287 val_287 287
+153 val_153 153
+193 val_193 193
+193 val_193 193
+193 val_193 193
+338 val_338 338
+446 val_446 446
+459 val_459 459
+459 val_459 459
+394 val_394 394
+237 val_237 237
+237 val_237 237
+482 val_482 482
+174 val_174 174
+174 val_174 174
+413 val_413 413
+413 val_413 413
+494 val_494 494
+207 val_207 207
+207 val_207 207
+199 val_199 199
+199 val_199 199
+199 val_199 199
+466 val_466 466
+466 val_466 466
+466 val_466 466
+208 val_208 208
+208 val_208 208
+208 val_208 208
+174 val_174 174
+174 val_174 174
+399 val_399 399
+399 val_399 399
+396 val_396 396
+396 val_396 396
+396 val_396 396
+247 val_247 247
+417 val_417 417
+417 val_417 417
+417 val_417 417
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+162 val_162 162
+377 val_377 377
+397 val_397 397
+397 val_397 397
+309 val_309 309
+309 val_309 309
+365 val_365 365
+266 val_266 266
+439 val_439 439
+439 val_439 439
+342 val_342 342
+342 val_342 342
+367 val_367 367
+367 val_367 367
+325 val_325 325
+325 val_325 325
+167 val_167 167
+167 val_167 167
+167 val_167 167
+195 val_195 195
+195 val_195 195
+475 val_475 475
+17 val_17 17
+113 val_113 113
+113 val_113 113
+155 val_155 155
+203 val_203 203
+203 val_203 203
+339 val_339 339
+0 val_0 0
+0 val_0 0
+0 val_0 0
+455 val_455 455
+128 val_128 128
+128 val_128 128
+128 val_128 128
+311 val_311 311
+311 val_311 311
+311 val_311 311
+316 val_316 316
+316 val_316 316
+316 val_316 316
+57 val_57 57
+302 val_302 302
+205 val_205 205
+205 val_205 205
+149 val_149 149
+149 val_149 149
+438 val_438 438
+438 val_438 438
+438 val_438 438
+345 val_345 345
+129 val_129 129
+129 val_129 129
+170 val_170 170
+20 val_20 20
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+157 val_157 157
+378 val_378 378
+221 val_221 221
+221 val_221 221
+92 val_92 92
+111 val_111 111
+47 val_47 47
+72 val_72 72
+72 val_72 72
+4 val_4 4
+280 val_280 280
+280 val_280 280
+35 val_35 35
+35 val_35 35
+35 val_35 35
+427 val_427 427
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+208 val_208 208
+208 val_208 208
+208 val_208 208
+356 val_356 356
+399 val_399 399
+399 val_399 399
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+382 val_382 382
+382 val_382 382
+498 val_498 498
+498 val_498 498
+498 val_498 498
+125 val_125 125
+125 val_125 125
+386 val_386 386
+437 val_437 437
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+192 val_192 192
+286 val_286 286
+187 val_187 187
+187 val_187 187
+187 val_187 187
+176 val_176 176
+176 val_176 176
+54 val_54 54
+459 val_459 459
+459 val_459 459
+51 val_51 51
+51 val_51 51
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+103 val_103 103
+103 val_103 103
+239 val_239 239
+239 val_239 239
+213 val_213 213
+213 val_213 213
+216 val_216 216
+216 val_216 216
+430 val_430 430
+430 val_430 430
+430 val_430 430
+278 val_278 278
+278 val_278 278
+176 val_176 176
+176 val_176 176
+289 val_289 289
+221 val_221 221
+221 val_221 221
+65 val_65 65
+318 val_318 318
+318 val_318 318
+318 val_318 318
+332 val_332 332
+311 val_311 311
+311 val_311 311
+311 val_311 311
+275 val_275 275
+137 val_137 137
+137 val_137 137
+241 val_241 241
+83 val_83 83
+83 val_83 83
+333 val_333 333
+333 val_333 333
+180 val_180 180
+284 val_284 284
+12 val_12 12
+12 val_12 12
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+181 val_181 181
+67 val_67 67
+67 val_67 67
+260 val_260 260
+404 val_404 404
+404 val_404 404
+384 val_384 384
+384 val_384 384
+384 val_384 384
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+353 val_353 353
+353 val_353 353
+373 val_373 373
+272 val_272 272
+272 val_272 272
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+217 val_217 217
+217 val_217 217
+84 val_84 84
+84 val_84 84
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+466 val_466 466
+466 val_466 466
+466 val_466 466
+58 val_58 58
+58 val_58 58
+8 val_8 8
+411 val_411 411
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+208 val_208 208
+208 val_208 208
+208 val_208 208
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+24 val_24 24
+24 val_24 24
+463 val_463 463
+463 val_463 463
+431 val_431 431
+431 val_431 431
+431 val_431 431
+179 val_179 179
+179 val_179 179
+172 val_172 172
+172 val_172 172
+42 val_42 42
+42 val_42 42
+129 val_129 129
+129 val_129 129
+158 val_158 158
+119 val_119 119
+119 val_119 119
+119 val_119 119
+496 val_496 496
+0 val_0 0
+0 val_0 0
+0 val_0 0
+322 val_322 322
+322 val_322 322
+197 val_197 197
+197 val_197 197
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+393 val_393 393
+454 val_454 454
+454 val_454 454
+454 val_454 454
+100 val_100 100
+100 val_100 100
+298 val_298 298
+298 val_298 298
+298 val_298 298
+199 val_199 199
+199 val_199 199
+199 val_199 199
+191 val_191 191
+191 val_191 191
+418 val_418 418
+96 val_96 96
+26 val_26 26
+26 val_26 26
+165 val_165 165
+165 val_165 165
+327 val_327 327
+327 val_327 327
+327 val_327 327
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+205 val_205 205
+205 val_205 205
+120 val_120 120
+120 val_120 120
+131 val_131 131
+51 val_51 51
+51 val_51 51
+404 val_404 404
+404 val_404 404
+43 val_43 43
+436 val_436 436
+156 val_156 156
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+308 val_308 308
+95 val_95 95
+95 val_95 95
+196 val_196 196
+288 val_288 288
+288 val_288 288
+481 val_481 481
+457 val_457 457
+98 val_98 98
+98 val_98 98
+282 val_282 282
+282 val_282 282
+197 val_197 197
+197 val_197 197
+187 val_187 187
+187 val_187 187
+187 val_187 187
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+318 val_318 318
+409 val_409 409
+409 val_409 409
+409 val_409 409
+470 val_470 470
+137 val_137 137
+137 val_137 137
+369 val_369 369
+369 val_369 369
+369 val_369 369
+316 val_316 316
+316 val_316 316
+316 val_316 316
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+413 val_413 413
+413 val_413 413
+85 val_85 85
+77 val_77 77
+0 val_0 0
+0 val_0 0
+0 val_0 0
+490 val_490 490
+87 val_87 87
+364 val_364 364
+179 val_179 179
+179 val_179 179
+118 val_118 118
+118 val_118 118
+134 val_134 134
+134 val_134 134
+395 val_395 395
+395 val_395 395
+282 val_282 282
+282 val_282 282
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+238 val_238 238
+238 val_238 238
+419 val_419 419
+15 val_15 15
+15 val_15 15
+118 val_118 118
+118 val_118 118
+72 val_72 72
+72 val_72 72
+90 val_90 90
+90 val_90 90
+90 val_90 90
+307 val_307 307
+307 val_307 307
+19 val_19 19
+435 val_435 435
+10 val_10 10
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+273 val_273 273
+273 val_273 273
+273 val_273 273
+306 val_306 306
+224 val_224 224
+224 val_224 224
+309 val_309 309
+309 val_309 309
+389 val_389 389
+327 val_327 327
+327 val_327 327
+327 val_327 327
+242 val_242 242
+242 val_242 242
+369 val_369 369
+369 val_369 369
+369 val_369 369
+392 val_392 392
+272 val_272 272
+272 val_272 272
+331 val_331 331
+331 val_331 331
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+242 val_242 242
+242 val_242 242
+452 val_452 452
+177 val_177 177
+226 val_226 226
+5 val_5 5
+5 val_5 5
+5 val_5 5
+497 val_497 497
+402 val_402 402
+396 val_396 396
+396 val_396 396
+396 val_396 396
+317 val_317 317
+317 val_317 317
+395 val_395 395
+395 val_395 395
+58 val_58 58
+58 val_58 58
+35 val_35 35
+35 val_35 35
+35 val_35 35
+336 val_336 336
+95 val_95 95
+95 val_95 95
+11 val_11 11
+168 val_168 168
+34 val_34 34
+229 val_229 229
+229 val_229 229
+233 val_233 233
+233 val_233 233
+143 val_143 143
+472 val_472 472
+322 val_322 322
+322 val_322 322
+498 val_498 498
+498 val_498 498
+498 val_498 498
+160 val_160 160
+195 val_195 195
+195 val_195 195
+42 val_42 42
+42 val_42 42
+321 val_321 321
+321 val_321 321
+430 val_430 430
+430 val_430 430
+430 val_430 430
+119 val_119 119
+119 val_119 119
+119 val_119 119
+489 val_489 489
+489 val_489 489
+489 val_489 489
+489 val_489 489
+458 val_458 458
+458 val_458 458
+78 val_78 78
+76 val_76 76
+76 val_76 76
+41 val_41 41
+223 val_223 223
+223 val_223 223
+492 val_492 492
+492 val_492 492
+149 val_149 149
+149 val_149 149
+449 val_449 449
+218 val_218 218
+228 val_228 228
+138 val_138 138
+138 val_138 138
+138 val_138 138
+138 val_138 138
+453 val_453 453
+30 val_30 30
+209 val_209 209
+209 val_209 209
+64 val_64 64
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+76 val_76 76
+76 val_76 76
+74 val_74 74
+342 val_342 342
+342 val_342 342
+69 val_69 69
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+33 val_33 33
+368 val_368 368
+103 val_103 103
+103 val_103 103
+296 val_296 296
+113 val_113 113
+113 val_113 113
+216 val_216 216
+216 val_216 216
+367 val_367 367
+367 val_367 367
+344 val_344 344
+344 val_344 344
+167 val_167 167
+167 val_167 167
+167 val_167 167
+274 val_274 274
+219 val_219 219
+219 val_219 219
+239 val_239 239
+239 val_239 239
+485 val_485 485
+116 val_116 116
+223 val_223 223
+223 val_223 223
+256 val_256 256
+256 val_256 256
+263 val_263 263
+70 val_70 70
+70 val_70 70
+70 val_70 70
+487 val_487 487
+480 val_480 480
+480 val_480 480
+480 val_480 480
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+288 val_288 288
+288 val_288 288
+191 val_191 191
+191 val_191 191
+5 val_5 5
+5 val_5 5
+5 val_5 5
+244 val_244 244
+438 val_438 438
+438 val_438 438
+438 val_438 438
+128 val_128 128
+128 val_128 128
+128 val_128 128
+467 val_467 467
+432 val_432 432
+202 val_202 202
+316 val_316 316
+316 val_316 316
+316 val_316 316
+229 val_229 229
+229 val_229 229
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+463 val_463 463
+463 val_463 463
+280 val_280 280
+280 val_280 280
+2 val_2 2
+35 val_35 35
+35 val_35 35
+35 val_35 35
+283 val_283 283
+331 val_331 331
+331 val_331 331
+235 val_235 235
+80 val_80 80
+44 val_44 44
+193 val_193 193
+193 val_193 193
+193 val_193 193
+321 val_321 321
+321 val_321 321
+335 val_335 335
+104 val_104 104
+104 val_104 104
+466 val_466 466
+466 val_466 466
+466 val_466 466
+366 val_366 366
+175 val_175 175
+175 val_175 175
+403 val_403 403
+403 val_403 403
+403 val_403 403
+483 val_483 483
+53 val_53 53
+105 val_105 105
+257 val_257 257
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+409 val_409 409
+409 val_409 409
+409 val_409 409
+190 val_190 190
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+114 val_114 114
+258 val_258 258
+90 val_90 90
+90 val_90 90
+90 val_90 90
+203 val_203 203
+203 val_203 203
+262 val_262 262
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+424 val_424 424
+424 val_424 424
+12 val_12 12
+12 val_12 12
+396 val_396 396
+396 val_396 396
+396 val_396 396
+201 val_201 201
+217 val_217 217
+217 val_217 217
+164 val_164 164
+164 val_164 164
+431 val_431 431
+431 val_431 431
+431 val_431 431
+454 val_454 454
+454 val_454 454
+454 val_454 454
+478 val_478 478
+478 val_478 478
+298 val_298 298
+298 val_298 298
+298 val_298 298
+125 val_125 125
+125 val_125 125
+431 val_431 431
+431 val_431 431
+431 val_431 431
+164 val_164 164
+164 val_164 164
+424 val_424 424
+424 val_424 424
+187 val_187 187
+187 val_187 187
+187 val_187 187
+382 val_382 382
+382 val_382 382
+5 val_5 5
+5 val_5 5
+5 val_5 5
+70 val_70 70
+70 val_70 70
+70 val_70 70
+397 val_397 397
+397 val_397 397
+480 val_480 480
+480 val_480 480
+480 val_480 480
+291 val_291 291
+24 val_24 24
+24 val_24 24
+351 val_351 351
+255 val_255 255
+255 val_255 255
+104 val_104 104
+104 val_104 104
+70 val_70 70
+70 val_70 70
+70 val_70 70
+163 val_163 163
+438 val_438 438
+438 val_438 438
+438 val_438 438
+119 val_119 119
+119 val_119 119
+119 val_119 119
+414 val_414 414
+414 val_414 414
+200 val_200 200
+200 val_200 200
+491 val_491 491
+237 val_237 237
+237 val_237 237
+439 val_439 439
+439 val_439 439
+360 val_360 360
+248 val_248 248
+479 val_479 479
+305 val_305 305
+417 val_417 417
+417 val_417 417
+417 val_417 417
+199 val_199 199
+199 val_199 199
+199 val_199 199
+444 val_444 444
+120 val_120 120
+120 val_120 120
+429 val_429 429
+429 val_429 429
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+443 val_443 443
+323 val_323 323
+325 val_325 325
+325 val_325 325
+277 val_277 277
+277 val_277 277
+277 val_277 277
+277 val_277 277
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+230 val_230 230
+478 val_478 478
+478 val_478 478
+178 val_178 178
+468 val_468 468
+468 val_468 468
+468 val_468 468
+468 val_468 468
+310 val_310 310
+317 val_317 317
+317 val_317 317
+333 val_333 333
+333 val_333 333
+493 val_493 493
+460 val_460 460
+207 val_207 207
+207 val_207 207
+249 val_249 249
+265 val_265 265
+265 val_265 265
+480 val_480 480
+480 val_480 480
+480 val_480 480
+83 val_83 83
+83 val_83 83
+136 val_136 136
+353 val_353 353
+353 val_353 353
+172 val_172 172
+172 val_172 172
+214 val_214 214
+462 val_462 462
+462 val_462 462
+233 val_233 233
+233 val_233 233
+406 val_406 406
+406 val_406 406
+406 val_406 406
+406 val_406 406
+133 val_133 133
+175 val_175 175
+175 val_175 175
+189 val_189 189
+454 val_454 454
+454 val_454 454
+454 val_454 454
+375 val_375 375
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+401 val_401 401
+421 val_421 421
+407 val_407 407
+384 val_384 384
+384 val_384 384
+384 val_384 384
+256 val_256 256
+256 val_256 256
+26 val_26 26
+26 val_26 26
+134 val_134 134
+134 val_134 134
+67 val_67 67
+67 val_67 67
+384 val_384 384
+384 val_384 384
+384 val_384 384
+379 val_379 379
+18 val_18 18
+18 val_18 18
+462 val_462 462
+462 val_462 462
+492 val_492 492
+492 val_492 492
+100 val_100 100
+100 val_100 100
+298 val_298 298
+298 val_298 298
+298 val_298 298
+9 val_9 9
+341 val_341 341
+498 val_498 498
+498 val_498 498
+498 val_498 498
+146 val_146 146
+146 val_146 146
+458 val_458 458
+458 val_458 458
+362 val_362 362
+186 val_186 186
+285 val_285 285
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+167 val_167 167
+167 val_167 167
+167 val_167 167
+18 val_18 18
+18 val_18 18
+273 val_273 273
+273 val_273 273
+273 val_273 273
+183 val_183 183
+281 val_281 281
+281 val_281 281
+344 val_344 344
+344 val_344 344
+97 val_97 97
+97 val_97 97
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+469 val_469 469
+315 val_315 315
+84 val_84 84
+84 val_84 84
+28 val_28 28
+37 val_37 37
+37 val_37 37
+448 val_448 448
+152 val_152 152
+152 val_152 152
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+348 val_348 348
+307 val_307 307
+307 val_307 307
+194 val_194 194
+414 val_414 414
+414 val_414 414
+477 val_477 477
+222 val_222 222
+126 val_126 126
+90 val_90 90
+90 val_90 90
+90 val_90 90
+169 val_169 169
+169 val_169 169
+169 val_169 169
+169 val_169 169
+403 val_403 403
+403 val_403 403
+403 val_403 403
+400 val_400 400
+200 val_200 200
+200 val_200 200
+97 val_97 97
+97 val_97 97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-22-f83b15c828d4ec599d7827af8b25f578
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-22-f83b15c828d4ec599d7827af8b25f578 b/sql/hive/src/test/resources/golden/view-22-f83b15c828d4ec599d7827af8b25f578
new file mode 100644
index 0000000..e341185
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-22-f83b15c828d4ec599d7827af8b25f578
@@ -0,0 +1,500 @@
+238
+86
+311
+27
+165
+409
+255
+278
+98
+484
+265
+193
+401
+150
+273
+224
+369
+66
+128
+213
+146
+406
+429
+374
+152
+469
+145
+495
+37
+327
+281
+277
+209
+15
+82
+403
+166
+417
+430
+252
+292
+219
+287
+153
+193
+338
+446
+459
+394
+237
+482
+174
+413
+494
+207
+199
+466
+208
+174
+399
+396
+247
+417
+489
+162
+377
+397
+309
+365
+266
+439
+342
+367
+325
+167
+195
+475
+17
+113
+155
+203
+339
+0
+455
+128
+311
+316
+57
+302
+205
+149
+438
+345
+129
+170
+20
+489
+157
+378
+221
+92
+111
+47
+72
+4
+280
+35
+427
+277
+208
+356
+399
+169
+382
+498
+125
+386
+437
+469
+192
+286
+187
+176
+54
+459
+51
+138
+103
+239
+213
+216
+430
+278
+176
+289
+221
+65
+318
+332
+311
+275
+137
+241
+83
+333
+180
+284
+12
+230
+181
+67
+260
+404
+384
+489
+353
+373
+272
+138
+217
+84
+348
+466
+58
+8
+411
+230
+208
+348
+24
+463
+431
+179
+172
+42
+129
+158
+119
+496
+0
+322
+197
+468
+393
+454
+100
+298
+199
+191
+418
+96
+26
+165
+327
+230
+205
+120
+131
+51
+404
+43
+436
+156
+469
+468
+308
+95
+196
+288
+481
+457
+98
+282
+197
+187
+318
+318
+409
+470
+137
+369
+316
+169
+413
+85
+77
+0
+490
+87
+364
+179
+118
+134
+395
+282
+138
+238
+419
+15
+118
+72
+90
+307
+19
+435
+10
+277
+273
+306
+224
+309
+389
+327
+242
+369
+392
+272
+331
+401
+242
+452
+177
+226
+5
+497
+402
+396
+317
+395
+58
+35
+336
+95
+11
+168
+34
+229
+233
+143
+472
+322
+498
+160
+195
+42
+321
+430
+119
+489
+458
+78
+76
+41
+223
+492
+149
+449
+218
+228
+138
+453
+30
+209
+64
+468
+76
+74
+342
+69
+230
+33
+368
+103
+296
+113
+216
+367
+344
+167
+274
+219
+239
+485
+116
+223
+256
+263
+70
+487
+480
+401
+288
+191
+5
+244
+438
+128
+467
+432
+202
+316
+229
+469
+463
+280
+2
+35
+283
+331
+235
+80
+44
+193
+321
+335
+104
+466
+366
+175
+403
+483
+53
+105
+257
+406
+409
+190
+406
+401
+114
+258
+90
+203
+262
+348
+424
+12
+396
+201
+217
+164
+431
+454
+478
+298
+125
+431
+164
+424
+187
+382
+5
+70
+397
+480
+291
+24
+351
+255
+104
+70
+163
+438
+119
+414
+200
+491
+237
+439
+360
+248
+479
+305
+417
+199
+444
+120
+429
+169
+443
+323
+325
+277
+230
+478
+178
+468
+310
+317
+333
+493
+460
+207
+249
+265
+480
+83
+136
+353
+172
+214
+462
+233
+406
+133
+175
+189
+454
+375
+401
+421
+407
+384
+256
+26
+134
+67
+384
+379
+18
+462
+492
+100
+298
+9
+341
+498
+146
+458
+362
+186
+285
+348
+167
+18
+273
+183
+281
+344
+97
+469
+315
+84
+28
+37
+448
+152
+348
+307
+194
+414
+477
+222
+126
+90
+169
+403
+400
+200
+97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-23-f6a52dd2ff5b11ea3bba2feb867f00c2
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-23-f6a52dd2ff5b11ea3bba2feb867f00c2 b/sql/hive/src/test/resources/golden/view-23-f6a52dd2ff5b11ea3bba2feb867f00c2
new file mode 100644
index 0000000..e341185
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view-23-f6a52dd2ff5b11ea3bba2feb867f00c2
@@ -0,0 +1,500 @@
+238
+86
+311
+27
+165
+409
+255
+278
+98
+484
+265
+193
+401
+150
+273
+224
+369
+66
+128
+213
+146
+406
+429
+374
+152
+469
+145
+495
+37
+327
+281
+277
+209
+15
+82
+403
+166
+417
+430
+252
+292
+219
+287
+153
+193
+338
+446
+459
+394
+237
+482
+174
+413
+494
+207
+199
+466
+208
+174
+399
+396
+247
+417
+489
+162
+377
+397
+309
+365
+266
+439
+342
+367
+325
+167
+195
+475
+17
+113
+155
+203
+339
+0
+455
+128
+311
+316
+57
+302
+205
+149
+438
+345
+129
+170
+20
+489
+157
+378
+221
+92
+111
+47
+72
+4
+280
+35
+427
+277
+208
+356
+399
+169
+382
+498
+125
+386
+437
+469
+192
+286
+187
+176
+54
+459
+51
+138
+103
+239
+213
+216
+430
+278
+176
+289
+221
+65
+318
+332
+311
+275
+137
+241
+83
+333
+180
+284
+12
+230
+181
+67
+260
+404
+384
+489
+353
+373
+272
+138
+217
+84
+348
+466
+58
+8
+411
+230
+208
+348
+24
+463
+431
+179
+172
+42
+129
+158
+119
+496
+0
+322
+197
+468
+393
+454
+100
+298
+199
+191
+418
+96
+26
+165
+327
+230
+205
+120
+131
+51
+404
+43
+436
+156
+469
+468
+308
+95
+196
+288
+481
+457
+98
+282
+197
+187
+318
+318
+409
+470
+137
+369
+316
+169
+413
+85
+77
+0
+490
+87
+364
+179
+118
+134
+395
+282
+138
+238
+419
+15
+118
+72
+90
+307
+19
+435
+10
+277
+273
+306
+224
+309
+389
+327
+242
+369
+392
+272
+331
+401
+242
+452
+177
+226
+5
+497
+402
+396
+317
+395
+58
+35
+336
+95
+11
+168
+34
+229
+233
+143
+472
+322
+498
+160
+195
+42
+321
+430
+119
+489
+458
+78
+76
+41
+223
+492
+149
+449
+218
+228
+138
+453
+30
+209
+64
+468
+76
+74
+342
+69
+230
+33
+368
+103
+296
+113
+216
+367
+344
+167
+274
+219
+239
+485
+116
+223
+256
+263
+70
+487
+480
+401
+288
+191
+5
+244
+438
+128
+467
+432
+202
+316
+229
+469
+463
+280
+2
+35
+283
+331
+235
+80
+44
+193
+321
+335
+104
+466
+366
+175
+403
+483
+53
+105
+257
+406
+409
+190
+406
+401
+114
+258
+90
+203
+262
+348
+424
+12
+396
+201
+217
+164
+431
+454
+478
+298
+125
+431
+164
+424
+187
+382
+5
+70
+397
+480
+291
+24
+351
+255
+104
+70
+163
+438
+119
+414
+200
+491
+237
+439
+360
+248
+479
+305
+417
+199
+444
+120
+429
+169
+443
+323
+325
+277
+230
+478
+178
+468
+310
+317
+333
+493
+460
+207
+249
+265
+480
+83
+136
+353
+172
+214
+462
+233
+406
+133
+175
+189
+454
+375
+401
+421
+407
+384
+256
+26
+134
+67
+384
+379
+18
+462
+492
+100
+298
+9
+341
+498
+146
+458
+362
+186
+285
+348
+167
+18
+273
+183
+281
+344
+97
+469
+315
+84
+28
+37
+448
+152
+348
+307
+194
+414
+477
+222
+126
+90
+169
+403
+400
+200
+97
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-3-e7dd3b24daa60d8955b22f0441f01a6a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-3-e7dd3b24daa60d8955b22f0441f01a6a b/sql/hive/src/test/resources/golden/view-3-e7dd3b24daa60d8955b22f0441f01a6a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-4-4a64d1a623ca71e515796787dbd0f904
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-4-4a64d1a623ca71e515796787dbd0f904 b/sql/hive/src/test/resources/golden/view-4-4a64d1a623ca71e515796787dbd0f904
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-5-7abee38ed087f13f03ac216ef0decf4c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-5-7abee38ed087f13f03ac216ef0decf4c b/sql/hive/src/test/resources/golden/view-5-7abee38ed087f13f03ac216ef0decf4c
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-6-47b5043f03a84695b6784682b4402ac8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-6-47b5043f03a84695b6784682b4402ac8 b/sql/hive/src/test/resources/golden/view-6-47b5043f03a84695b6784682b4402ac8
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-7-8b1bbdadfd1e11af1b56064196164e58
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-7-8b1bbdadfd1e11af1b56064196164e58 b/sql/hive/src/test/resources/golden/view-7-8b1bbdadfd1e11af1b56064196164e58
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-8-60d2f3ee552ae7021f9fa72f0dcf2867
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-8-60d2f3ee552ae7021f9fa72f0dcf2867 b/sql/hive/src/test/resources/golden/view-8-60d2f3ee552ae7021f9fa72f0dcf2867
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view-9-66c68babac10ae0f645fe8334c5a42d4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view-9-66c68babac10ae0f645fe8334c5a42d4 b/sql/hive/src/test/resources/golden/view-9-66c68babac10ae0f645fe8334c5a42d4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-0-89bd46ad04f967f1f5ee17c6f201aacf
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-0-89bd46ad04f967f1f5ee17c6f201aacf b/sql/hive/src/test/resources/golden/view_cast-0-89bd46ad04f967f1f5ee17c6f201aacf
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-1-85685a26971fb51ab6e28f9c5e8421bb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-1-85685a26971fb51ab6e28f9c5e8421bb b/sql/hive/src/test/resources/golden/view_cast-1-85685a26971fb51ab6e28f9c5e8421bb
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-10-a7c865e5180df8d73dba90ede8be0d45
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-10-a7c865e5180df8d73dba90ede8be0d45 b/sql/hive/src/test/resources/golden/view_cast-10-a7c865e5180df8d73dba90ede8be0d45
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-11-b809f5d793b072146ccf577abf286003
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-11-b809f5d793b072146ccf577abf286003 b/sql/hive/src/test/resources/golden/view_cast-11-b809f5d793b072146ccf577abf286003
new file mode 100644
index 0000000..da7e68d
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/view_cast-11-b809f5d793b072146ccf577abf286003
@@ -0,0 +1,8 @@
+1111 abc fun bar NULL 2222 NULL 99999.0 99999.0
+1111 abc fun bar NULL 2222 NULL 99999.0 99999.0
+2222 abc fun bar NULL 4444 NULL 99999.0 99999.0
+2222 abc fun bar NULL 4444 NULL 99999.0 99999.0
+3333 abc fun bar NULL 6666 NULL 99999.0 10.0
+3333 abc fun bar NULL 6666 NULL 99999.0 10.0
+3333 abc fun bar NULL 6666 NULL 99999.0 10.0
+4444 abc fun bar NULL 8888 NULL 99999.0 99999.0
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-2-635031c0752d5b30c44dfb3dec759a6c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-2-635031c0752d5b30c44dfb3dec759a6c b/sql/hive/src/test/resources/golden/view_cast-2-635031c0752d5b30c44dfb3dec759a6c
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-3-9f675e7edd64a33713e91282dc201867
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-3-9f675e7edd64a33713e91282dc201867 b/sql/hive/src/test/resources/golden/view_cast-3-9f675e7edd64a33713e91282dc201867
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-4-d9edb83f4cf847e141d97012314917d4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-4-d9edb83f4cf847e141d97012314917d4 b/sql/hive/src/test/resources/golden/view_cast-4-d9edb83f4cf847e141d97012314917d4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-5-6db508ccd85562a9ca7841fb0a08981a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-5-6db508ccd85562a9ca7841fb0a08981a b/sql/hive/src/test/resources/golden/view_cast-5-6db508ccd85562a9ca7841fb0a08981a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-6-b18da53e46b62d6d91efac88ba62f308
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-6-b18da53e46b62d6d91efac88ba62f308 b/sql/hive/src/test/resources/golden/view_cast-6-b18da53e46b62d6d91efac88ba62f308
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/ade72c43/sql/hive/src/test/resources/golden/view_cast-7-78ac3800b22682b31708b6a09b402bfb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/view_cast-7-78ac3800b22682b31708b6a09b402bfb b/sql/hive/src/test/resources/golden/view_cast-7-78ac3800b22682b31708b6a09b402bfb
new file mode 100644
index 0000000..e69de29
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org