search

stripe-archive / mosql

MongoDB → PostgreSQL streaming replication
MIT License
1.63k stars 225 forks source link

mongo array support #100

Open jney opened 9 years ago

jney commented 9 years ago

Maybe i missed this from documentation, Is it possible to extract data from an array ?

ie :

mongodb:
  collection:
    :columns:
    - latitude:
      :source:  location[0]
      :type: FLOAT
    - longitude:
      :source:  location[1]
      :type: FLOAT
allpratik commented 8 years ago

Same Issue. Will the above stuff work?

beltiras commented 8 years ago

Did you test this?

jney commented 8 years ago

@arnists excuse me for the delay. i tested it and i have got a [null] instead of the content

JosephZeng1121 commented 8 years ago

hi, any thoughts on this issue. Our mongo structure is full of array. It's really hard to parse jason array in tableau

allpratik commented 8 years ago

@JosephZeng1121 AFA in my case, we ditched Tableau and used Pentaho through KTR files. Pentaho is not that visually appealing as of Tableau, but it is versatile enough and helped us to get our work done.

bitliner commented 7 years ago

@JosephZeng1121 a way could be to update the code and add the support for arrays.

I had a look at it, and I think what should be changed is after this line and at schema.transform(...) method.

Can this help?