Skip to Content
Former Member
Jan 24, 2017 at 03:53 PM

Smart Data Streaming - File/Hadoop Json - Array Issue


My question regards the File/Hadoop JSON Input adapter and in particular the possibility to import information stored in arrays into hana. I have built a very simple smart data streaming project where I have an input adapter (i.e. File/Hadoop JSON Input) followed by an input stream. As a JSON I am using the JSON file given in the SAP HANA Smart Data Streaming: Adapaters Guide on page 168. Here is what it looks like


"firstName": "John",

"lastName": "Smith",

"phoneNumbers": [


"type": "home",

"number": "212 555-1234"



"type": "fax",

"number": "646 555-4567"



"friends": [





What I am trying to achieve is to get all the information stored in one of the friend’s arrays. Following the instruction given in the adapters guide I set friends[1] for the jsonRootPath and * for jsonColsMappingList in the properties of the File/Hadoop JSON Input adapter. Yet, I am not able to receive any data in my input stream. Did I get or set something wrong? Appreciate any kind of hint or solution.