spark-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hvanhov...@apache.org
Subject [2/2] spark git commit: [SPARK-19589][SQL] Removal of SQLGEN files
Date Tue, 14 Feb 2017 08:35:18 GMT
[SPARK-19589][SQL] Removal of SQLGEN files

### What changes were proposed in this pull request?
SQLGen is removed. Thus, the generated files should be removed too.

### How was this patch tested?
N/A

Author: Xiao Li <gatorsmile@gmail.com>

Closes #16921 from gatorsmile/removeSQLGenFiles.


Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/457850e6
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/457850e6
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/457850e6

Branch: refs/heads/master
Commit: 457850e6f57b8e0de44cfe28e177c9b24e27af25
Parents: 9b5e460
Author: Xiao Li <gatorsmile@gmail.com>
Authored: Tue Feb 14 09:35:08 2017 +0100
Committer: Herman van Hovell <hvanhovell@databricks.com>
Committed: Tue Feb 14 09:35:08 2017 +0100

----------------------------------------------------------------------
 sql/hive/src/test/resources/sqlgen/agg1.sql               |  4 ----
 sql/hive/src/test/resources/sqlgen/agg2.sql               |  4 ----
 sql/hive/src/test/resources/sqlgen/agg3.sql               |  4 ----
 .../resources/sqlgen/aggregate_functions_and_window.sql   |  4 ----
 .../src/test/resources/sqlgen/broadcast_join_subquery.sql |  8 --------
 sql/hive/src/test/resources/sqlgen/case.sql               |  4 ----
 sql/hive/src/test/resources/sqlgen/case_with_else.sql     |  4 ----
 sql/hive/src/test/resources/sqlgen/case_with_key.sql      |  4 ----
 .../src/test/resources/sqlgen/case_with_key_and_else.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/cluster_by.sql         |  4 ----
 .../test/resources/sqlgen/data_source_json_parquet_t0.sql |  4 ----
 .../test/resources/sqlgen/data_source_orc_parquet_t0.sql  |  4 ----
 .../resources/sqlgen/data_source_parquet_parquet_t0.sql   |  4 ----
 .../src/test/resources/sqlgen/distinct_aggregation.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/distribute_by.sql      |  4 ----
 .../test/resources/sqlgen/distribute_by_with_sort_by.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/except.sql             |  4 ----
 .../src/test/resources/sqlgen/filter_after_subquery.sql   |  4 ----
 .../src/test/resources/sqlgen/generate_with_other_1.sql   |  8 --------
 .../src/test/resources/sqlgen/generate_with_other_2.sql   | 10 ----------
 .../test/resources/sqlgen/generator_in_lateral_view_1.sql |  4 ----
 .../test/resources/sqlgen/generator_in_lateral_view_2.sql |  4 ----
 .../resources/sqlgen/generator_non_referenced_table_1.sql |  4 ----
 .../resources/sqlgen/generator_non_referenced_table_2.sql |  4 ----
 .../src/test/resources/sqlgen/generator_non_udtf_1.sql    |  4 ----
 .../src/test/resources/sqlgen/generator_non_udtf_2.sql    |  4 ----
 .../resources/sqlgen/generator_referenced_table_1.sql     |  4 ----
 .../resources/sqlgen/generator_referenced_table_2.sql     |  4 ----
 .../resources/sqlgen/generator_with_ambiguous_names_1.sql |  6 ------
 .../resources/sqlgen/generator_with_ambiguous_names_2.sql |  6 ------
 .../test/resources/sqlgen/generator_without_from_1.sql    |  4 ----
 .../test/resources/sqlgen/generator_without_from_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/grouping_sets_1.sql    |  6 ------
 sql/hive/src/test/resources/sqlgen/grouping_sets_2_1.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/grouping_sets_2_2.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/grouping_sets_2_3.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/grouping_sets_2_4.sql  |  4 ----
 sql/hive/src/test/resources/sqlgen/grouping_sets_2_5.sql  |  5 -----
 sql/hive/src/test/resources/sqlgen/in.sql                 |  4 ----
 sql/hive/src/test/resources/sqlgen/inline_tables.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/intersect.sql          |  4 ----
 .../src/test/resources/sqlgen/interval_arithmetic.sql     |  8 --------
 sql/hive/src/test/resources/sqlgen/join_2_tables.sql      |  7 -------
 .../src/test/resources/sqlgen/json_tuple_generator_1.sql  |  6 ------
 .../src/test/resources/sqlgen/json_tuple_generator_2.sql  |  6 ------
 sql/hive/src/test/resources/sqlgen/limit.sql              |  4 ----
 sql/hive/src/test/resources/sqlgen/multi_distinct.sql     |  4 ----
 .../sqlgen/nested_generator_in_lateral_view_1.sql         |  7 -------
 .../sqlgen/nested_generator_in_lateral_view_2.sql         |  7 -------
 sql/hive/src/test/resources/sqlgen/not_in.sql             |  4 ----
 sql/hive/src/test/resources/sqlgen/not_like.sql           |  4 ----
 sql/hive/src/test/resources/sqlgen/predicate_subquery.sql |  4 ----
 sql/hive/src/test/resources/sqlgen/range.sql              |  4 ----
 sql/hive/src/test/resources/sqlgen/range_with_splits.sql  |  4 ----
 .../resources/sqlgen/regular_expressions_and_window.sql   |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_1_1.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_1_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_2_1.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_2_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_3_1.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_3_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_4_1.sql    |  5 -----
 sql/hive/src/test/resources/sqlgen/rollup_cube_4_2.sql    |  5 -----
 sql/hive/src/test/resources/sqlgen/rollup_cube_5_1.sql    |  6 ------
 sql/hive/src/test/resources/sqlgen/rollup_cube_5_2.sql    |  6 ------
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_1.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_3.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_4.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_5.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_6_6.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_7_1.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_7_2.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_7_3.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/rollup_cube_8_1.sql    |  6 ------
 sql/hive/src/test/resources/sqlgen/rollup_cube_8_2.sql    |  6 ------
 sql/hive/src/test/resources/sqlgen/rollup_cube_9_1.sql    |  8 --------
 sql/hive/src/test/resources/sqlgen/rollup_cube_9_2.sql    |  8 --------
 .../src/test/resources/sqlgen/script_transformation_1.sql |  4 ----
 .../src/test/resources/sqlgen/script_transformation_2.sql |  4 ----
 .../resources/sqlgen/script_transformation_alias_list.sql |  4 ----
 .../sqlgen/script_transformation_alias_list_with_type.sql |  6 ------
 .../sqlgen/script_transformation_row_format_multiple.sql  |  8 --------
 .../sqlgen/script_transformation_row_format_one.sql       |  6 ------
 .../sqlgen/script_transformation_row_format_serde.sql     | 10 ----------
 .../script_transformation_row_format_without_serde.sql    |  8 --------
 sql/hive/src/test/resources/sqlgen/select_distinct.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/select_orc_table.sql   |  4 ----
 .../src/test/resources/sqlgen/select_parquet_table.sql    |  4 ----
 sql/hive/src/test/resources/sqlgen/self_join.sql          |  4 ----
 .../src/test/resources/sqlgen/self_join_with_group_by.sql |  4 ----
 .../src/test/resources/sqlgen/sort_asc_nulls_last.sql     |  4 ----
 .../src/test/resources/sqlgen/sort_by_after_having.sql    |  4 ----
 .../src/test/resources/sqlgen/sort_desc_nulls_first.sql   |  4 ----
 sql/hive/src/test/resources/sqlgen/subq2.sql              |  8 --------
 sql/hive/src/test/resources/sqlgen/subquery_exists_1.sql  |  8 --------
 sql/hive/src/test/resources/sqlgen/subquery_exists_2.sql  |  9 ---------
 .../test/resources/sqlgen/subquery_exists_having_1.sql    |  9 ---------
 .../test/resources/sqlgen/subquery_exists_having_2.sql    | 10 ----------
 .../test/resources/sqlgen/subquery_exists_having_3.sql    |  9 ---------
 sql/hive/src/test/resources/sqlgen/subquery_in.sql        |  6 ------
 .../src/test/resources/sqlgen/subquery_in_having_1.sql    |  8 --------
 .../src/test/resources/sqlgen/subquery_in_having_2.sql    | 10 ----------
 .../src/test/resources/sqlgen/subquery_not_exists_1.sql   |  8 --------
 .../src/test/resources/sqlgen/subquery_not_exists_2.sql   |  8 --------
 .../resources/sqlgen/subquery_not_exists_having_1.sql     |  9 ---------
 .../resources/sqlgen/subquery_not_exists_having_2.sql     |  9 ---------
 sql/hive/src/test/resources/sqlgen/tablesample_1.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/tablesample_2.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/tablesample_3.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/tablesample_4.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/tablesample_5.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/tablesample_6.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/three_child_union.sql  |  6 ------
 sql/hive/src/test/resources/sqlgen/type_widening.sql      |  4 ----
 sql/hive/src/test/resources/sqlgen/union_distinct.sql     |  4 ----
 sql/hive/src/test/resources/sqlgen/window_basic_1.sql     |  4 ----
 sql/hive/src/test/resources/sqlgen/window_basic_2.sql     |  5 -----
 sql/hive/src/test/resources/sqlgen/window_basic_3.sql     |  5 -----
 .../test/resources/sqlgen/window_basic_asc_nulls_last.sql |  5 -----
 .../resources/sqlgen/window_basic_desc_nulls_first.sql    |  5 -----
 sql/hive/src/test/resources/sqlgen/window_with_join.sql   |  5 -----
 .../sqlgen/window_with_the_same_window_with_agg.sql       |  7 -------
 .../window_with_the_same_window_with_agg_filter.sql       |  7 -------
 .../window_with_the_same_window_with_agg_functions.sql    |  6 ------
 .../window_with_the_same_window_with_agg_having.sql       |  6 ------
 126 files changed, 654 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/agg1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/agg1.sql b/sql/hive/src/test/resources/sqlgen/agg1.sql
