Get child doument by id

Yuriy_Bondaruk · May 16, 2012, 1:48pm

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
    _routing: {
        required: true
    }
    properties: {
        timestamp: {
            format: dateOptionalTime
            type: date
        }
        process-id: {
            index: not_analyzed
            type: string
        }
    }
    _parent: {
        type: MessageItem
    }
}
MessageItem: {
    properties: {
        timestamp: {
            format: dateOptionalTime
            type: date
        }
        status: {
            index: not_analyzed
            type: string
        }
    }
}

kimchy · May 16, 2012, 7:49pm

Thats because on top of the id of the child document, you need to provide
the parent id in the parent parameter or the routing parameter. The child
document ends up being assigned to the same shard as the parent, so getting
it requires knowledge of the parent id to properly route it.

On Wed, May 16, 2012 at 4:48 PM, Yuriy Bondaruk bondyk@gmail.com wrote:

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
_routing: {
required: true
}
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
process-id: {
index: not_analyzed
type: string
}
}
_parent: {
type: MessageItem
}
}
MessageItem: {
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
status: {
index: not_analyzed
type: string
}
}
}

Yuriy_Bondaruk · May 16, 2012, 8:14pm

Hi,

Thanks for the answer.

Now I have another questions:

Is it possible to search child document in all parent docs by child id
(I don't know the parent) in realtime (as GET operation)?
Can I use GET request with specified parent-id + child-id or only POST
search?

On Wed, May 16, 2012 at 10:49 PM, Shay Banon kimchy@gmail.com wrote:

Thats because on top of the id of the child document, you need to provide
the parent id in the parent parameter or the routing parameter. The child
document ends up being assigned to the same shard as the parent, so getting
it requires knowledge of the parent id to properly route it.

On Wed, May 16, 2012 at 4:48 PM, Yuriy Bondaruk bondyk@gmail.com wrote:

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
_routing: {
required: true
}
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
process-id: {
index: not_analyzed
type: string
}
}
_parent: {
type: MessageItem
}
}
MessageItem: {
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
status: {
index: not_analyzed
type: string
}
}
}

--
Best regards,
Yuriy Bondaruk

mailto: yuriy.bondaruk@gmail.com

kimchy · May 16, 2012, 10:25pm

On Wed, May 16, 2012 at 11:14 PM, Юрій Іванович Бондарук
bondyk@gmail.comwrote:

Hi,

Thanks for the answer.

Now I have another questions:

Is it possible to search child document in all parent docs by child id
(I don't know the parent) in realtime (as GET operation)?

If you don't know the parent id, then yes, you can do a search for it
instead.

Can I use GET request with specified parent-id + child-id or only POST
search?

Yes, you can do a GET request to get the child document by its id and the
parent. Just specify the parent id in the routing parameter. I will add a
parent parameter option as well...

On Wed, May 16, 2012 at 10:49 PM, Shay Banon kimchy@gmail.com wrote:

Thats because on top of the id of the child document, you need to provide
the parent id in the parent parameter or the routing parameter. The child
document ends up being assigned to the same shard as the parent, so getting
it requires knowledge of the parent id to properly route it.

On Wed, May 16, 2012 at 4:48 PM, Yuriy Bondaruk bondyk@gmail.com wrote:

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
_routing: {
required: true
}
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
process-id: {
index: not_analyzed
type: string
}
}
_parent: {
type: MessageItem
}
}
MessageItem: {
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
status: {
index: not_analyzed
type: string
}
}
}

--
Best regards,
Yuriy Bondaruk

mailto: yuriy.bondaruk@gmail.com

kimchy · May 16, 2012, 10:28pm

Here is the issue:
Get API: Allow to provide a parent value which automatically set the routing value · Issue #1961 · elastic/elasticsearch · GitHub (for now you can
simply set the routing value).

On Thu, May 17, 2012 at 1:25 AM, Shay Banon kimchy@gmail.com wrote:

On Wed, May 16, 2012 at 11:14 PM, Юрій Іванович Бондарук <bondyk@gmail.com

wrote:

Hi,

Thanks for the answer.

Now I have another questions:

