DSS auto save Json String To Array

Options
tmgiang
tmgiang Registered Posts: 15 ✭✭✭✭
I use Python to read data from Mongodb. But when I save to DSS, the json data automatically store as "array" like that:

[{u'keyed_data': [{u'indexed_EDLetterCode_orig': ...

(actually, the json data is array)

Before use DSS, I code the recipe on Jupyter Notebook and it works well (I use json_normalize to read json data to panda frame). But after DSS automatically store the json in "array" type, I can't use json normalize

I found that the preparation recipe can fold / unfold the json data to rows, but unsuccesfully.

How can I read the json data to rows? Can I force DSS does not store json data like "array" ?

Answers

Setup Info
    Tags
      Help me…