mosql icon indicating copy to clipboard operation
mosql copied to clipboard

mongo array support

Open jney opened this issue 9 years ago • 6 comments

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

jney avatar Jul 01 '15 21:07 jney

Same Issue. Will the above stuff work?

allpratik avatar Sep 03 '15 16:09 allpratik

Did you test this?

beltiras avatar Sep 08 '15 08:09 beltiras

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

jney avatar Jan 15 '16 15:01 jney

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

JosephZeng1121 avatar Mar 15 '16 20:03 JosephZeng1121

@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.

allpratik avatar Mar 16 '16 04:03 allpratik

@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?

bitliner avatar Oct 13 '16 22:10 bitliner