Geoserver not recognizing jsonb attribute in SQL view of PostGIS db

Question

I have an instance of Geoserver 2.8.2 running and a PostGIS database. I am attempting to create a FeatureType based on an SQL view of the following table (viewed through psql \d):

                 Table "public.rapid_feature"
       Column       |          Type           | Modifiers
--------------------+-------------------------+-----------
 uid                | text                    | not null
 geom               | geometry(Geometry,4326) |
 bbox               | geometry(Polygon,4326)  |
 properties         | jsonb                   | not null
 create_timestamp   | time without time zone  |
 hash               | text                    |
 modified_timestamp | time without time zone  |
 layer_id           | text                    |

However, when I create an FeatureType based on an SQL View of this table, the properties attribute disappears:

Not sure what I need to do to make the properties column appear as an attribute in Geoserver.

Answer 1

As @user30184 says to get a JSONB column to appear in GeoServer would involve adding the ability to read and understand them to the GeoTools postgis datastore. The code for which is on github.

As a quicker fix you could break that column out into it's component parts and store them as normal columns that GeoServer can recognise and that you could use CQL filters against.