[jira] [Commented] (SPARK-17854) it will failed when do select rand(null)
[ https://issues.apache.org/jira/browse/SPARK-17854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15565015#comment-15565015 ] Apache Spark commented on SPARK-17854: -- User 'HyukjinKwon' has created a pull request for this issue: https://github.com/apache/spark/pull/15432 > it will failed when do select rand(null) > > > Key: SPARK-17854 > URL: https://issues.apache.org/jira/browse/SPARK-17854 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.0.0, 2.0.1 > Environment: spark version:2.0.0 > Linuxversion: Suse 11.3 >Reporter: chenerlu >Priority: Minor > > In spark2.0, when run spark-sql and try to do select rand(null), it failed > and the error message as follows: > > select rand(null); > INFO SparkSqlParser: Parsing command: select rand(null) > Error in query: Input argument to rand must be an integer literal.;; line 1 > pos 7 > In hive or mysql, I do the same operation(select rand(null)), it will success > and the value of rand(null) is the same with rand(0). > this issue has fixed in Hive, the jira link as follows: > https://issues.apache.org/jira/browse/HIVE-14694 -- 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
[jira] [Commented] (SPARK-17854) it will failed when do select rand(null)
[ https://issues.apache.org/jira/browse/SPARK-17854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15564884#comment-15564884 ] Hyukjin Kwon commented on SPARK-17854: -- It seems this can be quickly fixed. Please let me submit a PR. > it will failed when do select rand(null) > > > Key: SPARK-17854 > URL: https://issues.apache.org/jira/browse/SPARK-17854 > Project: Spark > Issue Type: Improvement > Components: SQL >Affects Versions: 2.0.0, 2.0.1 > Environment: spark version:2.0.0 > Linuxversion: Suse 11.3 >Reporter: chenerlu >Priority: Minor > > In spark2.0, when run spark-sql and try to do select rand(null), it failed > and the error message as follows: > > select rand(null); > INFO SparkSqlParser: Parsing command: select rand(null) > Error in query: Input argument to rand must be an integer literal.;; line 1 > pos 7 > In hive or mysql, I do the same operation(select rand(null)), it will success > and the value of rand(null) is the same with rand(0). > this issue has fixed in Hive, the jira link as follows: > https://issues.apache.org/jira/browse/HIVE-14694 -- 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