Dongjoon Hyun created SPARK-16621:
-------------------------------------
Summary: Use a stable ID generation method for attributes in
SQLBuilder
Key: SPARK-16621
URL: https://issues.apache.org/jira/browse/SPARK-16621
Project: Spark
Issue Type: Improvement
Components: SQL
Reporter: Dongjoon Hyun
Currently, the generated SQL has stable IDs for `subquery`, but not-stable IDs
for `gen_attr`. This issue provides stable IDs for `gen_attr`, too.
The stable generated SQL will give more benefit for understanding or testing
the queries.
**Before**
{code}
scala> new org.apache.spark.sql.catalyst.SQLBuilder(sql("select 1")).toSQL
res0: String = SELECT `gen_attr_0` AS `1` FROM (SELECT 1 AS `gen_attr_0`) AS
gen_subquery_0
scala> new org.apache.spark.sql.catalyst.SQLBuilder(sql("select 1")).toSQL
res1: String = SELECT `gen_attr_4` AS `1` FROM (SELECT 1 AS `gen_attr_4`) AS
gen_subquery_0
{code}
**After**
{code}
scala> new org.apache.spark.sql.catalyst.SQLBuilder(sql("select 1")).toSQL
res1: String = SELECT `gen_attr_0` AS `1` FROM (SELECT 1 AS `gen_attr_0`) AS
gen_subquery_0
scala> new org.apache.spark.sql.catalyst.SQLBuilder(sql("select 1")).toSQL
res2: String = SELECT `gen_attr_0` AS `1` FROM (SELECT 1 AS `gen_attr_0`) AS
gen_subquery_0
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
