Hi Everyone,
I am working on Hierarchical Faceting. I am indexing location of
document with their state and district.
I would like to find counts of every country with state count and
district count. I found facet pivot working well to give me count if i
use single valued fields like
-------
<doc>
<str name="country">india</str>
<str name="state">maharashtra</str>
</doc>
<doc>
<str name="country">india</str>
<str name="state">gujrat</str>
</doc>
<doc>
<str name="country">india</str>
<str name="district">Faridabad</str>
<str name="state">Haryana</str>
</doc>
<doc>
<str name="country">china</str>
<str name="district">foshan</str>
<str name="state">guangdong</str>
</doc>
------------
I found results that is fine :
<arr name="country,state,district,event">
<lst>
<str name="field">country</str>
<str name="value">india</str>
<int name="count">1</int>
<arr name="pivot">
<lst>
<str name="field">state</str>
<str name="value">maharashtra</str>
<int name="count">1</int>
<arr name="pivot"></arr>
<lst>
<str name="field">state</str>
<str name="value">Haryana</str>
<int name="count">1</int>
<arr name="pivot">
<lst>
<str name="field">district</str>
<str name="value">Faridabad</str>
<int name="count">1</int>
</lst>
</arr>
</lst>
</arr>
</lst>
</arr>
</lst>
<lst>
<str name="field">country</str>
<str name="value">china</str>
<int name="count">1</int>
<arr name="pivot">
<lst>
<str name="field">state</str>
....
</lst>
</arr>
But if my document have multiple location like :
<doc>
<arr name="location">
<str>japan|JAPAN|null|</str>
<str>
brisbane|Australia|Queensland
</str>
<str>
afghanistan|AFGHANISTAN|null
</str>
</arr>
</doc>
<doc>
<arr name="location">
<str>
afghanistan|AFGHANISTAN|null
</str>
</arr>
</doc>
<doc>
<arr name="location">
<str>
brisbane|Australia|Queensland
</str>
</str>
</arr>
</doc>
Can anyone tell , me how should i put data in solr index to get
hierarical data.
Thanks
Varsha
