Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-29451

Some queries with divisions in SQL windows are failling in Thrift

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • 3.0.0
    • None
    • SQL
    • None

    Description

      Hello,
      the following queries are not properly working on Thrift. The only difference between them and some other queries that works fine are the numeric divisions, I think.

      SELECT four, ten/4 as two,
      sum(ten/4) over (partition by four order by ten/4 rows between unbounded preceding and current row),
      last(ten/4) over (partition by four order by ten/4 rows between unbounded preceding and current row)
      FROM (select distinct ten, four from tenk1) ss;
      
      SELECT four, ten/4 as two,
      sum(ten/4) over (partition by four order by ten/4 range between unbounded preceding and current row),
      last(ten/4) over (partition by four order by ten/4 range between unbounded preceding and current row)
      FROM (select distinct ten, four from tenk1) ss;
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            DylanGuedes Dylan Guedes
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: