Re: Highlighting the search keywords

[Renuka Srishti]

First of all thanks to all, its a great community and amazing experience to
work with Apache Solr.

I was trying to use highlight component inside suggest request handler by
mentioning highlight component like this:

 suggest
highlight


So I can use suggestions and highlighter at the same time, but its not
working. Am I missing something?


Thanks
Renuka Srishti

On Wed 1 Aug, 2018, 12:05 Nicolas Franck,  wrote:

> Nope, that is how it works. It is not in place.
>
> > On 31 Jul 2018, at 21:57, Renuka Srishti 
> wrote:
> >
> > Hi All,
> >
> > I was using highlighting in solr, solr gives highlighting results within
> > the response but not included within the documents.
> > Am i missing something? Can i configure so that it can show highlighted
> > keywords matched within the documents.
> >
> > Thanks
> > Renuka Srishti
>
>

Highlighting the search keywords

[Renuka Srishti]

Hi All,

I was using highlighting in solr, solr gives highlighting results within
the response but not included within the documents.
Am i missing something? Can i configure so that it can show highlighted
keywords matched within the documents.

Thanks
Renuka Srishti

Re: Search without passing any field

[Renuka Srishti]

Okay, great. I will start with the available solution . My index is less
than yours, so may be it will work.

Thanks
Renuka Srishti

On Mon, Jul 30, 2018 at 12:04 AM, Walter Underwood 
wrote:

> No, it won’t slow down performance, but it might use more disk space for
> the index.
>
> Searching one field is usually faster than searching multiple fields. If
> it was a lot slower,
> the tutorial would have warned about that.
>
> How large is your index? There are some very large Solr collections. Ours
> is 26 million
> docs and it isn’t close to the biggest.
>
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
>
> > On Jul 29, 2018, at 11:15 AM, Renuka Srishti 
> wrote:
> >
> > Yeah, I read that, but it will slow down the performance, as copying all
> > the fields and put that data in one field. I think for large index it is
> > not the right way to do. Am I right?
> >
> > Regards,
> > Renuka Srishti
> >
> > On Sun, Jul 29, 2018 at 11:39 PM, Alexandre Rafalovitch <
> arafa...@gmail.com>
> > wrote:
> >
> >> Did you go through the tutorial in the Reference Guide?
> >>
> >> it explains a lot of these and has configuration for you to check. See
> >> for example (in a middle of tutorial):
> >> https://lucene.apache.org/solr/guide/7_4/solr-tutorial.
> >> html#create-a-catchall-copy-field
> >>
> >> Regards,
> >>   Alex.
> >>
> >> On 29 July 2018 at 13:45, Renuka Srishti 
> >> wrote:
> >>> Thanks for response,
> >>>
> >>> Let me explain with an example.
> >>> I have following fields : name, description, id, title.
> >>> These fields have following values:
> >>> doc1 -
> >>> name : test
> >>> description : test and run
> >>> id : t1
> >>> title : abc title
> >>>
> >>> doc2 -
> >>> name : abc
> >>> description : test and run again
> >>> id : t2
> >>> title : xyz title
> >>>
> >>> You can see name and description both contain "test", so my question is
> >> if
> >>> I will query for "test" using "q" parameter without specifying the
> fields
> >>> in either "df" or "qf", will it be able to search? Because I tried,
> and I
> >>> think you have to mention the fields otherwise it will not work.
> >>> If I will put "df" and "qf" value as "name", so it will return only
> doc1,
> >>> but I want to return both documents when I query "test" (Because
> >>> description also contains "test"). Will it be possible without
> >> configuring
> >>> the "df" or "qf"? Is there any way to apply search on all fields?
> >>>
> >>> Thanks
> >>> Renuka Srishti
> >>>
> >>> On Sun, Jul 29, 2018 at 8:12 PM, Erick Erickson <
> erickerick...@gmail.com
> >>>
> >>> wrote:
> >>>
> >>>> What do you want Solr to do in that case? Search all the defined
> >>>> fields? Some of them? Pick randomly?
> >>>>
> >>>> This is like asking "can Solr do what I want without telling it what I
> >>>> want?".
> >>>>
> >>>> You can define df or qf _defaults_ in solrconfig.xml for the request
> >>>> handler, that's what those are for.
> >>>> Then the _user_ doesn't need to specify them. Somebody has to however
> >>>> and defaults are how those
> >>>> are usually done.
> >>>>
> >>>> Best,
> >>>> Erick
> >>>>
> >>>> On Sun, Jul 29, 2018 at 7:07 AM, Alexandre Rafalovitch
> >>>>  wrote:
> >>>>> Solr does need to know what field(s) you want to search. And you can
> >>>>> configure all of these things in solrconfig.xml, so the user does not
> >>>>> have to provide that.
> >>>>>
> >>>>> Just remember, unless you really know what you are doing, you should
> >>>>> not be exposing Solr directly to the user/browser. Think of it more
> >>>>> like a database with another layer between it and user-queries.
> >>>>> Otherwise, somebody could delete your whole index, etc.
> >>>>>
> >>>>> Regards,
> >>>>>   Alex.
> >>>>>
> >>>>> On 29 July 2018 at 09:11, Renuka Srishti  >
> >>>> wrote:
> >>>>>> Hi,
> >>>>>>
> >>>>>> Is there any possible way to perform search by using "q" or "query"
> >>>>>> parameter without setting "df" parameter or "qf" parameter.
> >>>>>>
> >>>>>> for example: I am passing "q":"xyz"
> >>>>>> I have to mention the field for which I want to perform query
> >> otherwise
> >>>> I
> >>>>>> will not get results.
> >>>>>>
> >>>>>> What is the way if I want to search on all documents without
> >> mentioning
> >>>> any
> >>>>>> field.
> >>>>>> for example : I am passing "q":"xyz"
> >>>>>> If I query like that, it should return all the documents containing
> >> that
> >>>>>> value. No need to mention the fields.
> >>>>>>
> >>>>>> Thanks
> >>>>>> Renuka Srishti
> >>>>
> >>
>
>

