drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From priyanka B <priyankabhoir...@gmail.com>
Subject UUID field in postgres returns null while reading using storage plugin
Date Thu, 20 Dec 2018 07:48:06 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message