You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2018/08/15 16:20:00 UTC
[jira] [Updated] (DRILL-5087) Support querying jsonb documents in
Postgresql table column
[ https://issues.apache.org/jira/browse/DRILL-5087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vitalii Diravka updated DRILL-5087:
-----------------------------------
Labels: 1.13 (was: )
> 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 Daněk
> Priority: Major
> Labels: 1.13
>
> 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)