Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.14.0
Description
Let's have a Postgresql database with a table with one column of jsonb values. I wish to be able to treat this column as a collection of JSON documents and be able to work with it in Drill the same way I can if they were stored in MongoDB.
That is, I want to query the JSON documents from Drill and have Drill produce Postgresql queries that take advantage of Postgres' json querying operators and indexes I made in Postgresql inside this column. (see https://www.postgresql.org/docs/9.5/static/datatype-json.html 8.14.4. jsonb Indexing).
What I do not want is to pull all the json from Postgresql in the string representation and then have to reimport it into say MongoDB.
Related discussions on the Web, i.e. other people who I think are requesting this, ordered by relevance:
Attachments
Issue Links
- is duplicated by
-
DRILL-6315 Postgres supports jsonb datatype but drill doesn't
- Resolved