# Array field, multivalue field, nested object‏

**URL:** <https://discuss.elastic.co/t/array-field-multivalue-field-nested-object/28065>\
**Category:** Logstash\
**Created:** [August 26, 2015, 6:20am UTC](https://discuss.elastic.co/t/array-field-multivalue-field-nested-object/28065 "2015-08-26T06:20:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shady](https://avatars.discourse-cdn.com/v4/letter/s/6de8d8/32.png) [@shady](https://discuss.elastic.co/u/shady)\
**Post date:** [August 26, 2015, 6:20am UTC](https://discuss.elastic.co/t/array-field-multivalue-field-nested-object/28065/1 "2015-08-26T06:20:21Z")

</div>

I need to get one to many relation from oracle database and create an elasticsaerch index with documents with multi value field (array).

I have two oracle tables:  
CarMark (cmk\_id integer, cmk\_name varchar2(100) );  
(1 , "BMW")  
CarModeL (cml\_id integer, cmk\_id integer, cml\_name varchar2(100));  
(1 , 1 , "X5")  
(2 , 1 , "M3")

My statment is:  
select cmk\_id, cmk\_name, cml\_name  
from CarMark left join  
CarModel on CarModel.cmk\_id = CarMark.cmk\_id;

I should get an ES index with the below document:  
"cmk\_id" : "1",  
"cmk\_Name" : "BMW"  
"cml\_name" : ["X5" , "M6"].

I tried to use the below logstash configuration, but is doesn't work

input {  
jdbc {  
jdbc\_driver\_library =\> "C:jdbc\ojdbc6.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@localhost:1521:orcl"  
jdbc\_user =\> "testuser"  
jdbc\_password =\> "pass"  
statement =\> "select cmk\_id, cmk\_name, cml\_name  
from CarMark left join  
CarModel on CarModel.cmk\_id = CarMark.cmk\_id;"

}  
}

output {  
elasticsearch { host =\> localhost  
index =\> cars  
document\_type =\> item  
document\_id =\> [%{cmk\_id}]

}  
stdout { codec =\> rubydebug }  
}

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 5:30am UTC](https://discuss.elastic.co/t/array-field-multivalue-field-nested-object/28065/2 "2017-07-06T05:30:52Z")

</div>

Closed on July 6, 2017, 5:30am UTC