Re: Search without passing any field

[Renuka Srishti]

Thanks I got it. Somehow I have to tell about fields to solr, it can't
automatically apply search on all indexed fields.


On Sun, Jul 29, 2018 at 11:54 PM, Alexandre Rafalovitch 
wrote:

> You may be doing premature optimization here.
>
> Remember the copyTarget is store=false/docValues=false, so you are
> only actually storing unique tokens and document ids/offsets. I would
> recommend you start from that, do your first schema, figure out what
> you are not happy about, evolve it, etc.
>
> However, you can also switch to eDismax and name specific fields you
> want to search with qf parameter.
> https://lucene.apache.org/solr/guide/7_4/the-extended-
> dismax-query-parser.html
> (extension of base query parser).
>
> Just remember that the processing of the field depends on the field
> type. So, with copyField, you were searching everything by that type
> (probably text). With eDismax, if your field is string, you have to
> match it exactly. Unless you copyField and process it twice. And so
> on. You have a lot of options, depending on your use cases.
>
> Good luck,
>Alex.
>
> On 29 July 2018 at 14:15, Renuka Srishti 
> wrote:
> > Yeah, I read that, but it will slow down the performance, as copying all
> > the fields and put that data in one field. I think for large index it is
> > not the right way to do. Am I right?
> >
> > Regards,
> > Renuka Srishti
> >
> > On Sun, Jul 29, 2018 at 11:39 PM, Alexandre Rafalovitch <
> arafa...@gmail.com>
> > wrote:
> >
> >> Did you go through the tutorial in the Reference Guide?
> >>
> >> it explains a lot of these and has configuration for you to check. See
> >> for example (in a middle of tutorial):
> >> https://lucene.apache.org/solr/guide/7_4/solr-tutorial.
> >> html#create-a-catchall-copy-field
> >>
> >> Regards,
> >>Alex.
> >>
> >> On 29 July 2018 at 13:45, Renuka Srishti 
> >> wrote:
> >> > Thanks for response,
> >> >
> >> > Let me explain with an example.
> >> > I have following fields : name, description, id, title.
> >> > These fields have following values:
> >> > doc1 -
> >> > name : test
> >> > description : test and run
> >> > id : t1
> >> > title : abc title
> >> >
> >> > doc2 -
> >> > name : abc
> >> > description : test and run again
> >> > id : t2
> >> > title : xyz title
> >> >
> >> > You can see name and description both contain "test", so my question
> is
> >> if
> >> > I will query for "test" using "q" parameter without specifying the
> fields
> >> > in either "df" or "qf", will it be able to search? Because I tried,
> and I
> >> > think you have to mention the fields otherwise it will not work.
> >> > If I will put "df" and "qf" value as "name", so it will return only
> doc1,
> >> > but I want to return both documents when I query "test" (Because
> >> > description also contains "test"). Will it be possible without
> >> configuring
> >> > the "df" or "qf"? Is there any way to apply search on all fields?
> >> >
> >> > Thanks
> >> > Renuka Srishti
> >> >
> >> > On Sun, Jul 29, 2018 at 8:12 PM, Erick Erickson <
> erickerick...@gmail.com
> >> >
> >> > wrote:
> >> >
> >> >> What do you want Solr to do in that case? Search all the defined
> >> >> fields? Some of them? Pick randomly?
> >> >>
> >> >> This is like asking "can Solr do what I want without telling it what
> I
> >> >> want?".
> >> >>
> >> >> You can define df or qf _defaults_ in solrconfig.xml for the request
> >> >> handler, that's what those are for.
> >> >> Then the _user_ doesn't need to specify them. Somebody has to however
> >> >> and defaults are how those
> >> >> are usually done.
> >> >>
> >> >> Best,
> >> >> Erick
> >> >>
> >> >> On Sun, Jul 29, 2018 at 7:07 AM, Alexandre Rafalovitch
> >> >>  wrote:
> >> >> > Solr does need to know what field(s) you want to search. And you
> can
> >> >> > configure all of these things in solrconfig.xml, so the user does
> not
> >&

