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 a DIH custom transformers which given a specified sql (like select * from categories) and a value (f.e. category_id): * fetches all data * builds an hierarchical representation of the fetched data * optionally caches the hierarchical data structure * then returns 2 multi-valued lists which contain the 2 full paths (as String and as Number)
Is there something out of the box? Alternatively, does the above approach sound good? TIA 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 Cucchiara
