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