[
https://issues.apache.org/jira/browse/DRILL-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitalii Diravka updated DRILL-5087:
-----------------------------------
Affects Version/s: 1.14.0
> 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
> Affects Versions: 1.14.0
> Reporter: Jiri Daněk
> Priority: Major
> Labels: doc-impacting
> Fix For: Future
>
>
> 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
(v7.6.3#76005)
