guihuawen created SPARK-47767:
---------------------------------

             Summary: Show offset value in TakeOrderedAndProjectExec
                 Key: SPARK-47767
                 URL: https://issues.apache.org/jira/browse/SPARK-47767
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.5.0, 3.4.0, 4.0.0
            Reporter: guihuawen
             Fix For: 4.0.0


Show the offset value in TakeOrderedAndProjectExec.

 

For example:

 

explain select * from test_limit_offset order by a  limit 2  offset 1;

plan

== Physical Plan ==

TakeOrderedAndProject(limit=3, orderBy=[a#171 ASC NULLS FIRST], output=[a#171])

+- Scan hive spark_catalog.bigdata_qa.test_limit_offset [a#171], 
HiveTableRelation [`spark_catalog`.`bigdata_qa`.`test_limit_offset`, 
org.apache.hadoop.hive.ql.io.orc.OrcSerde, Data Cols: [a#171], Partition Cols: 
[]]

 

No offset is displayed. If it is displayed, it will be more user-friendly

 



--
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

Reply via email to