[ https://issues.apache.org/jira/browse/SPARK-7149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14525057#comment-14525057 ]
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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org