Re: Search without passing any field

[Renuka Srishti]

Yeah, I read that, but it will slow down the performance, as copying all
the fields and put that data in one field. I think for large index it is
not the right way to do. Am I right?

Regards,
Renuka Srishti

On Sun, Jul 29, 2018 at 11:39 PM, Alexandre Rafalovitch 
wrote:

> Did you go through the tutorial in the Reference Guide?
>
> it explains a lot of these and has configuration for you to check. See
> for example (in a middle of tutorial):
> https://lucene.apache.org/solr/guide/7_4/solr-tutorial.
> html#create-a-catchall-copy-field
>
> Regards,
>Alex.
>
> On 29 July 2018 at 13:45, Renuka Srishti 
> wrote:
> > Thanks for response,
> >
> > Let me explain with an example.
> > I have following fields : name, description, id, title.
> > These fields have following values:
> > doc1 -
> > name : test
> > description : test and run
> > id : t1
> > title : abc title
> >
> > doc2 -
> > name : abc
> > description : test and run again
> > id : t2
> > title : xyz title
> >
> > You can see name and description both contain "test", so my question is
> if
> > I will query for "test" using "q" parameter without specifying the fields
> > in either "df" or "qf", will it be able to search? Because I tried, and I
> > think you have to mention the fields otherwise it will not work.
> > If I will put "df" and "qf" value as "name", so it will return only doc1,
> > but I want to return both documents when I query "test" (Because
> > description also contains "test"). Will it be possible without
> configuring
> > the "df" or "qf"? Is there any way to apply search on all fields?
> >
> > Thanks
> > Renuka Srishti
> >
> > On Sun, Jul 29, 2018 at 8:12 PM, Erick Erickson  >
> > wrote:
> >
> >> What do you want Solr to do in that case? Search all the defined
> >> fields? Some of them? Pick randomly?
> >>
> >> This is like asking "can Solr do what I want without telling it what I
> >> want?".
> >>
> >> You can define df or qf _defaults_ in solrconfig.xml for the request
> >> handler, that's what those are for.
> >> Then the _user_ doesn't need to specify them. Somebody has to however
> >> and defaults are how those
> >> are usually done.
> >>
> >> Best,
> >> Erick
> >>
> >> On Sun, Jul 29, 2018 at 7:07 AM, Alexandre Rafalovitch
> >>  wrote:
> >> > Solr does need to know what field(s) you want to search. And you can
> >> > configure all of these things in solrconfig.xml, so the user does not
> >> > have to provide that.
> >> >
> >> > Just remember, unless you really know what you are doing, you should
> >> > not be exposing Solr directly to the user/browser. Think of it more
> >> > like a database with another layer between it and user-queries.
> >> > Otherwise, somebody could delete your whole index, etc.
> >> >
> >> > Regards,
> >> >Alex.
> >> >
> >> > On 29 July 2018 at 09:11, Renuka Srishti 
> >> wrote:
> >> >> Hi,
> >> >>
> >> >> Is there any possible way to perform search by using "q" or "query"
> >> >> parameter without setting "df" parameter or "qf" parameter.
> >> >>
> >> >> for example: I am passing "q":"xyz"
> >> >> I have to mention the field for which I want to perform query
> otherwise
> >> I
> >> >> will not get results.
> >> >>
> >> >> What is the way if I want to search on all documents without
> mentioning
> >> any
> >> >> field.
> >> >> for example : I am passing "q":"xyz"
> >> >> If I query like that, it should return all the documents containing
> that
> >> >> value. No need to mention the fields.
> >> >>
> >> >> Thanks
> >> >> Renuka Srishti
> >>
>

Re: Search without passing any field

[Renuka Srishti]

Thanks for response,

Let me explain with an example.
I have following fields : name, description, id, title.
These fields have following values:
doc1 -
name : test
description : test and run
id : t1
title : abc title

doc2 -
name : abc
description : test and run again
id : t2
title : xyz title

You can see name and description both contain "test", so my question is if
I will query for "test" using "q" parameter without specifying the fields
in either "df" or "qf", will it be able to search? Because I tried, and I
think you have to mention the fields otherwise it will not work.
If I will put "df" and "qf" value as "name", so it will return only doc1,
but I want to return both documents when I query "test" (Because
description also contains "test"). Will it be possible without configuring
the "df" or "qf"? Is there any way to apply search on all fields?

Thanks
Renuka Srishti

