[
https://issues.apache.org/jira/browse/SPARK-7149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14525096#comment-14525096
]
haiyang commented on SPARK-7149:
--------------------------------
If we give no alias to a function in project,the SqlParser will give it a
default alias like c0,c1,...
When we execute the statement like "select substr(value, 0, 2), key as c0 from
testData order by c0" will throw exception.
> Defalt system alias problem
> ---------------------------
>
> Key: SPARK-7149
> URL: https://issues.apache.org/jira/browse/SPARK-7149
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: haiyang
>
> Fix default system alias problem.
> execute the sql statement will cause problem:
> select substr(value, 0, 2), key as c0 from testData order by c0
> org.apache.spark.sql.AnalysisException: Reference 'c0' is ambiguous, could
> be: c0#42, c0#41.;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
