[
https://issues.apache.org/jira/browse/SPARK-14066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15208185#comment-15208185
]
Sean Owen commented on SPARK-14066:
-----------------------------------
I can't help with this one, but you just need to write them all as decimals
right? I'm not sure whether to expect auto promotion of the types, therefore
whether this is even a bug
> Set "spark.sql.dialect=sql", there is a problen in running query "select
> percentile(d,array(0,0.2,0.3,1)) as a from t;"
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-14066
> URL: https://issues.apache.org/jira/browse/SPARK-14066
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.5.1
> Reporter: KaiXinXIaoLei
>
> In spark 1.5.1, I run "sh bin/spark-sql --conf spark.sql.dialect=sql", and
> run query "select percentile(d,array(0,0.2,0.3,1)) as a from t". There is a
> problem as follows.
> {code}
> spark-sql> select percentile(d,array(0,0.2,0.3,1)) as a from t;
> 16/03/22 17:25:15 INFO HiveMetaStore: 0: get_table : db=default tbl=t
> 16/03/22 17:25:15 INFO audit: ugi=root ip=unknown-ip-addr cmd=get_table
> : db=default tbl=t
> 16/03/22 17:25:16 ERROR SparkSQLDriver: Failed in [select
> percentile(d,array(0,0.2,0.3,1)) as a from t]
> org.apache.spark.sql.AnalysisException: cannot resolve 'array(0,0.2,0.3,1)'
> due to data type mismatch: input to function array should all be the same
> type, but it's [int, decimal(1,1), decimal(1,1), int];
> {code}
--
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
