From: | postgresql(at)vorio(dot)com(dot)br |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | MongoDB FDW Problem. |
Date: | 2016-02-02 22:10:54 |
Message-ID: | e9c1125906e085bb2d689463c7318118@vorio.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My best for all in this list.
i'm trying to use FDW for MongoDB
using PostgreSQL 9.4 using pgdg yum
repo: yum install
postgresql94-server postgresql94-contrib mongo_fdw94
My S.O. is CentOS
9.7 64bits
All is ok with Postgres. I can create extension, foreign
server and
foreign table.
My problem is when the "columns" of the
MongoDB collection are a
document or array. In my Foreign Table, I have
only null values
returned in selects.
All of others columns returns its
values with no problem.
Can any help or advise me about this?
Thanks a
lot!
Lucio - Rio de Janeiro - Brazil
Please see below some info:
On
mongo i have this on collection:
{
"_id" :
ObjectId("56ae3a5c2e277c04c77beec7"),
"address" : {
"building" :
"469",
"coord" : [-73.961704, 40.662942],
"street" : "Flatbush
Avenue",
"zipcode" : "11225"
},
"borough" : "Brooklyn",
"cuisine" :
"Hamburgers",
"grades" : [{
"date" : ISODate("2014-12-30T00:00:00Z"),
"grade" : "A",
"score" : 8
}, {
"date" :
ISODate("2014-07-01T00:00:00Z"),
"grade" : "B",
"score" : 23
}, {
"date" : ISODate("2013-04-30T00:00:00Z"),
"grade" : "A",
"score" : 12
}, {
"date" : ISODate("2012-05-08T00:00:00Z"),
"grade" : "A",
"score"
: 12
}],
"name" : "Wendy'S",
"restaurant_id" : "30112340"
}
On
PostgreSQL I have this:
"_id" "address" "borough" "cuisine" "grades"
"name"
"restaurant_id"
"56ae3a5c2e277c04c77beec7" <null> "Brooklyn"
"Hamburgers" <null>
"Wendy'S" "30112340"
CREATE FOREIGN TABLE
mongo_fdw.restaurants (
_id NAME NOT NULL,
address JSON,
borough
VARCHAR,
cuisine VARCHAR,
grades VARCHAR, --> errors happens if I put
json here
name VARCHAR,
restaurant_id VARCHAR
)
SERVER
mongo_server
OPTIONS (
database 'test',
collection 'restaurants');
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-02-02 22:19:22 | Re: Attachments |
Previous Message | Vick Khera | 2016-02-02 21:39:37 | Re: Attachments |