drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reid Thompson <Reid.Thomp...@omnicell.com>
Subject How can I resolve error on jdbc postgresql column type jsonb
Date Tue, 14 Aug 2018 13:17:14 GMT
i have tables with columns defined as type jsonb.  Attempting to query
these tables and write the results out to parquet files results in the
following error on those columns

org.apache.drill.common.exceptions.UserException: UNSUPPORTED_OPERATION
ERROR: A column you queried has a data type that is not currently
supported by the JDBC storage plugin. The column's name was actionjson
and its JDBC data type was OTHER.

is there a way to have these columns supported?


View raw message