Re-recognition of delta lake tables #144
goosedb-net
started this conversation in
General
Replies: 1 comment 1 reply
-
|
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
CREATE TABLE delta.default.my_table (
id INT,
name VARCHAR,
age INT
)
WITH (
location = 's3://my-bucket/delta/my_table'
);
trino was used to create the deltalake table.
After that, one million rows were inserted.
I want to recognize this table directly in pg_mooncake and extract the data with select sql.
How can I manipulate and insert metadata into mooncake.data_files(mooncakce.tables)?
I don't want to insert a million records again in pg_mooncake.
(The authentication process for pg_mooncake's S3 communication does not need to be considered at this time.)
Beta Was this translation helpful? Give feedback.
All reactions