You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by priyanka B <pr...@gmail.com> on 2018/12/20 07:48:06 UTC

UUID field in postgres returns null while reading using storage plugin

Hello,

We see that UUID field in Postgres returns null when queried from Drill.
This happens as JdbcRecordReader#JDBC_TYPE_MAPPINGS does not map
java.sql.Types.OTHER to any MinorType. Postgres UUID type is mapped to
java.sql.Types.OTHER.

A fix would be to read the value as an object and then convert it to a
string.

If we read the values as string what happens to the other types mapped to
Type.OTHER?

Thank you,
Priyanka Bhoir