On Sun, Jul 29, 2018 at 8:12 PM, Erick Erickson 
wrote:

> What do you want Solr to do in that case? Search all the defined
> fields? Some of them? Pick randomly?
>
> This is like asking "can Solr do what I want without telling it what I
> want?".
>
> You can define df or qf _defaults_ in solrconfig.xml for the request
> handler, that's what those are for.
> Then the _user_ doesn't need to specify them. Somebody has to however
> and defaults are how those
> are usually done.
>
> Best,
> Erick
>
> On Sun, Jul 29, 2018 at 7:07 AM, Alexandre Rafalovitch
>  wrote:
> > Solr does need to know what field(s) you want to search. And you can
> > configure all of these things in solrconfig.xml, so the user does not
> > have to provide that.
> >
> > Just remember, unless you really know what you are doing, you should
> > not be exposing Solr directly to the user/browser. Think of it more
> > like a database with another layer between it and user-queries.
> > Otherwise, somebody could delete your whole index, etc.
> >
> > Regards,
> >Alex.
> >
> > On 29 July 2018 at 09:11, Renuka Srishti 
> wrote:
> >> Hi,
> >>
> >> Is there any possible way to perform search by using "q" or "query"
> >> parameter without setting "df" parameter or "qf" parameter.
> >>
> >> for example: I am passing "q":"xyz"
> >> I have to mention the field for which I want to perform query otherwise
> I
> >> will not get results.
> >>
> >> What is the way if I want to search on all documents without mentioning
> any
> >> field.
> >> for example : I am passing "q":"xyz"
> >> If I query like that, it should return all the documents containing that
> >> value. No need to mention the fields.
> >>
> >> Thanks
> >> Renuka Srishti
>

Search without passing any field

[Renuka Srishti]

Hi,

Is there any possible way to perform search by using "q" or "query"
parameter without setting "df" parameter or "qf" parameter.

for example: I am passing "q":"xyz"
I have to mention the field for which I want to perform query otherwise I
will not get results.

What is the way if I want to search on all documents without mentioning any
field.
for example : I am passing "q":"xyz"
If I query like that, it should return all the documents containing that
value. No need to mention the fields.

Thanks
Renuka Srishti

Parameter Mapping

[Renuka Srishti]

Hi,

I was reading the document and I think parameters mapping
<https://lucene.apache.org/solr/guide/7_3/json-request-api.html#parameters-mapping>
mentioned here is not right.
start, rows are used for query parameters.
offset, limit are used for JSON query format.

Should I create the ticket for it?

Thanks
Renuka Srishti

Re: Multiple context fields in suggester component

[Renuka Srishti]

Thanks Alessandro Benedetti for the response. Can you please share the
resources, so that I can explore more about customization of context filter.

On Tue, Feb 13, 2018 at 5:01 PM, Alessandro Benedetti 
wrote:

> Simple answer is No.
> Only one context field is supported out of the box.
> The query you provide as context filtering query ( suggest.cfq= ) is
> going to be parsed and a boolean query for the context field is created
> [1].
>
> You will need some customizations if you are targeting that behavior.
>
> [1] query = new
> StandardQueryParser(contextFilterQueryAnalyzer).parse(contextFilter,
> CONTEXTS_FIELD_NAME);
>
>
>
>
> -
> ---
> Alessandro Benedetti
> Search Consultant, R Software Engineer, Director
> Sease Ltd. - www.sease.io
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>

Multiple context fields in suggester component

[Renuka Srishti]

Hello All,

Is there any way to set multiple context fields in suggester component? Or
is there any way to apply multiple filters with suggester component in solr?

Thanks
Renuka Srishti

Re: TimeZone issue

[Renuka Srishti]

Yes, we have TZ parameter for that which worked only for date math. I need
to convert the date time zone on the client side.

Thanks
Renuka Srishti

On Thu, Nov 16, 2017 at 8:51 PM, Shawn Heisey <apa...@elyograg.org> wrote:

> On 11/16/2017 4:54 AM, Renuka Srishti wrote:
>
>> Thanks for your response Shawn. I know it deals with UTC only, but it will
>> be great if we can change the date timeZone in solr response. As I am
>> using
>> Solr CSV feature and it will be helpful if the date field in the CSV
>> result
>> can convert into client TimeZone. Please suggest if you have any alternate
>> for this.
>>
>
> As I said before, I do not think that Solr will use timezones for date
> display -- ever.  Solr does support timezones in certain circumstances, but
> I'm pretty sure that it is *only* to correctly support date math -- so Solr
> knows what time each day starts for date rounding like NOW/DAY and
> NOW/WEEK.  I have never heard of any feature that applies timezones to date
> information in responses.
>
> Timezone conversion of dates in Solr responses is something you need to do
> in the client, and should be trivial for most web development programming
> languages.
>
> Thanks,
> Shawn
>
>

