You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Serge Rielau (Jira)" <ji...@apache.org> on 2022/08/24 16:17:00 UTC
[jira] [Commented] (SPARK-40208) New OFFSET clause does not use new error framework
[ https://issues.apache.org/jira/browse/SPARK-40208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17584351#comment-17584351 ]
Serge Rielau commented on SPARK-40208:
--------------------------------------
[~maxgekk] (FYI)
Also (I'm sure LIMIT is the same, maybe fix in one fell swoop?)
spark-sql> SELECT name, age FROM person ORDER BY name OFFSET -1;
Error in query: The offset expression must be equal to or greater than 0, but got -1;
Offset -1
+- Sort [name#185 ASC NULLS FIRST], true
+- Project [name#185, age#186]
+- SubqueryAlias person
+- View (`person`, [name#185,age#186])
+- Project [cast(col1#187 as string) AS name#185, cast(col2#188 as int) AS age#186]
+- LocalRelation [col1#187, col2#188]
> New OFFSET clause does not use new error framework
> ---------------------------------------------------
>
> Key: SPARK-40208
> URL: https://issues.apache.org/jira/browse/SPARK-40208
> Project: Spark
> Issue Type: Bug
> Components: Spark Core
> Affects Versions: 3.4.0
> Reporter: Serge Rielau
> Priority: Minor
>
> CREATE TEMP VIEW person (name, age)
> AS VALUES ('Zen Hui', 25),
> ('Anil B' , 18),
> ('Shone S', 16),
> ('Mike A' , 25),
> ('John A' , 18),
> ('Jack N' , 16);
> SELECT name, age FROM person ORDER BY name OFFSET length(name);
> Error in query: The offset expression must evaluate to a constant value, but got length(person.name);
> Offset length(name#181)
> +- Sort [name#181 ASC NULLS FIRST], true
> +- Project [name#181, age#182]
> +- SubqueryAlias person
> +- View (`person`, [name#181,age#182])
> +- Project [cast(col1#183 as string) AS name#181, cast(col2#184 as int) AS age#182]
> +- LocalRelation [col1#183, col2#184|#183, col2#184]
>
> Returning the plan here is quite pointless as well. The context would be more interesting.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org