Re: Indexing an oracle warehouse table

2010-02-03 Thread caman
Thanks. I will give this a shot. Alexey-34 wrote: > >> What would be the right way to point out which field contains the term >> searched for. > I would use highlighting for all of these fields and then post process > Solr response in order to check highlighting tags. But I don't have so > many

Re: Indexing an oracle warehouse table

2010-02-03 Thread Alexey Serba
> What would be the right way to point out which field contains the term > searched for. I would use highlighting for all of these fields and then post process Solr response in order to check highlighting tags. But I don't have so many fields usually and don't know if it's possible to configure So

Re: Indexing an oracle warehouse table

2010-02-02 Thread caman
Thanks all. I am on track. Another question: What would be the right way to point out which field contains the term searched for. e.g. If I search for SOLR and if the term exist in field788 for a document, how do I pinpoint that which field has the term. I copied all the fields in field called 'b

Re: Indexing an oracle warehouse table

2010-02-02 Thread Ron Chan
solr or collect/transform into reduced set of solr documents - Original Message - From: "caman" To: solr-user@lucene.apache.org Sent: Tuesday, 2 February, 2010 6:31:36 PM Subject: Re: Indexing an oracle warehouse table Ron, Much appreciated. Search requirements a

RE: Indexing an oracle warehouse table

2010-02-02 Thread Ken Lane (kenlane)
theotherst...@gmail.com] Sent: Tuesday, February 02, 2010 12:35 PM To: solr-user@lucene.apache.org Subject: Re: Indexing an oracle warehouse table Anyone please? caman wrote: > > Hello all, > > hope someone can point me to right direction. I am trying to index an > oracle wa

Re: Indexing an oracle warehouse table

2010-02-02 Thread caman
Ron, Much appreciated. Search requirements are as : 1) Enable search/faceting on author,service,datetime. 2) Enable full text search on all text column which are named as col1 col800+ -- total of more than 800 columns. Here is what I did so far: Defined entities in db schema in db-config

Re: Indexing an oracle warehouse table

2010-02-02 Thread Ron Chan
it depends on what the search requirements are, so without knowing the details here are some vague pointers you may only need to have fields for the columns you are going to be categorizing and searching on, this may be a small subset of the 800 and the rest can go into one large field to fulf

Re: Indexing an oracle warehouse table

2010-02-02 Thread caman
Anyone please? caman wrote: > > Hello all, > > hope someone can point me to right direction. I am trying to index an > oracle warehouse table(TableA) with 850 columns. Out of the structure > about 800 fields are CLOBs and are good candidate to enable full-text > searching. Also have few column