Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for struct type #93

Open
Magmatrix opened this issue Feb 24, 2025 · 1 comment
Open

Support for struct type #93

Magmatrix opened this issue Feb 24, 2025 · 1 comment

Comments

@Magmatrix
Copy link

Hi,

Any plans to add support for Arrow struct?

Right now I can't find any way to access the struct fields. Not even as a binary blob.
If I could just cast it to JSON/JSONB or HSTORE or even BYTEA, then it would be possible at least access it in some way - even if only (in worst case) available as a hex string.

@Magmatrix
Copy link
Author

Hi,

I was recently told that the structs are flattened into separate fields in the Parquet files. So I tried to import a field in a struct like this:
"structName.fieldName"

Well, that import works just fine... But selecting from that field just returns null :(

parquet=# SELECT "structName.fieldName" FROM "Table" WHERE "structName.fieldName" IS NOT NULL LIMIT 1;
 structName.fieldName
---------------------
(0 rows)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant