Serge Rielau created SPARK-40208:
------------------------------------
Summary: 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
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
