Comments (2)
Can you more concretely describe how the metastore would actually use the Presto catalog name? Is this for some sort of fork of the Hive metastore?
from presto.
Lakehouses have 3 part names for table objects.
<catalog-name>.<schema-name>.<table-name>
.
Extending this concept to other objects <catalog-name>.<schema-name>.<object-name>
.
Currently metastores like HMS are limited to store only a two part name <schema-name>.<table-name>
based on the assumption that it will store metadata about only one catalog. There are limitations to this design:
This limitation forces SQL engines like Presto & Spark to store the 3rd part of the name <catalog-name>
external to the metastore which is not ideal place for metadata.
This limitation of HMS also introduces another problem that each SQL engine that accesses an object like an iceberg table can name the catalog differently, which will makes it difficult to identify a table object uniquely across different engines.
This also makes HMS single tenant (one catalog per metastore).
Drawing an analogy to traditional databases world, a single instance can hold multiple databases with schemas and table objects dbname.schemaname.tablename
To solve the above limitation, to make Presto engines work with multi catalog metastores that support HMS-like protocol, there needs to be a way to pass the catalog to the external metastore which this PR addresses.
Even though it will transmit the catalog name to the traditional HMS metastore, the traditional HMS metastore will ignore it. The catalog name won't be retained in the metastore, ensuring there's no regression or alteration in behavior, thereby maintaining full backward compatibility.
from presto.
Related Issues (20)
- Tiny table joining two large tables should pre join both HOT 2
- [Native] Getting build issue after rebasing to latest Presto - 0.290-SNAPSHOT HOT 3
- Iceberg `timestamptz` should map to Presto `TIMESTAMP WITH TIME ZONE` type HOT 1
- Presto Router to support custom SPI plugin scheduler to route query HOT 1
- Columns should be left aligned HOT 2
- Document field_names_in_json_cast_enabled
- Hoist global windows without partition by into a join
- [Iceberg] While time travel Iceberg is not using schema respective to a given Snapshot HOT 5
- Distinct operation on UUID fails HOT 5
- Support enabling SSL for Prometheus connector
- SSL Support for Oracle Connector
- UNLOAD to write to a destination ( like S3 ) the result of a query HOT 4
- Round bytes to Gigabytes in error messages HOT 2
- [docs] Create session properties page as counterpart for (Configuration) Properties reference
- Support Google-style trailing comma in SELECT HOT 3
- Flakiness while trying to download Nodejs during Presto Build in CI HOT 1
- Teradata and Burmese functions are only plugins
- url_encode should encode spaces as %20 not + HOT 1
- Optimize coalesce of join keys
- Easier way to add support for more scalar functions during JDBC predicate pushdown
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from presto.