data-import problem

[Radha Krishna Reddy]

Hi,

I am trying to comfigure solr on aws ubuntu instance.I have mysql on a
different server.so i created a ssh tunnel for mysql on port 3309.

Download the mysql jdbc driver and copied it to lib folder.

*I edited the example/solr/conf/solrconfig.xml*



  data-config.xml




*example/solr/conf/data-config.xml*


  
  

   

  


*started the server*

java -Djetty.port=80 -jar start.jar

*when i tried to import data.*

http:///solr/dataimport?command=fullimport

i* am getting the following response*



05data-config.xmlfullimportidleThis response format is experimental.  It is likely to
change in the future.



Can someone help me on this?Also where can i find the logs.

Thanks and Regards,
Radha Krishna.

prefix search

[Radha Krishna Reddy]

Hi,

when i indexed words like 'Joe Tom' and 'Terry'.When i do prefix query like
q=t*,i get both 'Joe Tom' and Terry' as the results.But i want the result
for the complete string that start with 'T'.means i want only 'Terry' as the
result.

Can i do this?

Thanks and Regards,
Radha Krishna.

index enum

[Radha Krishna Reddy]

Hi,

I have 2 issues.

1. I have an enum column in my sql table.i want to index that column.which
fieldtype should i specify in the schema.xml for enum?

2. Normally we can index one column in a table using the  column header as
entity name and the column data as value of the entity.Can i index 2 column
where one column will be the entity name and the other will be the value of
the entity in the data-config.xml?


Thanks and Regards,
Radhakrishna

Re: index enum

[Radha Krishna Reddy]

Hi Gora,

Thanks for the replay.

First question is clear.

Second,How can i index 2 column where one column will be the entity name
and the other will be the value of the entity in the data-config.xml? is it
possible to provide me some sample?

Thanks and Regards,
Radhakrishna Reddy.

On Wed, Nov 2, 2011 at 2:43 PM, Gora Mohanty  wrote:

> On Tue, Nov 1, 2011 at 11:07 PM, Radha Krishna Reddy
>  wrote:
> [...]
> > 1. I have an enum column in my sql table.i want to index that
> column.which
> > fieldtype should i specify in the schema.xml for enum?
>
> I presume that you are using the DataImportHandler for indexing.
>
> You will need to convert the enum value into an int (or, whatever is
> appropriate). This can be done in the SQL statement that fetches
> the data, or in a script processor in data-config.xml.
>
> > 2. Normally we can index one column in a table using the  column header
> as
> > entity name and the column data as value of the entity.Can i index 2
> column
> > where one column will be the entity name and the other will be the value
> of
> > the entity in the data-config.xml?
>
> Yes, you can.
>
> Regards,
> Gora
>

highlight issue

[Radha Krishna Reddy]

Hi,

I am indexing around 2000 names using solr. highlight flag is on while
querying.

For some name i am getting the search substring appened at the start.

Suppose my search query is "*Rak*".In my database i have "*Rakesh Chaturvedi
*" name.
I am getting "*RakRakesh Chaturvedi*" as the response.

Same the case with the following names.

Search "Dhar" -- highlight "DharDharmesh Darshan"
Search "Suda"-- highlight "SudaSudarshan Faakir"

Can someone help me?

I am using the following filters for index and query.


  




  
      
    


  


Thanks and Regards,
Radha Krishna Reddy.