Re: TimeZone issue

[Renuka Srishti]

Hii Rick,
All clients are in different time zone. So I was searching for some support
which can convert the date fields in the query response in given time zone.

Thanks
Renuka Srishti

On Thu, Nov 16, 2017 at 5:58 PM, Rick Leir <rl...@leirtech.com> wrote:

> Renuka
> Are your clients all in the same time zone? Solr should support clients in
> several timezones, and UTC conversion to local is best done in the client
> in my mind. Thanks -- Rick
>
> On November 16, 2017 6:54:47 AM EST, Renuka Srishti <
> renuka.srisht...@gmail.com> wrote:
> >Thanks for your response Shawn. I know it deals with UTC only, but it
> >will
> >be great if we can change the date timeZone in solr response. As I am
> >using
> >Solr CSV feature and it will be helpful if the date field in the CSV
> >result
> >can convert into client TimeZone. Please suggest if you have any
> >alternate
> >for this.
> >
> >Thanks
> >Renuka Srishti
> >
> >On Wed, Nov 15, 2017 at 6:16 PM, Shawn Heisey <apa...@elyograg.org>
> >wrote:
> >
> >> On 11/15/2017 5:34 AM, Renuka Srishti wrote:
> >>
> >>> I am working on CSV export using Apache Solr. I have written all the
> >>> required query and set wt as CSV. I am getting my results as I
> >want,but
> >>> the
> >>> problem is TimeZone.
> >>>
> >>> Solr stores date value in UTC, but my client timeZone is different.
> >Is
> >>> there any way to convert date timeZone from UTC to clientTimeZone
> >direclty
> >>> in the Solr response?
> >>>
> >>
> >> Not that I know of.  UTC is the only storage/transfer method that
> >works in
> >> all situations.  Converting dates to the local timezone is a task for
> >the
> >> client, when it displays the date to a user.
> >>
> >> Typically, you would consume the response from Solr into object types
> >for
> >> the language your application is written in.  A date value in the
> >response
> >> should end up in a date object.  Date objects in most programming
> >languages
> >> have the ability to display in specific timezones.
> >>
> >> Thanks,
> >> Shawn
> >>
> >>
>
> --
> Sorry for being brief. Alternate email is rickleir at yahoo dot com

Re: TimeZone issue

[Renuka Srishti]

Thanks for your response Shawn. I know it deals with UTC only, but it will
be great if we can change the date timeZone in solr response. As I am using
Solr CSV feature and it will be helpful if the date field in the CSV result
can convert into client TimeZone. Please suggest if you have any alternate
for this.

Thanks
Renuka Srishti

On Wed, Nov 15, 2017 at 6:16 PM, Shawn Heisey <apa...@elyograg.org> wrote:

> On 11/15/2017 5:34 AM, Renuka Srishti wrote:
>
>> I am working on CSV export using Apache Solr. I have written all the
>> required query and set wt as CSV. I am getting my results as I want,but
>> the
>> problem is TimeZone.
>>
>> Solr stores date value in UTC, but my client timeZone is different. Is
>> there any way to convert date timeZone from UTC to clientTimeZone direclty
>> in the Solr response?
>>
>
> Not that I know of.  UTC is the only storage/transfer method that works in
> all situations.  Converting dates to the local timezone is a task for the
> client, when it displays the date to a user.
>
> Typically, you would consume the response from Solr into object types for
> the language your application is written in.  A date value in the response
> should end up in a date object.  Date objects in most programming languages
> have the ability to display in specific timezones.
>
> Thanks,
> Shawn
>
>

TimeZone issue

[Renuka Srishti]

Hello All,

I am working on CSV export using Apache Solr. I have written all the
required query and set wt as CSV. I am getting my results as I want,but the
problem is TimeZone.

Solr stores date value in UTC, but my client timeZone is different. Is
there any way to convert date timeZone from UTC to clientTimeZone direclty
in the Solr response?

When I extract the date from the Solr response, I can convert it into
clientTimeZone by implementing a custom method. But I want the date in
client TimeZone direclty in the solr response.

Thanks
Renuka Srishti

Re: Stats component with function

[Renuka Srishti]

Hello All,

I am exploring the functions
<https://lucene.apache.org/solr/guide/6_6/function-queries.html> and I
think we can perform the above query if we extend
"org.apache.solr.search.function" package to support all available
functions. Are we planning to extend this package to support all functions
like it supports ord().If I am going wrong please correct me.

Thanks
Renuka Srishti

On Tue, Oct 17, 2017 at 2:05 PM, Renuka Srishti <renuka.srisht...@gmail.com>
wrote:

> Hello All
>
> Here is the link
> <https://lucene.apache.org/solr/guide/7_0/faceting.html#combining-stats-component-with-pivots>
> for the reference. I want to use sub() by passing the min and max value of
> the price, can we perform this type of action, with the query given in the
> link.
>
> Thanks
> Renuka Srishti
>

