On Sat, Oct 29, 2011 at 9:59 PM, Elias Levy <fearsome.lucid...@gmail.com>wrote:
> I am wondering if Riak search can index intermediate nested fields. When
> indexing json data through the KV precommit hook, the underscore is
> understood in the schema as indicating nesting. Thus, foo_bar will index
> the value "bah" of field "bar" in the json document { "foo" : { "bar" :
> "bah" } }.
>
> What I'd like to know is if it can instead index the key "bar" in the same
> json document. In my current use case I want to be able to find documents
> with certain values for "bar" for these types of documents.
>
> Can this be done by simply indexing the field "foo"? Does search know to
> index all keys in "foo" if foo is a hash, or all its values if it is an
> array?
>
My testing on 1.0.0 shows that this appears not to work. Looking at the
source for the search kv extractor gives the impression that a workaround
would be to instead store { "foo" : [ { "x": "bar", "y": "bah"}, { "x":
"woo", "y": "zoo" }, ... ]} and index "foo_z" to be able to search for
"bar" and "woo". I.e. it appears the extractor will index each subdocument
in the array.
At least that is what json_text() function implies with the tests:
{<<"
{\"menu\": {
\"id\": \"file\",
\"value\": \"File\",
\"popup\": {
\"menuitem\": [
{\"value\": \"New\", \"onclick\": \"CreateNewDoc()\"},
{\"value\": \"Open\", \"onclick\": \"OpenDoc()\"},
{\"value\": \"Close\", \"onclick\": \"CloseDoc()\"}
]
}
}}">>,
[{<<"menu_id">>, <<"file">>},
{<<"menu_value">>, <<"File">>},
{<<"menu_popup_menuitem_value">>, <<"New">>},
{<<"menu_popup_menuitem_onclick">>, <<"CreateNewDoc()">>},
{<<"menu_popup_menuitem_value">>, <<"Open">>},
{<<"menu_popup_menuitem_onclick">>, <<"OpenDoc()">>},
{<<"menu_popup_menuitem_value">>, <<"Close">>},
{<<"menu_popup_menuitem_onclick">>, <<"CloseDoc()">>}]},
%% From http://www.ibm.com/developerworks/library/x-atom2json.html
> The implication of the above code is that you can search for
menu_popup_menuitem_value:New or menu_popup_menuitem_value:Open and find
the doc. But my testing shows this not to work. If any of the documents
in the array have the same fields, those fields will not be indexed.
E.g. if I set my schema to index foo_bar and insert {"foo": [ { "bar" :
"baz" }, {"xxx":"yyy"} ] }, I can search for foo_bar:baz and receive a
match. If I instead insert '{"foo": [ { "bar" : "baz" }, {"bar":"yyy"} ]
}' and search for foo_bar:baz I receive no match.
Is this expected behavior or a bug?
Elias
_______________________________________________
riak-users mailing list
riak-users@lists.basho.com
http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
