viirya commented on code in PR #1:
URL: 
https://github.com/apache/datafusion-benchmarks/pull/1#discussion_r1605813002


##########
tpch/queries/q15.sql:
##########
@@ -0,0 +1,33 @@
+-- SQLBench-H query 15 derived from TPC-H query 15 under the terms of the TPC 
Fair Use Policy.
+-- TPC-H queries are Copyright 1993-2022 Transaction Processing Performance 
Council.
+create view revenue0 (supplier_no, total_revenue) as

Review Comment:
   I got:
   
   ```
   pyspark.errors.exceptions.captured.AnalysisException: Not allowed to create 
a permanent view `spark_catalog`.`default`.`revenue0` by referencing a 
temporary view lineitem. Please create a temp view instead by CREATE TEMP VIEW.
   ```
   
   I need to manually change to 
   ```suggestion
   create temp view revenue0 (supplier_no, total_revenue) as
   ```
   
   to make it work.



-- 
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: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to