[
https://issues.apache.org/jira/browse/SPARK-7149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14525059#comment-14525059
]
haiyang commented on SPARK-7149:
--------------------------------
This is SqlParser problem,when we give no alias to a function in project, the
parser will give it a default alias like c0,c1....so, when we execute the sql
statement like "select isnull(key), key as c0 from testData order by c0", it
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: [email protected]
For additional commands, e-mail: [email protected]