Re: Query Boosting and sort

[Renuka Srishti]

Sorry for late reply. Thanks Erick for the solution, you got my problem and
the picture is right. I have resolved my problem with the similar approach
you mentioned here.

Regards,
Renuka Srishti

On Sat, Sep 9, 2017 at 11:45 PM, Erick Erickson <erickerick...@gmail.com>
wrote:

> I'm a completely lost here.
>
> bq: "I have designed a screen where results are showing in tabular
> form, in each column I have applied sorting( using Solr sort
> parameter)"
>
> What does that mean? What is the relationship between columnA and
> columnB in the same row? Are they from the same doc? Different docs?
> What information is the user getting when they compare columnA and
> columnB in the same row? What information is the user getting when
> they compare columnA from row1 and row2?
>
> bq: "There is one keyword search box, in which I have applied the
> phrase boosting to maintain relevancy.( Most relevant result will show
> on the top).
>
> This seems like a totally unrelated statement. You "applied the phrase
> boosting to maintain relevancy". What relationship does that have to
> "in each column I have applied sorting"?
>
> ---
>  It _sounds_ like you have some kind of grid format where you have N
> docs (rows) and M columns (fields). So each row (doc) has some fields
> displayed. Now you want to sort results by different columns (I'm
> thinking like a spreadsheet where you can sort by clicking the
> different column heads).
>
> So assuming my mental picture is accurate, you have two choices:
>
> 1> you have the top N relevant documents that you want to display
> differently depending on the column selected. When the user switches
> columns you re-sort the top N docs. This is entirely an application
> level sort. You do a single search that returns the top N docs by
> relevance. When the user clicks on a column head you re-sort that
> result set without going to Solr at all.
>
> 2> when the user clicks a column head, you want to display the top N
> docs _from the entire index in sorted order_, which would be a new
> Solr query with sort=column.
>
> Best,
> Erick
>
> On Fri, Sep 8, 2017 at 9:50 PM, Renuka Srishti
> <renuka.srisht...@gmail.com> wrote:
> > Thanks Rick and Erick for your response.
> > Here is the situation where I want to use both sort and phrase boosting:
> >
> >- I have designed a screen where results are showing in tabular form,
> in
> >each column I have applied sorting( using Solr sort parameter). There
> is
> >one keyword search box, in which I have applied the phrase boosting to
> >maintain relevancy.( Most relevant result will show on the top).
> >
> >
> >- Now If I applied keyword search and then I want to sort the result,
> >how I can achieve this?(Sorting completely overrides scoring).
> >
> > Thanks
> >
> > Renuka Srishti
> >
> > On Sat, Sep 9, 2017 at 1:38 AM, Erick Erickson <erickerick...@gmail.com>
> > wrote:
> >
> >> Sorting completely overrides scoring. By specifying a sort parameter
> >> you're effectively telling Solr that you don't care about scoring,
> >> order the docs by the sort criteria.
> >>
> >> On Fri, Sep 8, 2017 at 3:35 AM, Rick Leir <rl...@leirtech.com> wrote:
> >> > Renuka,
> >> >
> >> > You have not told us nearly enough about your issue. What query?
> config?
> >> >
> >> > cheers -- Rick
> >> >
> >> >
> >> >
> >> > On 2017-09-08 05:42 AM, Renuka Srishti wrote:
> >> >>
> >> >> Hello All,
> >> >>
> >> >> I am trying to use sort parameter and phrase boosting together in
> >> search.
> >> >> But, if I use the sort parameter, it seems like Phrase Boosting does
> not
> >> >> work with it.
> >> >>
> >> >> Thanks
> >> >> Renuka Srishti
> >> >>
> >> >
> >>
>

Stats component with function

[Renuka Srishti]

Hello All

Here is the link
<https://lucene.apache.org/solr/guide/7_0/faceting.html#combining-stats-component-with-pivots>
for the reference. I want to use sub() by passing the min and max value of
the price, can we perform this type of action, with the query given in the
link.

Thanks
Renuka Srishti

Re: Query Boosting and sort

[Renuka Srishti]

Thanks Rick and Erick for your response.
Here is the situation where I want to use both sort and phrase boosting:

   - I have designed a screen where results are showing in tabular form, in
   each column I have applied sorting( using Solr sort parameter). There is
   one keyword search box, in which I have applied the phrase boosting to
   maintain relevancy.( Most relevant result will show on the top).


   - Now If I applied keyword search and then I want to sort the result,
   how I can achieve this?(Sorting completely overrides scoring).

Thanks

Renuka Srishti

On Sat, Sep 9, 2017 at 1:38 AM, Erick Erickson <erickerick...@gmail.com>
wrote:

