matthewgapp opened a new issue, #7639:
URL: https://github.com/apache/arrow-datafusion/issues/7639

   ### Describe the bug
   
   CREATE TABLE fails with NTILE window function select query
   
   ### To Reproduce
   
   in the sqllogictest directory, run this in the window.slt file 
   
   ```sql 
   # this test fails 
   # statement ok
   CREATE TABLE ntile_table as SELECT NTILE(8) OVER (ORDER BY c4) as ntile_1, 
NTILE(12) OVER (ORDER BY c12 DESC) AS ntile_2 FROM aggregate_test_100 LIMIT 10
   
   # this test passes 
   statement ok
   SELECT NTILE(8) OVER (ORDER BY c4) as ntile_1, NTILE(12) OVER (ORDER BY c12 
DESC) AS ntile_2 FROM aggregate_test_100 LIMIT 10
   ```
   
   ### Expected behavior
   
   The table is successfully created using the DDL. 
   
   ### Additional context
   
   I found this while writing tests for 
https://github.com/apache/arrow-datafusion/pull/7638


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to