RE: DataImportHandler with multiline SQL

2010-09-19 Thread Ephraim Ofir
I'd go with moving this logic to the DB in a stored procedure... Ephraim Ofir | Reporting and Host Development team | ICQ P: +972 3 7665510 | M: + 972 52 4888510 | F: +972 3 7665566 | ICQ#: 18981 | E: ephra...@icq.com   -Original Message- From: David Yang [mailto:dy...@nextjump.com]

Re: DataImportHandler with multiline SQL

2010-09-17 Thread kenf_nc
Sounds like you want the http://wiki.apache.org/solr/DataImportHandler#CachedSqlEntityProcessor CachedSqlEntityProcessor it lets you make one query that is cached locally and can be joined to with a separate query. -- View this message in context: http://lucene.472066.n3.nabble.com/DataImportH

Re: DataImportHandler with multiline SQL

2010-09-16 Thread Lukas Kahwe Smith
On 16.09.2010, at 21:07, David Yang wrote: > Hi > > > > I am using the DIH to retrieve data, and as part of the process, I > wanted to create a temporary table and then import data from that. I > have played around a little with DIH and it seems like for a query like: > "select x; select y;" y