> Sorting completely overrides scoring. By specifying a sort parameter
> you're effectively telling Solr that you don't care about scoring,
> order the docs by the sort criteria.
>
> On Fri, Sep 8, 2017 at 3:35 AM, Rick Leir <rl...@leirtech.com> wrote:
> > Renuka,
> >
> > You have not told us nearly enough about your issue. What query? config?
> >
> > cheers -- Rick
> >
> >
> >
> > On 2017-09-08 05:42 AM, Renuka Srishti wrote:
> >>
> >> Hello All,
> >>
> >> I am trying to use sort parameter and phrase boosting together in
> search.
> >> But, if I use the sort parameter, it seems like Phrase Boosting does not
> >> work with it.
> >>
> >> Thanks
> >> Renuka Srishti
> >>
> >
>

Query Boosting and sort

[Renuka Srishti]

Hello All,

I am trying to use sort parameter and phrase boosting together in search.
But, if I use the sort parameter, it seems like Phrase Boosting does not
work with it.

Thanks
Renuka Srishti

Re: Index relational database

[Renuka Srishti]

Thank all for sharing your thoughts  :)

On Thu, Aug 31, 2017 at 5:28 PM, Susheel Kumar <susheel2...@gmail.com>
wrote:

> Yes, if you can avoid join and work with flat/denormalized structure then
> that's the best.
>
> On Thu, Aug 31, 2017 at 3:54 AM, Renuka Srishti <
> renuka.srisht...@gmail.com>
> wrote:
>
> > Thanks Erick, Walter
> > But I think join query will reduce the performance. Denormalization will
> be
> > the better way than join query, am I right?
> >
> >
> >
> > On Wed, Aug 30, 2017 at 10:18 PM, Walter Underwood <
> wun...@wunderwood.org>
> > wrote:
> >
> > > Think about making a denormalized view, with all the fields needed in
> one
> > > table. That view gets sent to Solr. Each row is a Solr document.
> > >
> > > It could be implemented as a view or as SQL, but that is a useful
> mental
> > > model for people starting from a relational background.
> > >
> > > wunder
> > > Walter Underwood
> > > wun...@wunderwood.org
> > > http://observer.wunderwood.org/  (my blog)
> > >
> > >
> > > > On Aug 30, 2017, at 9:14 AM, Erick Erickson <erickerick...@gmail.com
> >
> > > wrote:
> > > >
> > > > First, it's often best, by far, to denormalize the data in your solr
> > > index,
> > > > that's what I'd explore first.
> > > >
> > > > If you can't do that, the join query parser might work for you.
> > > >
> > > > On Aug 30, 2017 4:49 AM, "Renuka Srishti" <
> renuka.srisht...@gmail.com>
> > > > wrote:
> > > >
> > > >> Thanks Susheel for your response.
> > > >> Here is the scenario about which I am talking:
> > > >>
> > > >>   - Let suppose there are two documents doc1 and doc2.
> > > >>   - I want to fetch the data from doc2 on the basis of doc1 fields
> > which
> > > >>   are related to doc2.
> > > >>
> > > >> How to achieve this efficiently.
> > > >>
> > > >>
> > > >> Thanks,
> > > >>
> > > >> Renuka Srishti
> > > >>
> > > >>
> > > >> On Mon, Aug 28, 2017 at 7:02 PM, Susheel Kumar <
> susheel2...@gmail.com
> > >
> > > >> wrote:
> > > >>
> > > >>> Hello Renuka,
> > > >>>
> > > >>> I would suggest to start with your use case(s). May be start with
> > your
> > > >>> first use case with the below questions
> > > >>>
> > > >>> a) What is that you want to search (which fields like name, desc,
> > city
> > > >>> etc.)
> > > >>> b) What is that you want to show part of search result (name, city
> > > etc.)
> > > >>>
> > > >>> Based on above two questions, you would know what data to pull in
> > from
> > > >>> relational database and create solr schema and index the data.
> > > >>>
> > > >>> You may first try to denormalize / flatten the structure so that
> you
> > > deal
> > > >>> with one collection/schema and query upon it.
> > > >>>
> > > >>> HTH.
> > > >>>
> > > >>> Thanks,
> > > >>> Susheel
> > > >>>
> > > >>> On Mon, Aug 28, 2017 at 8:04 AM, Renuka Srishti <
> > > >>> renuka.srisht...@gmail.com>
> > > >>> wrote:
> > > >>>
> > > >>>> Hii,
> > > >>>>
> > > >>>> What is the best way to index relational database, and how it
> > impacts
> > > >> on
> > > >>>> the performance?
> > > >>>>
> > > >>>> Thanks
> > > >>>> Renuka Srishti
> > > >>>>
> > > >>>
> > > >>
> > >
> > >
> >
>

Re: Index relational database

[Renuka Srishti]

Thanks Erick, Walter
But I think join query will reduce the performance. Denormalization will be
the better way than join query, am I right?



