ostinru opened a new issue, #65:
URL: https://github.com/apache/cloudberry-pxf/issues/65
Both Parquet and Cloudberry supports UUID data types. PXF doesn't:
```
db1=# CREATE FOREIGN TABLE uuid_test_fdw (id UUID, value varchar(255))
SERVER s3store
OPTIONS (resource 'ostinru-pxf-test/uuid_test_fdw', format 'parquet');
CREATE FOREIGN TABLE
db1=# insert into uuid_test_fdw VALUES (gen_random_uuid(), 'test');
ERROR: PXF server error : Type 2950 for column id is not supported for
writing Parquet. (seg1 10.11.0.131:6000 pid=368065)
HINT: Check the PXF logs located in the '/etc/cloudberry-pxf/logs'
directory on host 'localhost' or 'set client_min_messages=LOG' for additional
details.
```
In logs it looks like:
```
2026-02-17 05:01:21.877 UTC ERROR [4412549-0000000005:s3store:1 ] 2619994
--- [888-exec-5] o.a.c.p.s.c.PxfErrorReporter : Type 2950 for
column id is not supported for writing Parquet.
org.apache.cloudberry.pxf.api.error.UnsupportedTypeException: Type 2950 for
column id is not supported for writing Parquet.
at
org.apache.cloudberry.pxf.plugins.hdfs.ParquetFileAccessor.getTypeForColumnDescriptor(ParquetFileAccessor.java:593)
~[pxf-hdfs-1.0.0.jar!/:?]
at
org.apache.cloudberry.pxf.plugins.hdfs.ParquetFileAccessor.lambda$generateParquetSchema$2(ParquetFileAccessor.java:499)
~[pxf-hdfs-1.0.0.jar!/:?]
at
java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195) ~[?:?]
at
java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
~[?:?]
at
java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[?:?]
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
