search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
16.07k stars 5.38k forks source link

Views created through Spark Hive type catalog in an iceberg table is not accessible through Presto #24081

Open jeesou opened 2 days ago

jeesou commented 2 days ago

Your Environment

Expected Behavior

Once views are created, they are persistent in nature. Hence the view created through one engine must be useable through any other engine.

Current Behavior

Currently we were trying to create a view through Spark on an iceberg table, and were using hive as catalog type. the config being : "spark.sql.catalog.iceberg_test.type=hive" But the problem is the view created by spark is not accessible through presto. I gives the error - "Hive views are not supported"

tdcmeehan commented 2 days ago

Spark views cannot be executed by Presto because the SQL dialect is different.

jeesou commented 14 hours ago

Hi @tdcmeehan, yes that is understandable, but we need to come to a middle ground right, because if the issue remains, then the point of having persistent views becomes vague right.

tdcmeehan commented 10 hours ago

@jeesou what do you propose the middle ground be?