What about a graph database? It is the right tool for this kind of problem
-Original Message-
From: sambasivarao giddaluri
Sent: Wednesday, January 29, 2020 2:31 PM
To: solr-user@lucene.apache.org
Subject: For Hierarchical data structure is Graph Query a good option ?
Hi ,
I have a
Hi ,
I have a data in hierarchical structure ex:
parent --> children --> grandchildren
Usecase:
Get parent docs by adding filter on children and grand children or Get
grand children docs by adding filters on parent and children
To accommodate this use case i have flattened the docs by addin
Solr User Group,
I would like to return a hierarchical data relationship when somebody
queries for a parent doc in solr. This sort of relationship doesn't currently
exist in our core as the use-case has been to search for a specific document
only. However, here's kind of
the db-data-config.xml
like:
Thanks to James and others for their help.
O. O.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924p4065400.html
Sent from the Solr - User
he older CachedSEP.
>
> Here's the wiki link with an example:
> http://wiki.apache.org/solr/DataImportHandler#CachedSqlEntityProcessor
>
> James Dyer
> Ingram Content Group
> (615) 213-4311
--
View this message in context:
http://lucene.472066.n3.nabble.com/Speed-up-impo
hoo.it]
Sent: Thursday, May 16, 2013 5:06 PM
To: solr-user@lucene.apache.org
Subject: RE: Speed up import of Hierarchical Data
Thank you James. Are there any examples of SortedMapBackedCache? I am new to
Solr and I do not find many tutorials in this regard. I just modified the
examples and the
Hi,
I have been following http://wiki.apache.org/solr/HierarchicalFaceting
I have hierarchical data for facet . Some documents also have multiple
hierarchy. like :
Doc#1 London > UK > 51.5
Doc#2 UK >54.0
Doc#3 Indiana > United States > 40.0, London >UK>51.5
Doc#4
t; James Dyer
> Ingram Content Group
> (615) 213-4311
--
View this message in context:
http://lucene.472066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924p4064040.html
Sent from the Solr - User mailing list archive at Nabble.com.
066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924p4064034.html
Sent from the Solr - User mailing list archive at Nabble.com.
13-4311
-Original Message-
From: O. Olson [mailto:olson_...@yahoo.it]
Sent: Thursday, May 16, 2013 11:01 AM
To: solr-user@lucene.apache.org
Subject: Speed up import of Hierarchical Data
I am using the DataImportHandler to Query a SQL Server and populate Solr.
Unfortunately, SQL doe
duct. This results in a very slow import. Is there any way to
> speed this up? I would not mind an intermediate step of first extracting SQL
> and then putting it into Solr.
>
> Thank you for all your help.
> O. O.
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924.html
> Sent from the Solr - User mailing list archive at Nabble.com
> (http://Nabble.com).
>
>
message in context:
http://lucene.472066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924.html
Sent from the Solr - User mailing list archive at Nabble.com.
n to index hierarchical data (unless it already exists).
Twitter :http://www.twitter.com/m_cucchiara
G+ :https://plus.google.com/107903711540963855921
Linkedin:http://www.linkedin.com/in/mauriziocucchiara
VisualizeMe: http://vizualize.me/maurizio.cucchiara?r=maurizio.cucchiara
Maurizio
Best
Erick
On Tue, Oct 2, 2012 at 12:59 PM, Maurizio Cucchiara
wrote:
> Hi all,
> I'm trying to import some hierarchical data (stored in MySQL) on Solr,
> using DataImportHandler.
> Unfortunately, as most of you already knows, MySQL has no support for
> recursive queries, so
Ciao Davide,
Unfortunately changing the structure of the dbs is not an option for
me (there are many legacy dbs involved), otherwise I would have chosen
a /closure table/ instead of the /path enumeration/ you mentioned
before.
Furthermore, I'd need 2 PE fields: 1 for the values (ids) and 1 for
th
Hi Maurizio,
if you can manipulate your MySql db a simpler solution can be the following:
1 - Add a new field for your hierarchical data inside your table
MY_HIERARCHICAL_FIELD
2 - Populate directly in MySql this new field with a simple procedure*
3 - Import the data in your Solr index
*The
Hi all,
I'm trying to import some hierarchical data (stored in MySQL) on Solr,
using DataImportHandler.
Unfortunately, as most of you already knows, MySQL has no support for
recursive queries, so there is no way to get hierarchical data stored
as an adjacency list.
So I considered writing
eries to get
>> interesting results as in "color light beige" or "color light".
>>
>> Normalizing is bad in this kind of environment.
>>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/complex-keywords-hierarchical-data-Solr-representation-problem-tp3642588p3644563.html
> Sent from the Solr - User mailing list archive at Nabble.com.
ot;color light beige" or "color light".
>
> Normalizing is bad in this kind of environment.
>
--
View this message in context:
http://lucene.472066.n3.nabble.com/complex-keywords-hierarchical-data-Solr-representation-problem-tp3642588p3644563.html
Sent from the Solr - User mailing list archive at Nabble.com.
t; keyword: black horse
> category: animal > horse
> category: color > light > white
> category: color > dark > black
>
> You already see, that I'm very confused :-) The second solution gets kind
> of
> messy and the third solution have me to extract the parent categories by
> hand.
>
> Is there anything you can recommend how to solve this the smart way?
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/complex-keywords-hierarchical-data-Solr-representation-problem-tp3642588p3642588.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
extract the parent categories by
hand.
Is there anything you can recommend how to solve this the smart way?
--
View this message in context:
http://lucene.472066.n3.nabble.com/complex-keywords-hierarchical-data-Solr-representation-problem-tp3642588p3642588.html
Sent from the Solr - User mailing list archive at Nabble.com.
21 matches
Mail list logo