search

adjust / parquet_fdw

Parquet foreign data wrapper for PostgreSQL
PostgreSQL License
333 stars 37 forks source link

Using array type #49

Open artemyarulin opened 1 year ago

artemyarulin commented 1 year ago

What is the right way to specify an array type? Tried to use the following and used text[] like in here:

select import_parquet_explicit(
               'test',
               'public',
               'parquet_srv',
               array['created', 'tags'],
               array['timestamp', 'text[]']::regtype[],
               'list_parquet_files',
               '{"dir": "/tmp/products"}',
               '{"sorted": "created"}'
           );

but it fails when I run the SELECT from the table with error: ERROR: parquet_fdw: cache lookup failed for type 0 . If I use text instead then values got imported fine as one text value, so data I guess is correct. Didn't find any example with array type in here