Re: DataImportHandler ignoring most rows

[erikea...@yahoo.com]

I switched to the ms driver an now all is well.  Must be an  
incompatibility with the JSQLConnect driver.

Sent from my iPhone

On Aug 18, 2009, at 11:47 PM, Noble Paul നോബിള്‍  नो 
ब्ळ्  wrote:

> this comment says that
>   7
>
> the query fetched only 7 rows. If possible open a tool and just run
> the same query and see how many rows are returned
>
> On Wed, Aug 19, 2009 at 3:46 AM, Erik Earle  
> wrote:
>> Using:
>> - apache-solr-1.3.0
>> - java 1.6
>> - tomcat 6
>> - sql server 2005 w/ JSQLConnect 4.0 driver
>>
>> I have a group table with 3007 rows.  I have confirmed the key is
>> unique with "select distinct id from group"  and it returns 3007.   
>> When i re-index using http://host:port/solr/dataimport?command=full-import 
>>   I only get 7 records indexed.  Any insight into what is going on  
>> would be really great.
>>
>> A partial response:
>>
>>1
>>7
>>0
>>
>>
>> I have other entities that index all the rows without issue.
>>
>> There are no errors in the logs.
>>
>> I am not using any Transformers (and most of my config is not  
>> changed from install)
>>
>> My schema.xml contains:
>>
>> key
>>
>> and field defs (not a full list of fields):
>>   > required="true" />
>>   > required="true" />
>>   
>>   > stored="true" />
>>   
>>   
>>
>> data-config.xml
>> 
>> 
>>
>>>driver="com.jnetdirect.jsql.JSQLDriver"
>>url="jdbc:JSQLConnect://se-eriearle-lt1/database=SocialSite2/ 
>> user=SocialSite2"
>>user="SocialSite2"
>>password="SocialSite2" />
>>
>>
>>
>>
>>
>>>query="select 'group.'+id as 'key', 'group' as 'class',  
>> name, handle, description, created, updated from group order by  
>> created asc">
>>
>>
>>>query="<...redacted...>">
>>
>>
>>
>> 
>>
>>
>>
>>
>
>
>
> -- 
> -
> Noble Paul | Principal Engineer| AOL | http://aol.com

Re: Solr Query help - sorting

[erikea...@yahoo.com]

Clever... but if more than one row adds up to the same value I may get the 
wrong order (like 50, 50 and 10, 90)

I need a max function but the one provided only compares against a constant. 

Sent from my iPhone

On Aug 24, 2009, at 6:15 PM, Koji Sekiguchi  wrote:

How about using sum() FunctionQuery, via:

http://localhost:8983/solr/select/?q=_val_%3A%22sum%28width%2Clength%29%22

Thanks,

Koji


Erik Earle wrote:
Suppose I have a database of rectangle attributes that I have indexed in Solr 
and I want to get the top 10 widest or longest rectangles from one query.


name  |  width  |  length
A |  100|  10
B |  10 |  90
C |  80 |  10
...


My indexed fields are:  name, width, length

Is there a way to query so that my data returns the order:  A, B, C


 
 




  

StreamingUpdateSolrServer commit?

[erikea...@yahoo.com]

When does  StreamingUpdateSolrServer commit?

I know there's a threshhold and thread pool as params but I don't see a commit 
timeout.   Do I have to manage this myself?