I think, the query it self is wrong,
The query should be
select id_bread,buttertype from bread,butter where a.id_bread=b.id_bread
-----Original Message-----
From: "snowyeoghan [via Lucene]"
<ml-node+1956579-1073231976-225...@n3.nabble.com>
Sent: Tuesday, November 23, 2010 4:22pm
To: "sivaprasad" <sivaprasa...@echidnainc.com>
Subject: DIH - index Multiple tables in Database?
Hello.
Hopefully somebody here can help me...
I have a database, with several tables. I want to index these tables in one go,
but I am having no luck.
For example:
Two dB's:
db1 = bread
db2 = butter
<entity name="bread101" query="select id_bread from bread UNION select
buttertype from butter">
<field column="id_bread" name="id" />
<field column="buttertype" name="buttertype" />
</entity>
Only id_bread is being indexed. Can solr handle the UNION case??
Is there an alternative way of doing this? I looked into merging the two
tables, but that looks like a serious pain.
Any help is greatly appreciated :)
View message @
[http://lucene.472066.n3.nabble.com/DIH-index-Multiple-tables-in-Database-tp1956579p1956579.html]
http://lucene.472066.n3.nabble.com/DIH-index-Multiple-tables-in-Database-tp1956579p1956579.html
To start a new topic under Solr - User, email
ml-node+472068-1030716887-225...@n3.nabble.com
To unsubscribe from Solr - User,
[http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=472068&code=c2l2YXByYXNhZC5qQGVjaGlkbmFpbmMuY29tfDQ3MjA2OHwtMjAyODMzMTY4OQ==]
click here.
--
View this message in context:
http://lucene.472066.n3.nabble.com/DIH-index-Multiple-tables-in-Database-tp1956579p1958449.html
Sent from the Solr - User mailing list archive at Nabble.com.
