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
