Jiri Danek created DRILL-5087:
---------------------------------
Summary: Support querying jsonb documents in Postgresql table
column
Key: DRILL-5087
URL: https://issues.apache.org/jira/browse/DRILL-5087
Project: Apache Drill
Issue Type: Improvement
Components: Storage - JDBC
Reporter: Jiri Danek
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:
* [Apache Drill, Query PostgreSQL text or Jsonb as if it were from a json
storage
type?|http://drill-user.incubator.apache.narkive.com/O5KNkFew/apache-drill-query-postgresql-text-or-jsonb-as-if-it-were-from-a-json-storage-type]
* [Apache Drill Query PostgreSQL Json -
StackOverflow|http://stackoverflow.com/questions/37443114/apache-drill-query-postgresql-json]
* [Ask Us Anything About Apache Drill 7/27 - 8/3 - MapR Converge
Community|https://community.mapr.com/thread/18549]
** https://community.mapr.com/thread/18549#comment-51122
* [Database options for JSON storage, queried with Apache Drill - Data Science
Stack
Exchange|http://datascience.stackexchange.com/questions/9568/database-options-for-json-storage-queried-with-apache-drill]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
