# JDBC River for parent-child document

**URL:** <https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561>\
**Category:** Elasticsearch\
**Created:** [July 30, 2012, 11:12am UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561 "2012-07-30T11:12:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arthur\_Pan](https://avatars.discourse-cdn.com/v4/letter/a/e95f7d/32.png) [@Arthur\_Pan](https://discuss.elastic.co/u/Arthur_Pan)\
**Post date:** [July 30, 2012, 11:12am UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561/1 "2012-07-30T11:12:21Z")

</div>

Hi! All,

I am a newbie for Elasticsearch.

can "JDBC River" support Parent-Child Documents?

I has two types in the index, they are "topic"(parent) and "comment"(child)  
, also have two table of the same name in the MySQL.  
How can I via "JDBC River" to select data into Elasticksearch?

Thanks for your help.  
Arthur

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [July 30, 2012, 6:06pm UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561/2 "2012-07-30T18:06:36Z")

</div>

Hi Arthur,

there is no support in the JDBC river for parent/child document indexing.  
But you can create an issue it you want to add such a  
feature: [Issues · jprante/elasticsearch-jdbc · GitHub](https://github.com/jprante/elasticsearch-river-jdbc/issues)

Best regards,

Jörg

On Monday, July 30, 2012 1:12:21 PM UTC+2, Arthur pan wrote:

> Hi! All,
> 
> I am a newbie for Elasticsearch.
> 
> can "JDBC River" support Parent-Child Documents?
> 
> I has two types in the index, they are "topic"(parent) and  
> "comment"(child) , also have two table of the same name in the MySQL.  
> How can I via "JDBC River" to select data into Elasticksearch?
> 
> Thanks for your help.  
> Arthur

---

<div class="post-metadata">

**Author:** ![Arthur\_Pan](https://avatars.discourse-cdn.com/v4/letter/a/e95f7d/32.png) [@Arthur\_Pan](https://discuss.elastic.co/u/Arthur_Pan)\
**Post date:** [July 31, 2012, 7:01am UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561/3 "2012-07-31T07:01:56Z")

</div>

Dear Jörg,

I will create an issue. thanks for your answer.

Arthur

Jörg Prante於 2012年7月31日星期二UTC+8上午2時06分36秒寫道：

> Hi Arthur,
> 
> there is no support in the JDBC river for parent/child document indexing.  
> But you can create an issue it you want to add such a feature:  
> [Issues · jprante/elasticsearch-jdbc · GitHub](https://github.com/jprante/elasticsearch-river-jdbc/issues)
> 
> Best regards,
> 
> Jörg
> 
> On Monday, July 30, 2012 1:12:21 PM UTC+2, Arthur pan wrote:
> 
> > Hi! All,
> > 
> > I am a newbie for Elasticsearch.
> > 
> > can "JDBC River" support Parent-Child Documents?
> > 
> > I has two types in the index, they are "topic"(parent) and  
> > "comment"(child) , also have two table of the same name in the MySQL.  
> > How can I via "JDBC River" to select data into Elasticksearch?
> > 
> > Thanks for your help.  
> > Arthur

---

<div class="post-metadata">

**Author:** ![Joshua\_Chaitin\_Polla](https://avatars.discourse-cdn.com/v4/letter/j/71e660/32.png) [@Joshua\_Chaitin\_Polla](https://discuss.elastic.co/u/Joshua_Chaitin_Polla)\
**Post date:** [October 9, 2012, 6:52pm UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561/4 "2012-10-09T18:52:48Z")

</div>

Hi, this feature would be really useful for me too. Is there any work  
around for the river not having this feature?

For example, is there way to apply a parent/child relationship manually as  
a post-process step?

Thanks,

-Josh

On Tuesday, July 31, 2012 3:01:56 AM UTC-4, Arthur pan wrote:

> Dear Jörg,
> 
> I will create an issue. thanks for your answer.
> 
> Arthur
> 
> Jörg Prante於 2012年7月31日星期二UTC+8上午2時06分36秒寫道：
> 
> > Hi Arthur,
> > 
> > there is no support in the JDBC river for parent/child document indexing.  
> > But you can create an issue it you want to add such a feature:  
> > [Issues · jprante/elasticsearch-jdbc · GitHub](https://github.com/jprante/elasticsearch-river-jdbc/issues)
> > 
> > Best regards,
> > 
> > Jörg
> > 
> > On Monday, July 30, 2012 1:12:21 PM UTC+2, Arthur pan wrote:
> > 
> > > Hi! All,
> > > 
> > > I am a newbie for Elasticsearch.
> > > 
> > > can "JDBC River" support Parent-Child Documents?
> > > 
> > > I has two types in the index, they are "topic"(parent) and  
> > > "comment"(child) , also have two table of the same name in the MySQL.  
> > > How can I via "JDBC River" to select data into Elasticksearch?
> > > 
> > > Thanks for your help.  
> > > Arthur

--

---

<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, 3:09am UTC](https://discuss.elastic.co/t/jdbc-river-for-parent-child-document/8561/5 "2017-07-06T03:09:30Z")

</div>