[
https://issues.apache.org/jira/browse/SPARK-27837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16848200#comment-16848200
]
Jason Ferrell commented on SPARK-27837:
---------------------------------------
Is there any way to get this into an enhancement request? It doesn't seem
quite functional as part of the SQL code that I would pass a literal to every
single row of an operation. The behavior I think would be most advantageous
would be to pass an int corresponding to a column within the row so that I can
get a random value for each row, seeded by a value on that row.
> Running rand() in SQL with seed of column results in error (rand(col1))
> -----------------------------------------------------------------------
>
> Key: SPARK-27837
> URL: https://issues.apache.org/jira/browse/SPARK-27837
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.4.0
> Reporter: Jason Ferrell
> Priority: Major
>
> Running this sql:
> with a as
> (
> select 123 val1
> union all
> select 123 val1
> union all
> select 123 val1
> )
> select val1,rand(123),rand(val1)
> from a
> Results in error: org.apache.spark.sql.AnalysisException: Input argument to
> rand must be an integer, long or null literal.;
> It doesn't appear to recognize the value of the column as an int.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