deleted file mode 100644
index 05403a9..0000000
--- a/sql/hive/src/test/resources/sqlgen/agg1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT COUNT(value) FROM parquet_t1 GROUP BY key HAVING MAX(key) > 0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `count(value)` FROM (SELECT `gen_attr_0` FROM (SELECT count(`gen_attr_3`) AS `gen_attr_0`, max(`gen_attr_2`) AS `gen_attr_1` FROM (SELECT `key` AS `gen_attr_2`, `value` AS `gen_attr_3` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_2` HAVING (`gen_attr_1` > CAST(0 AS BIGINT))) AS gen_subquery_1) AS gen_subquery_2

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/agg2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/agg2.sql b/sql/hive/src/test/resources/sqlgen/agg2.sql
deleted file mode 100644
index adbfdb7..0000000
--- a/sql/hive/src/test/resources/sqlgen/agg2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT COUNT(value) FROM parquet_t1 GROUP BY key ORDER BY MAX(key)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `count(value)` FROM (SELECT `gen_attr_0` FROM (SELECT count(`gen_attr_3`) AS `gen_attr_0`, max(`gen_attr_2`) AS `gen_attr_1` FROM (SELECT `key` AS `gen_attr_2`, `value` AS `gen_attr_3` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_2` ORDER BY `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1) AS gen_subquery_2

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/agg3.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/agg3.sql b/sql/hive/src/test/resources/sqlgen/agg3.sql
deleted file mode 100644
index 207542d..0000000
--- a/sql/hive/src/test/resources/sqlgen/agg3.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT COUNT(value) FROM parquet_t1 GROUP BY key ORDER BY key, MAX(key)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `count(value)` FROM (SELECT `gen_attr_0` FROM (SELECT count(`gen_attr_4`) AS `gen_attr_0`, `gen_attr_3` AS `gen_attr_1`, max(`gen_attr_3`) AS `gen_attr_2` FROM (SELECT `key` AS `gen_attr_3`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_3` ORDER BY `gen_attr_1` ASC NULLS FIRST, `gen_attr_2` ASC NULLS FIRST) AS gen_subquery_1) AS gen_subquery_2

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/aggregate_functions_and_window.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/aggregate_functions_and_window.sql b/sql/hive/src/test/resources/sqlgen/aggregate_functions_and_window.sql
deleted file mode 100644
index e3e372d..0000000
--- a/sql/hive/src/test/resources/sqlgen/aggregate_functions_and_window.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT MAX(c) + COUNT(a) OVER () FROM parquet_t2 GROUP BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `(max(c) + count(a) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING))` FROM (SELECT (`gen_attr_1` + `gen_attr_2`) AS `gen_attr_0` FROM (SELECT gen_subquery_1.`gen_attr_1`, gen_subquery_1.`gen_attr_3`, count(`gen_attr_3`) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS `gen_attr_2` FROM (SELECT max(`gen_attr_5`) AS `gen_attr_1`, `gen_attr_3` FROM (SELECT `a` AS `gen_attr_3`, `b` AS `gen_attr_4`, `c` AS `gen_attr_5`, `d` AS `gen_attr_6` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_3`, `gen_attr_4`) AS gen_subquery_1) AS gen_subquery_2) AS gen_subquery_3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/broadcast_join_subquery.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/broadcast_join_subquery.sql b/sql/hive/src/test/resources/sqlgen/broadcast_join_subquery.sql
deleted file mode 100644
index adddc41..0000000
--- a/sql/hive/src/test/resources/sqlgen/broadcast_join_subquery.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT /*+ MAPJOIN(srcpart) */ subq.key1, z.value
-FROM (SELECT x.key as key1, x.value as value1, y.key as key2, y.value as value2
-      FROM src1 x JOIN src y ON (x.key = y.key)) subq
-JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
-ORDER BY subq.key1, z.value
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `key1`, `gen_attr_1` AS `value` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_7` AS `gen_attr_6`, `gen_attr_9` AS `gen_attr_8`, `gen_attr_11` AS `gen_attr_10` FROM (SELECT `key` AS `gen_attr_5`, `value` AS `gen_attr_7` FROM `default`.`src1`) AS gen_subquery_0 INNER JOIN (SELECT `key` AS `gen_attr_9`, `value` AS `gen_attr_11` FROM `default`.`src`) AS gen_subquery_1 ON (`gen_attr_5` = `gen_attr_9`)) AS subq INNER JOIN (SELECT `key` AS `gen_attr_2`, `value` AS `gen_attr_1`, `ds` AS `gen_attr_3`, `hr` AS `gen_attr_4` FROM `default`.`srcpart`) AS gen_subquery_2 ON (((`gen_attr_0` = `gen_attr_2`) AND (`gen_attr_3` = '2008-04-08')) AND (CAST(`gen_attr_4` AS INT) = 11)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/case.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/case.sql b/sql/hive/src/test/resources/sqlgen/case.sql
deleted file mode 100644
index 99630e8..0000000
--- a/sql/hive/src/test/resources/sqlgen/case.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT CASE WHEN id % 2 > 0 THEN 0 WHEN id % 2 = 0 THEN 1 END FROM parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `CASE WHEN ((id % CAST(2 AS BIGINT)) > CAST(0 AS BIGINT)) THEN 0 WHEN ((id % CAST(2 AS BIGINT)) = CAST(0 AS BIGINT)) THEN 1 END` FROM (SELECT CASE WHEN ((`gen_attr_1` % CAST(2 AS BIGINT)) > CAST(0 AS BIGINT)) THEN 0 WHEN ((`gen_attr_1` % CAST(2 AS BIGINT)) = CAST(0 AS BIGINT)) THEN 1 END AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/case_with_else.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/case_with_else.sql b/sql/hive/src/test/resources/sqlgen/case_with_else.sql
deleted file mode 100644
index aed8f08..0000000
--- a/sql/hive/src/test/resources/sqlgen/case_with_else.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT CASE WHEN id % 2 > 0 THEN 0 ELSE 1 END FROM parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `CASE WHEN ((id % CAST(2 AS BIGINT)) > CAST(0 AS BIGINT)) THEN 0 ELSE 1 END` FROM (SELECT CASE WHEN ((`gen_attr_1` % CAST(2 AS BIGINT)) > CAST(0 AS BIGINT)) THEN 0 ELSE 1 END AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/case_with_key.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/case_with_key.sql b/sql/hive/src/test/resources/sqlgen/case_with_key.sql
deleted file mode 100644
index e991eba..0000000
--- a/sql/hive/src/test/resources/sqlgen/case_with_key.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT CASE id WHEN 0 THEN 'foo' WHEN 1 THEN 'bar' END FROM parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `CASE WHEN (id = CAST(0 AS BIGINT)) THEN foo WHEN (id = CAST(1 AS BIGINT)) THEN bar END` FROM (SELECT CASE WHEN (`gen_attr_1` = CAST(0 AS BIGINT)) THEN 'foo' WHEN (`gen_attr_1` = CAST(1 AS BIGINT)) THEN 'bar' END AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/case_with_key_and_else.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/case_with_key_and_else.sql b/sql/hive/src/test/resources/sqlgen/case_with_key_and_else.sql
deleted file mode 100644
index 492777e..0000000
--- a/sql/hive/src/test/resources/sqlgen/case_with_key_and_else.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT CASE id WHEN 0 THEN 'foo' WHEN 1 THEN 'bar' ELSE 'baz' END FROM parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `CASE WHEN (id = CAST(0 AS BIGINT)) THEN foo WHEN (id = CAST(1 AS BIGINT)) THEN bar ELSE baz END` FROM (SELECT CASE WHEN (`gen_attr_1` = CAST(0 AS BIGINT)) THEN 'foo' WHEN (`gen_attr_1` = CAST(1 AS BIGINT)) THEN 'bar' ELSE 'baz' END AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/cluster_by.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/cluster_by.sql b/sql/hive/src/test/resources/sqlgen/cluster_by.sql
deleted file mode 100644
index 3154791..0000000
--- a/sql/hive/src/test/resources/sqlgen/cluster_by.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM parquet_t0 CLUSTER BY id
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`parquet_t0`) AS gen_subquery_0 CLUSTER BY `gen_attr_0`) AS parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/data_source_json_parquet_t0.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/data_source_json_parquet_t0.sql b/sql/hive/src/test/resources/sqlgen/data_source_json_parquet_t0.sql
deleted file mode 100644
index e41b645..0000000
--- a/sql/hive/src/test/resources/sqlgen/data_source_json_parquet_t0.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM json_parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`json_parquet_t0`) AS gen_subquery_0) AS json_parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/data_source_orc_parquet_t0.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/data_source_orc_parquet_t0.sql b/sql/hive/src/test/resources/sqlgen/data_source_orc_parquet_t0.sql
deleted file mode 100644
index f5ceccd..0000000
--- a/sql/hive/src/test/resources/sqlgen/data_source_orc_parquet_t0.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM orc_parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`orc_parquet_t0`) AS gen_subquery_0) AS orc_parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/data_source_parquet_parquet_t0.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/data_source_parquet_parquet_t0.sql b/sql/hive/src/test/resources/sqlgen/data_source_parquet_parquet_t0.sql
deleted file mode 100644
index 2bccefe..0000000
--- a/sql/hive/src/test/resources/sqlgen/data_source_parquet_parquet_t0.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM parquet_parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`parquet_parquet_t0`) AS gen_subquery_0) AS parquet_parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/distinct_aggregation.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/distinct_aggregation.sql b/sql/hive/src/test/resources/sqlgen/distinct_aggregation.sql
deleted file mode 100644
index bced711..0000000
--- a/sql/hive/src/test/resources/sqlgen/distinct_aggregation.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT COUNT(DISTINCT id) FROM parquet_t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `count(DISTINCT id)` FROM (SELECT count(DISTINCT `gen_attr_1`) AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/distribute_by.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/distribute_by.sql b/sql/hive/src/test/resources/sqlgen/distribute_by.sql
deleted file mode 100644
index 72863dc..0000000
--- a/sql/hive/src/test/resources/sqlgen/distribute_by.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM parquet_t0 DISTRIBUTE BY id
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`parquet_t0`) AS gen_subquery_0 DISTRIBUTE BY `gen_attr_0`) AS parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/distribute_by_with_sort_by.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/distribute_by_with_sort_by.sql b/sql/hive/src/test/resources/sqlgen/distribute_by_with_sort_by.sql
deleted file mode 100644
index 96b9b2d..0000000
--- a/sql/hive/src/test/resources/sqlgen/distribute_by_with_sort_by.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM parquet_t0 DISTRIBUTE BY id SORT BY id
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`parquet_t0`) AS gen_subquery_0 CLUSTER BY `gen_attr_0`) AS parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/except.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/except.sql b/sql/hive/src/test/resources/sqlgen/except.sql
deleted file mode 100644
index 7a7d27f..0000000
--- a/sql/hive/src/test/resources/sqlgen/except.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT * FROM t0 EXCEPT SELECT * FROM t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM ((SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`t0`) AS gen_subquery_0 ) EXCEPT ( SELECT `gen_attr_1` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`t0`) AS gen_subquery_1)) AS t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/filter_after_subquery.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/filter_after_subquery.sql b/sql/hive/src/test/resources/sqlgen/filter_after_subquery.sql
deleted file mode 100644
index 9cd6514..0000000
--- a/sql/hive/src/test/resources/sqlgen/filter_after_subquery.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a FROM (SELECT key + 1 AS a FROM parquet_t1) t WHERE a > 5
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a` FROM (SELECT `gen_attr_0` FROM (SELECT (`gen_attr_1` + CAST(1 AS BIGINT)) AS `gen_attr_0` FROM (SELECT `key` AS `gen_attr_1`, `value` AS `gen_attr_2` FROM `default`.`parquet_t1`) AS gen_subquery_0) AS t WHERE (`gen_attr_0` > CAST(5 AS BIGINT))) AS t

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generate_with_other_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generate_with_other_1.sql b/sql/hive/src/test/resources/sqlgen/generate_with_other_1.sql
deleted file mode 100644
index 0739f8f..0000000
--- a/sql/hive/src/test/resources/sqlgen/generate_with_other_1.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(arr) AS val, id
-FROM parquet_t3
-WHERE id > 2
-ORDER BY val, id
-LIMIT 5
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM ((SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT gen_subquery_0.`gen_attr_2`, gen_subquery_0.`gen_attr_3`, gen_subquery_0.`gen_attr_4`, gen_subquery_0.`gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 WHERE (`gen_attr_1` > CAST(2 AS BIGINT))) AS gen_subquery_1 LATERAL VIEW explode(`gen_attr_2`) gen_subquery_2 AS `gen_attr_0` ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST LIMIT 5)) AS parquet_t3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generate_with_other_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generate_with_other_2.sql b/sql/hive/src/test/resources/sqlgen/generate_with_other_2.sql
deleted file mode 100644
index c4b344e..0000000
--- a/sql/hive/src/test/resources/sqlgen/generate_with_other_2.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT val, id
-FROM parquet_t3
-LATERAL VIEW EXPLODE(arr2) exp1 AS nested_array
-LATERAL VIEW EXPLODE(nested_array) exp1 AS val
-WHERE val > 2
-ORDER BY val, id
-LIMIT 5
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM ((SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_5`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_3`) gen_subquery_2 AS `gen_attr_2` LATERAL VIEW explode(`gen_attr_2`) gen_subquery_3 AS `gen_attr_0` WHERE (`gen_attr_0` > CAST(2 AS BIGINT)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST LIMIT 5)) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_1.sql b/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_1.sql
deleted file mode 100644
index 2f6596e..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT val, id FROM parquet_t3 LATERAL VIEW EXPLODE(arr) exp AS val
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_2`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_2.sql b/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_2.sql
deleted file mode 100644
index 239980d..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_in_lateral_view_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT val, id FROM parquet_t3 LATERAL VIEW OUTER EXPLODE(arr) exp AS val
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW OUTER explode(`gen_attr_2`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_1.sql b/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_1.sql
deleted file mode 100644
index 7fe0298..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(ARRAY(1,2,3)) FROM t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `col` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`t0`) AS gen_subquery_0 LATERAL VIEW explode(array(1, 2, 3)) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_2.sql b/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_2.sql
deleted file mode 100644
index 8db834a..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_non_referenced_table_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(ARRAY(1,2,3)) AS val FROM t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`t0`) AS gen_subquery_0 LATERAL VIEW explode(array(1, 2, 3)) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_non_udtf_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_non_udtf_1.sql b/sql/hive/src/test/resources/sqlgen/generator_non_udtf_1.sql
deleted file mode 100644
index fef65e0..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_non_udtf_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(arr), id FROM parquet_t3
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `col`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_2`) gen_subquery_1 AS `gen_attr_0`) AS parquet_t3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_non_udtf_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_non_udtf_2.sql b/sql/hive/src/test/resources/sqlgen/generator_non_udtf_2.sql
deleted file mode 100644
index e0e3108..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_non_udtf_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(arr) AS val, id as a FROM parquet_t3
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `a` FROM (SELECT `gen_attr_0`, `gen_attr_2` AS `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_3`, `arr2` AS `gen_attr_4`, `json` AS `gen_attr_5`, `id` AS `gen_attr_2` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_3`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_referenced_table_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_referenced_table_1.sql b/sql/hive/src/test/resources/sqlgen/generator_referenced_table_1.sql
deleted file mode 100644
index ea5db85..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_referenced_table_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(arr) FROM parquet_t3
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `col` FROM (SELECT `gen_attr_0` FROM (SELECT `arr` AS `gen_attr_1`, `arr2` AS `gen_attr_2`, `json` AS `gen_attr_3`, `id` AS `gen_attr_4` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_1`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_referenced_table_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_referenced_table_2.sql b/sql/hive/src/test/resources/sqlgen/generator_referenced_table_2.sql
deleted file mode 100644
index 8f75b82..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_referenced_table_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(arr) AS val FROM parquet_t3
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val` FROM (SELECT `gen_attr_0` FROM (SELECT `arr` AS `gen_attr_1`, `arr2` AS `gen_attr_2`, `json` AS `gen_attr_3`, `id` AS `gen_attr_4` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_1`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_1.sql b/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_1.sql
deleted file mode 100644
index 984cce8..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_1.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT exp.id, parquet_t3.id
-FROM parquet_t3
-LATERAL VIEW EXPLODE(arr) exp AS id
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_2`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_2.sql b/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_2.sql
deleted file mode 100644
index 5c55b16..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_with_ambiguous_names_2.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT exp.id, parquet_t3.id
-FROM parquet_t3
-LATERAL VIEW OUTER EXPLODE(arr) exp AS id
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_2`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_4`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW OUTER explode(`gen_attr_2`) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_without_from_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_without_from_1.sql b/sql/hive/src/test/resources/sqlgen/generator_without_from_1.sql
deleted file mode 100644
index ee22fe8..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_without_from_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(ARRAY(1,2,3))
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `col` FROM (SELECT `gen_attr_0` FROM (SELECT 1) gen_subquery_1 LATERAL VIEW explode(array(1, 2, 3)) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/generator_without_from_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/generator_without_from_2.sql b/sql/hive/src/test/resources/sqlgen/generator_without_from_2.sql
deleted file mode 100644
index 0acded7..0000000
--- a/sql/hive/src/test/resources/sqlgen/generator_without_from_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT EXPLODE(ARRAY(1,2,3)) AS val
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val` FROM (SELECT `gen_attr_0` FROM (SELECT 1) gen_subquery_1 LATERAL VIEW explode(array(1, 2, 3)) gen_subquery_2 AS `gen_attr_0`) AS gen_subquery_0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_1.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_1.sql
deleted file mode 100644
index db2b2cc..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_1.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) AS cnt, key % 5 AS k1, key - 5 AS k2, grouping_id() AS k3
-FROM (SELECT key, key % 2, key - 5 FROM parquet_t1) t GROUP BY key % 5, key - 5
-GROUPING SETS (key % 5, key - 5)
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `cnt`, `gen_attr_4` AS `k1`, `gen_attr_5` AS `k2`, `gen_attr_6` AS `k3` FROM (SELECT count(1) AS `gen_attr_3`, (`gen_attr_7` % CAST(5 AS BIGINT)) AS `gen_attr_4`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_5`, grouping_id() AS `gen_attr_6` FROM (SELECT `gen_attr_7`, (`gen_attr_7` % CAST(2 AS BIGINT)) AS `gen_attr_8`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_9` FROM (SELECT `key` AS `gen_attr_7`, `value` AS `gen_attr_12` FROM `default`.`parquet_t1`) AS gen_subquery_0) AS t GROUP BY (`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_7` % CAST(5 AS BIGINT))), ((`gen_attr_7` - CAST(5 AS BIGINT))))) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_2_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_1.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_2_1.sql
deleted file mode 100644
index 245b523..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY a, b GROUPING SETS (a, b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((`gen_attr_5`), (`gen_attr_6`)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_2_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_2.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_2_2.sql
deleted file mode 100644
index 1505dea..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY a, b GROUPING SETS (a) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((`gen_attr_5`)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_2_3.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_3.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_2_3.sql
deleted file mode 100644
index 281add6..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_3.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY a, b GROUPING SETS (b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((`gen_attr_6`)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_2_4.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_4.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_2_4.sql
deleted file mode 100644
index f8d6474..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_4.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY a, b GROUPING SETS (()) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS(()) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/grouping_sets_2_5.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_5.sql b/sql/hive/src/test/resources/sqlgen/grouping_sets_2_5.sql
deleted file mode 100644
index 09e6ec2..0000000
--- a/sql/hive/src/test/resources/sqlgen/grouping_sets_2_5.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY a, b
-GROUPING SETS ((), (a), (a, b)) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((), (`gen_attr_5`), (`gen_attr_5`, `gen_attr_6`)) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/in.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/in.sql b/sql/hive/src/test/resources/sqlgen/in.sql
deleted file mode 100644
index 7cff62b..0000000
--- a/sql/hive/src/test/resources/sqlgen/in.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM parquet_t0 WHERE id IN (1, 2, 3)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`parquet_t0`) AS gen_subquery_0 WHERE (CAST(`gen_attr_0` AS BIGINT) IN (CAST(1 AS BIGINT), CAST(2 AS BIGINT), CAST(3 AS BIGINT)))) AS parquet_t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/inline_tables.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/inline_tables.sql b/sql/hive/src/test/resources/sqlgen/inline_tables.sql
deleted file mode 100644
index 18803a3..0000000
--- a/sql/hive/src/test/resources/sqlgen/inline_tables.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-select * from values ("one", 1), ("two", 2), ("three", null) as data(a, b) where b > 1
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (VALUES ('one', 1), ('two', 2), ('three', CAST(NULL AS INT)) AS gen_subquery_0(gen_attr_0, gen_attr_1)) AS data WHERE (`gen_attr_1` > 1)) AS data

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/intersect.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/intersect.sql b/sql/hive/src/test/resources/sqlgen/intersect.sql
deleted file mode 100644
index 4143a62..0000000
--- a/sql/hive/src/test/resources/sqlgen/intersect.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT * FROM t0 INTERSECT SELECT * FROM t0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM ((SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`t0`) AS gen_subquery_0 ) INTERSECT ( SELECT `gen_attr_1` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`t0`) AS gen_subquery_1)) AS t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/interval_arithmetic.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/interval_arithmetic.sql b/sql/hive/src/test/resources/sqlgen/interval_arithmetic.sql
deleted file mode 100644
index 31d0034..0000000
--- a/sql/hive/src/test/resources/sqlgen/interval_arithmetic.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-select ts + interval 1 day, ts + interval 2 days,
-       ts - interval 1 day, ts - interval 2 days,
-       ts + interval '1' day, ts + interval '2' days,
-       ts - interval '1' day, ts - interval '2' days
-from dates
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `CAST(ts + interval 1 days AS TIMESTAMP)`, `gen_attr_2` AS `CAST(ts + interval 2 days AS TIMESTAMP)`, `gen_attr_3` AS `CAST(ts - interval 1 days AS TIMESTAMP)`, `gen_attr_4` AS `CAST(ts - interval 2 days AS TIMESTAMP)`, `gen_attr_5` AS `CAST(ts + interval 1 days AS TIMESTAMP)`, `gen_attr_6` AS `CAST(ts + interval 2 days AS TIMESTAMP)`, `gen_attr_7` AS `CAST(ts - interval 1 days AS TIMESTAMP)`, `gen_attr_8` AS `CAST(ts - interval 2 days AS TIMESTAMP)` FROM (SELECT CAST(`gen_attr_1` + interval 1 days AS TIMESTAMP) AS `gen_attr_0`, CAST(`gen_attr_1` + interval 2 days AS TIMESTAMP) AS `gen_attr_2`, CAST(`gen_attr_1` - interval 1 days AS TIMESTAMP) AS `gen_attr_3`, CAST(`gen_attr_1` - interval 2 days AS TIMESTAMP) AS `gen_attr_4`, CAST(`gen_attr_1` + interval 1 days AS TIMESTAMP) AS `gen_attr_5`, CAST(`gen_attr_1` + interval 2 days AS TIMESTAMP) AS `gen_attr_6`, CAST(`gen_attr_1` - interval 1 days AS TIMESTAMP) AS `gen_attr_7`, CAST(`gen_attr_1` - interval 2 days A
 S TIMESTAMP) AS `gen_attr_8` FROM (SELECT `ts` AS `gen_attr_1` FROM `default`.`dates`) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/join_2_tables.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/join_2_tables.sql b/sql/hive/src/test/resources/sqlgen/join_2_tables.sql
deleted file mode 100644
index 0f033a0..0000000
--- a/sql/hive/src/test/resources/sqlgen/join_2_tables.sql
+++ /dev/null
@@ -1,7 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT COUNT(a.value), b.KEY, a.KEY
-FROM parquet_t1 a CROSS JOIN parquet_t1 b
-GROUP BY a.KEY, b.KEY
-HAVING MAX(a.KEY) > 0
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `count(value)`, `gen_attr_1` AS `KEY`, `gen_attr_2` AS `KEY` FROM (SELECT `gen_attr_0`, `gen_attr_1`, `gen_attr_2` FROM (SELECT count(`gen_attr_4`) AS `gen_attr_0`, `gen_attr_1`, `gen_attr_2`, max(`gen_attr_2`) AS `gen_attr_3` FROM (SELECT `key` AS `gen_attr_2`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 CROSS JOIN (SELECT `key` AS `gen_attr_1`, `value` AS `gen_attr_5` FROM `default`.`parquet_t1`) AS gen_subquery_1 GROUP BY `gen_attr_2`, `gen_attr_1` HAVING (`gen_attr_3` > CAST(0 AS BIGINT))) AS gen_subquery_2) AS gen_subquery_3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/json_tuple_generator_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/json_tuple_generator_1.sql b/sql/hive/src/test/resources/sqlgen/json_tuple_generator_1.sql
deleted file mode 100644
index 11e45a4..0000000
--- a/sql/hive/src/test/resources/sqlgen/json_tuple_generator_1.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT c0, c1, c2
-FROM parquet_t3
-LATERAL VIEW JSON_TUPLE(json, 'f1', 'f2', 'f3') jt
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `c0`, `gen_attr_1` AS `c1`, `gen_attr_2` AS `c2` FROM (SELECT `gen_attr_0`, `gen_attr_1`, `gen_attr_2` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_5`, `json` AS `gen_attr_3`, `id` AS `gen_attr_6` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW json_tuple(`gen_attr_3`, 'f1', 'f2', 'f3') gen_subquery_1 AS `gen_attr_0`, `gen_attr_1`, `gen_attr_2`) AS jt

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql b/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql
deleted file mode 100644
index d86b39d..0000000
--- a/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, c
-FROM parquet_t3
-LATERAL VIEW JSON_TUPLE(json, 'f1', 'f2', 'f3') jt AS a, b, c
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_2` AS `c` FROM (SELECT `gen_attr_0`, `gen_attr_1`, `gen_attr_2` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_5`, `json` AS `gen_attr_3`, `id` AS `gen_attr_6` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW json_tuple(`gen_attr_3`, 'f1', 'f2', 'f3') gen_subquery_1 AS `gen_attr_0`, `gen_attr_1`, `gen_attr_2`) AS jt

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/limit.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/limit.sql b/sql/hive/src/test/resources/sqlgen/limit.sql
deleted file mode 100644
index 7a6b060..0000000
--- a/sql/hive/src/test/resources/sqlgen/limit.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT * FROM (SELECT id FROM tbl LIMIT 2)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0`, `name` AS `gen_attr_1` FROM `default`.`tbl`) AS gen_subquery_0 LIMIT 2)) AS tbl

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/multi_distinct.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/multi_distinct.sql b/sql/hive/src/test/resources/sqlgen/multi_distinct.sql
deleted file mode 100644
index 3ca526f..0000000
--- a/sql/hive/src/test/resources/sqlgen/multi_distinct.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, COUNT(DISTINCT b), COUNT(DISTINCT c), SUM(d) FROM parquet_t2 GROUP BY a
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `count(DISTINCT b)`, `gen_attr_3` AS `count(DISTINCT c)`, `gen_attr_5` AS `sum(d)` FROM (SELECT `gen_attr_0`, count(DISTINCT `gen_attr_2`) AS `gen_attr_1`, count(DISTINCT `gen_attr_4`) AS `gen_attr_3`, sum(`gen_attr_6`) AS `gen_attr_5` FROM (SELECT `a` AS `gen_attr_0`, `b` AS `gen_attr_2`, `c` AS `gen_attr_4`, `d` AS `gen_attr_6` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_0`) AS parquet_t2

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_1.sql b/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_1.sql
deleted file mode 100644
index e681c2b..0000000
--- a/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_1.sql
+++ /dev/null
@@ -1,7 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT val, id
-FROM parquet_t3
-LATERAL VIEW EXPLODE(arr2) exp1 AS nested_array
-LATERAL VIEW EXPLODE(nested_array) exp1 AS val
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_5`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_3`) gen_subquery_2 AS `gen_attr_2` LATERAL VIEW explode(`gen_attr_2`) gen_subquery_3 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_2.sql b/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_2.sql
deleted file mode 100644
index e9d6522..0000000
--- a/sql/hive/src/test/resources/sqlgen/nested_generator_in_lateral_view_2.sql
+++ /dev/null
@@ -1,7 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT val, id
-FROM parquet_t3
-LATERAL VIEW EXPLODE(arr2) exp1 AS nested_array
-LATERAL VIEW OUTER EXPLODE(nested_array) exp1 AS val
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `val`, `gen_attr_1` AS `id` FROM (SELECT `gen_attr_0`, `gen_attr_1` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_3`, `json` AS `gen_attr_5`, `id` AS `gen_attr_1` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW explode(`gen_attr_3`) gen_subquery_2 AS `gen_attr_2` LATERAL VIEW OUTER explode(`gen_attr_2`) gen_subquery_3 AS `gen_attr_0`) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/not_in.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/not_in.sql b/sql/hive/src/test/resources/sqlgen/not_in.sql
deleted file mode 100644
index 797d22e..0000000
--- a/sql/hive/src/test/resources/sqlgen/not_in.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM t0 WHERE id NOT IN (1, 2, 3)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`t0`) AS gen_subquery_0 WHERE (NOT (CAST(`gen_attr_0` AS BIGINT) IN (CAST(1 AS BIGINT), CAST(2 AS BIGINT), CAST(3 AS BIGINT))))) AS t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/not_like.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/not_like.sql b/sql/hive/src/test/resources/sqlgen/not_like.sql
deleted file mode 100644
index 2248504..0000000
--- a/sql/hive/src/test/resources/sqlgen/not_like.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT id FROM t0 WHERE id + 5 NOT LIKE '1%'
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`t0`) AS gen_subquery_0 WHERE (NOT CAST((`gen_attr_0` + CAST(5 AS BIGINT)) AS STRING) LIKE '1%')) AS t0

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/predicate_subquery.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/predicate_subquery.sql b/sql/hive/src/test/resources/sqlgen/predicate_subquery.sql
deleted file mode 100644
index 6e5bd98..0000000
--- a/sql/hive/src/test/resources/sqlgen/predicate_subquery.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-select * from t1 b where exists (select * from t1 a)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a` FROM (SELECT `gen_attr_0` FROM (SELECT `a` AS `gen_attr_0` FROM `default`.`t1`) AS gen_subquery_0 WHERE EXISTS(SELECT `gen_attr_1` AS `a` FROM ((SELECT `gen_attr_1` FROM (SELECT `a` AS `gen_attr_1` FROM `default`.`t1`) AS gen_subquery_2) AS gen_subquery_1) AS gen_subquery_1)) AS b

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/range.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/range.sql b/sql/hive/src/test/resources/sqlgen/range.sql
deleted file mode 100644
index 53c72ea..0000000
--- a/sql/hive/src/test/resources/sqlgen/range.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-select * from range(100)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT id AS `gen_attr_0` FROM range(0, 100, 1)) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/range_with_splits.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/range_with_splits.sql b/sql/hive/src/test/resources/sqlgen/range_with_splits.sql
deleted file mode 100644
index 83d637d..0000000
--- a/sql/hive/src/test/resources/sqlgen/range_with_splits.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-select * from range(1, 100, 20, 10)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `id` FROM (SELECT `gen_attr_0` FROM (SELECT id AS `gen_attr_0` FROM range(1, 100, 20, 10)) AS gen_subquery_0) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/regular_expressions_and_window.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/regular_expressions_and_window.sql b/sql/hive/src/test/resources/sqlgen/regular_expressions_and_window.sql
deleted file mode 100644
index 37cd556..0000000
--- a/sql/hive/src/test/resources/sqlgen/regular_expressions_and_window.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT MAX(key) OVER (PARTITION BY key % 3) + key FROM parquet_t1
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `(max(key) OVER (PARTITION BY (key % CAST(3 AS BIGINT)) ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) + key)` FROM (SELECT (`gen_attr_1` + `gen_attr_2`) AS `gen_attr_0` FROM (SELECT gen_subquery_1.`gen_attr_2`, gen_subquery_1.`gen_attr_3`, max(`gen_attr_2`) OVER (PARTITION BY `gen_attr_3` ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS `gen_attr_1` FROM (SELECT `gen_attr_2`, (`gen_attr_2` % CAST(3 AS BIGINT)) AS `gen_attr_3` FROM (SELECT `key` AS `gen_attr_2`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0) AS gen_subquery_1) AS gen_subquery_2) AS gen_subquery_3

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_1_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_1_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_1_1.sql
deleted file mode 100644
index c54963a..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_1_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) as cnt, key%5, grouping_id() FROM parquet_t1 GROUP BY key % 5 WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_2` AS `cnt`, `gen_attr_3` AS `(key % CAST(5 AS BIGINT))`, `gen_attr_4` AS `grouping_id()` FROM (SELECT count(1) AS `gen_attr_2`, (`gen_attr_5` % CAST(5 AS BIGINT)) AS `gen_attr_3`, grouping_id() AS `gen_attr_4` FROM (SELECT `key` AS `gen_attr_5`, `value` AS `gen_attr_6` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY (`gen_attr_5` % CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_5` % CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_1_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_1_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_1_2.sql
deleted file mode 100644
index 6c86906..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_1_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) as cnt, key%5, grouping_id() FROM parquet_t1 GROUP BY key % 5 WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_2` AS `cnt`, `gen_attr_3` AS `(key % CAST(5 AS BIGINT))`, `gen_attr_4` AS `grouping_id()` FROM (SELECT count(1) AS `gen_attr_2`, (`gen_attr_5` % CAST(5 AS BIGINT)) AS `gen_attr_3`, grouping_id() AS `gen_attr_4` FROM (SELECT `key` AS `gen_attr_5`, `value` AS `gen_attr_6` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY (`gen_attr_5` % CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_5` % CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_2_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_2_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_2_1.sql
deleted file mode 100644
index 9628e38..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_2_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT key, value, count(value) FROM parquet_t1 GROUP BY key, value WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `key`, `gen_attr_1` AS `value`, `gen_attr_3` AS `count(value)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_4` AS `gen_attr_1`, count(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `key` AS `gen_attr_5`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_4` GROUPING SETS((`gen_attr_5`, `gen_attr_4`), (`gen_attr_5`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_2_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_2_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_2_2.sql
deleted file mode 100644
index d6b6192..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_2_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT key, value, count(value) FROM parquet_t1 GROUP BY key, value WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `key`, `gen_attr_1` AS `value`, `gen_attr_3` AS `count(value)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_4` AS `gen_attr_1`, count(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `key` AS `gen_attr_5`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_4` GROUPING SETS((`gen_attr_5`, `gen_attr_4`), (`gen_attr_5`), (`gen_attr_4`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_3_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_3_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_3_1.sql
deleted file mode 100644
index d04b657..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_3_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT key, count(value), grouping_id() FROM parquet_t1 GROUP BY key, value WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `key`, `gen_attr_3` AS `count(value)`, `gen_attr_5` AS `grouping_id()` FROM (SELECT `gen_attr_6` AS `gen_attr_0`, count(`gen_attr_4`) AS `gen_attr_3`, grouping_id() AS `gen_attr_5` FROM (SELECT `key` AS `gen_attr_6`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_6`, `gen_attr_4` GROUPING SETS((`gen_attr_6`, `gen_attr_4`), (`gen_attr_6`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_3_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_3_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_3_2.sql
deleted file mode 100644
index 80a5d93..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_3_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT key, count(value), grouping_id() FROM parquet_t1 GROUP BY key, value WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `key`, `gen_attr_3` AS `count(value)`, `gen_attr_5` AS `grouping_id()` FROM (SELECT `gen_attr_6` AS `gen_attr_0`, count(`gen_attr_4`) AS `gen_attr_3`, grouping_id() AS `gen_attr_5` FROM (SELECT `key` AS `gen_attr_6`, `value` AS `gen_attr_4` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY `gen_attr_6`, `gen_attr_4` GROUPING SETS((`gen_attr_6`, `gen_attr_4`), (`gen_attr_6`), (`gen_attr_4`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_4_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_4_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_4_1.sql
deleted file mode 100644
index 619a554..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_4_1.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) as cnt, key % 5 as k1, key - 5 as k2, grouping_id() FROM parquet_t1
-GROUP BY key % 5, key - 5 WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `cnt`, `gen_attr_4` AS `k1`, `gen_attr_5` AS `k2`, `gen_attr_6` AS `grouping_id()` FROM (SELECT count(1) AS `gen_attr_3`, (`gen_attr_7` % CAST(5 AS BIGINT)) AS `gen_attr_4`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_5`, grouping_id() AS `gen_attr_6` FROM (SELECT `key` AS `gen_attr_7`, `value` AS `gen_attr_8` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY (`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT))), ((`gen_attr_7` % CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_4_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_4_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_4_2.sql
deleted file mode 100644
index 8bf1645..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_4_2.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) as cnt, key % 5 as k1, key - 5 as k2, grouping_id() FROM parquet_t1
-GROUP BY key % 5, key - 5 WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `cnt`, `gen_attr_4` AS `k1`, `gen_attr_5` AS `k2`, `gen_attr_6` AS `grouping_id()` FROM (SELECT count(1) AS `gen_attr_3`, (`gen_attr_7` % CAST(5 AS BIGINT)) AS `gen_attr_4`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_5`, grouping_id() AS `gen_attr_6` FROM (SELECT `key` AS `gen_attr_7`, `value` AS `gen_attr_8` FROM `default`.`parquet_t1`) AS gen_subquery_0 GROUP BY (`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT))), ((`gen_attr_7` % CAST(5 AS BIGINT))), ((`gen_attr_7` - CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_5_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_5_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_5_1.sql
deleted file mode 100644
index 17e78a0..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_5_1.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) AS cnt, key % 5 AS k1, key - 5 AS k2, grouping_id(key % 5, key - 5) AS k3
-FROM (SELECT key, key%2, key - 5 FROM parquet_t1) t GROUP BY key%5, key-5
-WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `cnt`, `gen_attr_4` AS `k1`, `gen_attr_5` AS `k2`, `gen_attr_6` AS `k3` FROM (SELECT count(1) AS `gen_attr_3`, (`gen_attr_7` % CAST(5 AS BIGINT)) AS `gen_attr_4`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_5`, grouping_id() AS `gen_attr_6` FROM (SELECT `gen_attr_7`, (`gen_attr_7` % CAST(2 AS BIGINT)) AS `gen_attr_8`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_9` FROM (SELECT `key` AS `gen_attr_7`, `value` AS `gen_attr_12` FROM `default`.`parquet_t1`) AS gen_subquery_0) AS t GROUP BY (`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT))), ((`gen_attr_7` % CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_5_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_5_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_5_2.sql
deleted file mode 100644
index 72506ef..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_5_2.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT count(*) AS cnt, key % 5 AS k1, key - 5 AS k2, grouping_id(key % 5, key - 5) AS k3
-FROM (SELECT key, key % 2, key - 5 FROM parquet_t1) t GROUP BY key % 5, key - 5
-WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `cnt`, `gen_attr_4` AS `k1`, `gen_attr_5` AS `k2`, `gen_attr_6` AS `k3` FROM (SELECT count(1) AS `gen_attr_3`, (`gen_attr_7` % CAST(5 AS BIGINT)) AS `gen_attr_4`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_5`, grouping_id() AS `gen_attr_6` FROM (SELECT `gen_attr_7`, (`gen_attr_7` % CAST(2 AS BIGINT)) AS `gen_attr_8`, (`gen_attr_7` - CAST(5 AS BIGINT)) AS `gen_attr_9` FROM (SELECT `key` AS `gen_attr_7`, `value` AS `gen_attr_12` FROM `default`.`parquet_t1`) AS gen_subquery_0) AS t GROUP BY (`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT)) GROUPING SETS(((`gen_attr_7` % CAST(5 AS BIGINT)), (`gen_attr_7` - CAST(5 AS BIGINT))), ((`gen_attr_7` % CAST(5 AS BIGINT))), ((`gen_attr_7` - CAST(5 AS BIGINT))), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_1.sql
deleted file mode 100644
index c364c32..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY ROLLUP(a, b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((`gen_attr_5`, `gen_attr_6`), (`gen_attr_5`), ()) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_2.sql
deleted file mode 100644
index 36c0223..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(c) FROM parquet_t2 GROUP BY CUBE(a, b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(c)` FROM (SELECT `gen_attr_5` AS `gen_attr_0`, `gen_attr_6` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_4`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_5`, `gen_attr_6` GROUPING SETS((`gen_attr_5`, `gen_attr_6`), (`gen_attr_5`), (`gen_attr_6`), ()) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_3.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_3.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_3.sql
deleted file mode 100644
index ed33f2a..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_3.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(a) FROM parquet_t2 GROUP BY ROLLUP(a, b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(a)` FROM (SELECT `gen_attr_4` AS `gen_attr_0`, `gen_attr_5` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_4`, `b` AS `gen_attr_5`, `c` AS `gen_attr_6`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_4`, `gen_attr_5` GROUPING SETS((`gen_attr_4`, `gen_attr_5`), (`gen_attr_4`), ()) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_4.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_4.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_4.sql
deleted file mode 100644
index e0e4024..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_4.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, sum(a) FROM parquet_t2 GROUP BY CUBE(a, b) ORDER BY a, b
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `sum(a)` FROM (SELECT `gen_attr_4` AS `gen_attr_0`, `gen_attr_5` AS `gen_attr_1`, sum(`gen_attr_4`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_4`, `b` AS `gen_attr_5`, `c` AS `gen_attr_6`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_4`, `gen_attr_5` GROUPING SETS((`gen_attr_4`, `gen_attr_5`), (`gen_attr_4`), (`gen_attr_5`), ()) ORDER BY `gen_attr_0` ASC NULLS FIRST, `gen_attr_1` ASC NULLS FIRST) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_5.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_5.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_5.sql
deleted file mode 100644
index 26885a2..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_5.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a + b, b, sum(a - b) FROM parquet_t2 GROUP BY a + b, b WITH ROLLUP
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `(a + b)`, `gen_attr_1` AS `b`, `gen_attr_4` AS `sum((a - b))` FROM (SELECT (`gen_attr_5` + `gen_attr_6`) AS `gen_attr_3`, `gen_attr_6` AS `gen_attr_1`, sum((`gen_attr_5` - `gen_attr_6`)) AS `gen_attr_4` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_7`, `d` AS `gen_attr_8` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY (`gen_attr_5` + `gen_attr_6`), `gen_attr_6` GROUPING SETS(((`gen_attr_5` + `gen_attr_6`), `gen_attr_6`), ((`gen_attr_5` + `gen_attr_6`)), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_6_6.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_6.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_6_6.sql
deleted file mode 100644
index dd97c97..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_6_6.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a + b, b, sum(a - b) FROM parquet_t2 GROUP BY a + b, b WITH CUBE
---------------------------------------------------------------------------------
-SELECT `gen_attr_3` AS `(a + b)`, `gen_attr_1` AS `b`, `gen_attr_4` AS `sum((a - b))` FROM (SELECT (`gen_attr_5` + `gen_attr_6`) AS `gen_attr_3`, `gen_attr_6` AS `gen_attr_1`, sum((`gen_attr_5` - `gen_attr_6`)) AS `gen_attr_4` FROM (SELECT `a` AS `gen_attr_5`, `b` AS `gen_attr_6`, `c` AS `gen_attr_7`, `d` AS `gen_attr_8` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY (`gen_attr_5` + `gen_attr_6`), `gen_attr_6` GROUPING SETS(((`gen_attr_5` + `gen_attr_6`), `gen_attr_6`), ((`gen_attr_5` + `gen_attr_6`)), (`gen_attr_6`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_7_1.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_7_1.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_7_1.sql
deleted file mode 100644
index aae2d75..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_7_1.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, grouping_id(a, b) FROM parquet_t2 GROUP BY cube(a, b)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `grouping_id(a, b)` FROM (SELECT `gen_attr_4` AS `gen_attr_0`, `gen_attr_5` AS `gen_attr_1`, grouping_id() AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_4`, `b` AS `gen_attr_5`, `c` AS `gen_attr_6`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_4`, `gen_attr_5` GROUPING SETS((`gen_attr_4`, `gen_attr_5`), (`gen_attr_4`), (`gen_attr_5`), ())) AS gen_subquery_1

http://git-wip-us.apache.org/repos/asf/spark/blob/457850e6/sql/hive/src/test/resources/sqlgen/rollup_cube_7_2.sql
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/sqlgen/rollup_cube_7_2.sql b/sql/hive/src/test/resources/sqlgen/rollup_cube_7_2.sql
deleted file mode 100644
index 9958c8f..0000000
--- a/sql/hive/src/test/resources/sqlgen/rollup_cube_7_2.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- This file is automatically generated by LogicalPlanToSQLSuite.
-SELECT a, b, grouping(b) FROM parquet_t2 GROUP BY cube(a, b)
---------------------------------------------------------------------------------
-SELECT `gen_attr_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_3` AS `grouping(b)` FROM (SELECT `gen_attr_4` AS `gen_attr_0`, `gen_attr_5` AS `gen_attr_1`, grouping(`gen_attr_5`) AS `gen_attr_3` FROM (SELECT `a` AS `gen_attr_4`, `b` AS `gen_attr_5`, `c` AS `gen_attr_6`, `d` AS `gen_attr_7` FROM `default`.`parquet_t2`) AS gen_subquery_0 GROUP BY `gen_attr_4`, `gen_attr_5` GROUPING SETS((`gen_attr_4`, `gen_attr_5`), (`gen_attr_4`), (`gen_attr_5`), ())) AS gen_subquery_1


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org


Mime
View raw message