ang6300 commented on issue #32: URL: https://github.com/apache/polaris/issues/32#issuecomment-2547399651
@lefebsy, The run_spark_sql_s3compatible.sh execute this 'queries-for-spark.sql'. However, the query has problem with this statement: CREATE OR REPLACE VIEW db1.ns2.view1 ( line_count COMMENT 'Count of lines') AS SELECT COUNT(1) as qty FROM db1.ns1.table1; Error: Polaris catalog does not support views. I removed below lines from queries-for-spark.sql so that it can proceed to create db2 in warehouse2 bucket. CREATE OR REPLACE VIEW db1.ns2.view1 ( line_count COMMENT 'Count of lines') AS SELECT COUNT(1) as qty FROM db1.ns1.table1; SELECT * FROM db1.ns2.view1; INSERT INTO db1.ns1.table1 VALUES (13, 23); SELECT * FROM db1.ns2.view1; -- 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]
