drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reid Thompson <Reid.Thomp...@omnicell.com>
Subject Re: How can I resolve error on jdbc postgresql column type jsonb
Date Tue, 14 Aug 2018 13:23:00 GMT
On Tue, 2018-08-14 at 09:17 -0400, Reid Thompson wrote:
> 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?
> Thanks,
> reid

sorry, the above references a column of type json, not jsonb.  But I
have both types in my DB.


View raw message