{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/63cbf1cefc2a433d8dcec336fa542a68\" frameborder=\"0\" width=\"1728\" height=\"1296\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1296,"width":1728,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1296,"thumbnail_width":1728,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/63cbf1cefc2a433d8dcec336fa542a68-8ff9de9b674b185a.gif","duration":158.6541,"title":"Trino: Sync Fields Step fails to Complete ","description":"In this video, I discuss our setup with Trino, focusing on the Hive and Iceberg catalogs that share the same metastore. I explain how we can successfully query Hive tables from the Hive catalog, but querying Iceberg tables from there results in errors, and vice versa. This issue can cause the sync job to break during queries, which is something we need to be aware of. I demonstrate the configurations for both catalogs and emphasize the importance of keeping the schemas separate to avoid these errors. Please ensure that when setting up new connections to Trino, you adhere to these guidelines."}