Trino hive connector unable to access hive MV

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

https://trino.io

Apache License 2.0

10.51k stars 3.03k forks source link

Trino hive connector unable to access hive MV #23018

Open gunjansingh97 opened 3 months ago

gunjansingh97 commented 3 months ago

Currently, MV created from hive is not getting recognized when query is run from trino client[hive connector]. Only the ones created by trino is recognized. What is the reason behind using physical and logical object both, not just keep a physical object in HMS. Is there a plan to support interoperability of MV between hive and trino. @mosabua @martint

electrum commented 3 months ago

I’m not aware of anyone working on it, but contributions are welcome. A good first step would be to describe how this works, from a technical perspective.