[
https://issues.apache.org/jira/browse/DRILL-8105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17608683#comment-17608683
]
James Turton commented on DRILL-8105:
-------------------------------------
As a workaround please cast these UUID columns to VARCHAR so that they reach
Drill as a JDBC type that it supports.
{code:java}
select cast(that_uuid_column as varchar) from postgres.public.foobar;{code}
> UUID fields are returned as null when queried (PostgresSQL+Apache Drill)
> ------------------------------------------------------------------------
>
> Key: DRILL-8105
> URL: https://issues.apache.org/jira/browse/DRILL-8105
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.19.0
> Environment: Windows OS
>
> Reporter: Kirshina Margarita
> Priority: Major
> Attachments: image-2022-01-10-14-34-44-048.png,
> image-2022-01-10-14-37-27-919.png
>
>
> Apache Drill 1.19.0
> pgadmin4 v5.3
> UUID fields
> !image-2022-01-10-14-34-44-048.png|width=670,height=351!
> !image-2022-01-10-14-37-27-919.png|width=1271,height=617!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
