Data Product Query created on Hive Catalog often faces time out issue

Starburst Galaxy
1

Data Product Query created on Hive Catalog often faces time out issue

2

Hi
Am trying to build a Data Product and create a Materialized view to Refresh the data at regular intervals. But it turns out that the query which is executed on Object Storage results in Time out issue. Does that mean that query is inefficient? Note the query works well on normal editor but fails to return when being queries from Object Storage. What could be reason ?

3

Is the “time out” related to the query itself returning a result or the auto-refresh of the MV rebuild?

Sounds like the next step would be to see the EXPLAIN ANALYZE output (from the Starburst UI query history) from both when you run the underlying query as well as the output from when the Data Products does the auto-refresh of your MV. If you can’t find the latter, just running the refresh manually and seeing that output to compare with.