drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jiri Danek (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5087) Support querying jsonb documents in Postgresql table column
Date Thu, 01 Dec 2016 16:02:58 GMT
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)

Mime
View raw message