[
https://issues.apache.org/jira/browse/SPARK-17429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15471443#comment-15471443
]
Dongjoon Hyun commented on SPARK-17429:
---------------------------------------
Ya. I agree with [~hvanhovell]. It seems to be debatable. PostgreSQL gives
error like Spark while MySQL work like Hive.
{code}
ERROR: function length(integer) does not exist
LINE 1: select length(1)
{code}
[~cenyuhai], could you make a PR for this. At least, I think this should be
discussed and make a conclusion in any way.
> spark sql length(1) return error
> --------------------------------
>
> Key: SPARK-17429
> URL: https://issues.apache.org/jira/browse/SPARK-17429
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.6.2
> Reporter: cen yuhai
>
> select length(11);
> select length(2.0);
> these sql will return errors, but hive is ok.
> Error in query: cannot resolve 'length(11)' due to data type mismatch:
> argument 1 requires (string or binary) type, however, '11' is of int type.;
> line 1 pos 14
> Error in query: cannot resolve 'length(2.0)' due to data type mismatch:
> argument 1 requires (string or binary) type, however, '2.0' is of double
> type.; line 1 pos 14
--
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