On Wed, Aug 30, 2017 at 10:18 PM, Walter Underwood <wun...@wunderwood.org>
wrote:

> Think about making a denormalized view, with all the fields needed in one
> table. That view gets sent to Solr. Each row is a Solr document.
>
> It could be implemented as a view or as SQL, but that is a useful mental
> model for people starting from a relational background.
>
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
>
>
> > On Aug 30, 2017, at 9:14 AM, Erick Erickson <erickerick...@gmail.com>
> wrote:
> >
> > First, it's often best, by far, to denormalize the data in your solr
> index,
> > that's what I'd explore first.
> >
> > If you can't do that, the join query parser might work for you.
> >
> > On Aug 30, 2017 4:49 AM, "Renuka Srishti" <renuka.srisht...@gmail.com>
> > wrote:
> >
> >> Thanks Susheel for your response.
> >> Here is the scenario about which I am talking:
> >>
> >>   - Let suppose there are two documents doc1 and doc2.
> >>   - I want to fetch the data from doc2 on the basis of doc1 fields which
> >>   are related to doc2.
> >>
> >> How to achieve this efficiently.
> >>
> >>
> >> Thanks,
> >>
> >> Renuka Srishti
> >>
> >>
> >> On Mon, Aug 28, 2017 at 7:02 PM, Susheel Kumar <susheel2...@gmail.com>
> >> wrote:
> >>
> >>> Hello Renuka,
> >>>
> >>> I would suggest to start with your use case(s). May be start with your
> >>> first use case with the below questions
> >>>
> >>> a) What is that you want to search (which fields like name, desc, city
> >>> etc.)
> >>> b) What is that you want to show part of search result (name, city
> etc.)
> >>>
> >>> Based on above two questions, you would know what data to pull in from
> >>> relational database and create solr schema and index the data.
> >>>
> >>> You may first try to denormalize / flatten the structure so that you
> deal
> >>> with one collection/schema and query upon it.
> >>>
> >>> HTH.
> >>>
> >>> Thanks,
> >>> Susheel
> >>>
> >>> On Mon, Aug 28, 2017 at 8:04 AM, Renuka Srishti <
> >>> renuka.srisht...@gmail.com>
> >>> wrote:
> >>>
> >>>> Hii,
> >>>>
> >>>> What is the best way to index relational database, and how it impacts
> >> on
> >>>> the performance?
> >>>>
> >>>> Thanks
> >>>> Renuka Srishti
> >>>>
> >>>
> >>
>
>

Re: Index relational database

[Renuka Srishti]

Thanks Susheel for your response.
Here is the scenario about which I am talking:

   - Let suppose there are two documents doc1 and doc2.
   - I want to fetch the data from doc2 on the basis of doc1 fields which
   are related to doc2.

How to achieve this efficiently.


Thanks,

Renuka Srishti


On Mon, Aug 28, 2017 at 7:02 PM, Susheel Kumar <susheel2...@gmail.com>
wrote:

> Hello Renuka,
>
> I would suggest to start with your use case(s). May be start with your
> first use case with the below questions
>
> a) What is that you want to search (which fields like name, desc, city
> etc.)
> b) What is that you want to show part of search result (name, city etc.)
>
> Based on above two questions, you would know what data to pull in from
> relational database and create solr schema and index the data.
>
> You may first try to denormalize / flatten the structure so that you deal
> with one collection/schema and query upon it.
>
> HTH.
>
> Thanks,
> Susheel
>
> On Mon, Aug 28, 2017 at 8:04 AM, Renuka Srishti <
> renuka.srisht...@gmail.com>
> wrote:
>
> > Hii,
> >
> > What is the best way to index relational database, and how it impacts on
> > the performance?
> >
> > Thanks
> > Renuka Srishti
> >
>

Re: Indexed=false for a field,but still able to search on field.

[Renuka Srishti]

Hii,

I have tried two scanarios:

   1. I have tried   and docValues is not set anything.
   2. I have tried   and docValues is set true.

#1. You can not search directly that field, but when you apply search in
any other field of that doc, it will show you that field in the result.

  You can not do faceting on this field as well.

   If you will apply seach on this field in the Solr Admin Panel, no
result found. But you can see this field on doc there.

#2. Its searchable and can do faceting also.


Please correct me, if I am going wrong.


Thanks

Renuka Srishti



On Tue, Aug 29, 2017 at 1:06 AM, AshB <bishtashis...@gmail.com> wrote:

> Hi,
>
> Yes docValues is true for fieldType
>
>  docValues="true"/>
>
>
>
>
>
> --
> View this message in context: http://lucene.472066.n3.
> nabble.com/Indexed-false-for-a-field-but-still-able-to-search-on-field-
> tp4352338p4352442.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

Index relational database

[Renuka Srishti]

Hii,

What is the best way to index relational database, and how it impacts on
the performance?

Thanks
Renuka Srishti