Is it possible to search child document in all parent docs by child id
(I don't know the parent) in realtime (as GET operation)?

If you don't know the parent id, then yes, you can do a search for it
instead.

Can I use GET request with specified parent-id + child-id or only POST
search?

Yes, you can do a GET request to get the child document by its id and the
parent. Just specify the parent id in the routing parameter. I will add a
parent parameter option as well...

On Wed, May 16, 2012 at 10:49 PM, Shay Banon kimchy@gmail.com wrote:

Thats because on top of the id of the child document, you need to
provide the parent id in the parent parameter or the routing parameter. The
child document ends up being assigned to the same shard as the parent, so
getting it requires knowledge of the parent id to properly route it.

On Wed, May 16, 2012 at 4:48 PM, Yuriy Bondaruk bondyk@gmail.comwrote:

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
_routing: {
required: true
}
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
process-id: {
index: not_analyzed
type: string
}
}
_parent: {
type: MessageItem
}
}
MessageItem: {
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
status: {
index: not_analyzed
type: string
}
}
}

--
Best regards,
Yuriy Bondaruk

mailto: yuriy.bondaruk@gmail.com

Yuriy_Bondaruk · May 17, 2012, 7:05am

Thanks for the enhancement. It works well!

On Thu, May 17, 2012 at 1:28 AM, Shay Banon kimchy@gmail.com wrote:

Here is the issue:
Get API: Allow to provide a parent value which automatically set the routing value · Issue #1961 · elastic/elasticsearch · GitHub (for now you
can simply set the routing value).

On Thu, May 17, 2012 at 1:25 AM, Shay Banon kimchy@gmail.com wrote:

On Wed, May 16, 2012 at 11:14 PM, Юрій Іванович Бондарук <
bondyk@gmail.com> wrote:

Hi,

Thanks for the answer.

Now I have another questions:

Is it possible to search child document in all parent docs by child
id (I don't know the parent) in realtime (as GET operation)?

If you don't know the parent id, then yes, you can do a search for it
instead.

Can I use GET request with specified parent-id + child-id or only
POST search?

Yes, you can do a GET request to get the child document by its id and the
parent. Just specify the parent id in the routing parameter. I will add a
parent parameter option as well...

On Wed, May 16, 2012 at 10:49 PM, Shay Banon kimchy@gmail.com wrote:

Thats because on top of the id of the child document, you need to
provide the parent id in the parent parameter or the routing parameter. The
child document ends up being assigned to the same shard as the parent, so
getting it requires knowledge of the parent id to properly route it.

On Wed, May 16, 2012 at 4:48 PM, Yuriy Bondaruk bondyk@gmail.comwrote:

Hi,

I have a problem with getting a child document by it's id. I send GET
request 'localhost:9200/test-index/ChildItem/41311aa0' and the
response says that item with the specified id doesn't exist. If use
_search query then the document is returning as expected.
But if I don't use parent/child configuration for ChildItem document
then GET operation works well.

Why ES doesn't return document by it's id when the parent/child
configuration is using? Or should I change GET request somehow?

Here is mapping of the child and parent:

ChildItem: {
_routing: {
required: true
}
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
process-id: {
index: not_analyzed
type: string
}
}
_parent: {
type: MessageItem
}
}
MessageItem: {
properties: {
timestamp: {
format: dateOptionalTime
type: date
}
status: {
index: not_analyzed
type: string
}
}
}

--
Best regards,
Yuriy Bondaruk

mailto: yuriy.bondaruk@gmail.com

--
Best regards,
Yuriy Bondaruk

Topic		Replies	Views
Get document by id is does not work for some docs but the docs are there Elasticsearch	5	3568	July 6, 2017
Having problem retrieving child documents with their IDs Elasticsearch	2	297	July 6, 2017
Can't retrieve a document with its _id? Elasticsearch	5	1518	July 5, 2017
Is there a way to get children documents using GET and not SEARCH? Elasticsearch	1	388	July 5, 2017
Parent/Child Relationship & Routing a Document HEAD request Elasticsearch	2	690	July 5, 2017

Get child doument by id

Related topics