Thats okay. For now, I guess it is okay. Finally I could import all 6.6
million entries successfully. I am happy.
Am 06.06.2013 19:44, schrieb Shawn Heisey:
On 6/6/2013 11:38 AM, Stavros Delisavas wrote:
Perfect! This finally worked! Shawn, thank you a lot!
How do I set up multiple cores?
cleaner and not a
CEO..1peterCEO>
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068677.html
Sent from the Solr - User mailing list archive at Nabble.com.
111developer222Officer333Cleaner 444IT
555Your document will look something like..but Peter is a cleaner and not a
CEO..1peterCEO>
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068677.html
Sent from
On 6/6/2013 11:38 AM, Stavros Delisavas wrote:
Perfect! This finally worked! Shawn, thank you a lot!
How do I set up multiple cores?
Again, thank you so much! I was looking for a solution for days!
Cores are defined in solr.xml - the default example core is named
collection1. I am strugglin
Perfect! This finally worked! Shawn, thank you a lot!
How do I set up multiple cores?
Again, thank you so much! I was looking for a solution for days!
Am 06.06.2013 19:23, schrieb Shawn Heisey:
On 6/6/2013 11:15 AM, Stavros Delisavas wrote:
Unfortunatly my two tables do not share a unique ke
On 6/6/2013 11:15 AM, Stavros Delisavas wrote:
Unfortunatly my two tables do not share a unique key. they both have
integers as keys starting with number 1. Is there any way to overcome
this problem? Removing the uniquekey-property from my schema.xml leads
to solr not working (I have tryed that a
ble data.
http://lucene.472066.n3.nabble.com/Create-index-on-few-unrelated-table-in-Solr-td4068054.html
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068650.html
Sent from the Solr - User mailing list archive at Nabble.com.
data.
http://lucene.472066.n3.nabble.com/Create-index-on-few-unrelated-table-in-Solr-td4068054.html
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068650.html
Sent from the Solr - User mailing list archive at Nabble.com.
When designing for Solr (or most search engines), think in terms of documents,
not tables.
What do your search results look like? You will want one document for each
search result. The document will have stored fields for each thing displayed
and indexed fields for each thing searched.
If you
something like this..
*
*
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068636.html
Sent from the Solr - User mailing list archive at Nabble.com.
table structure, I am assuming that there is a key
(ex: nameid in title table) that can be used to join name and title table.
Try something like this..
*
*
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-i
below query passing id as id instead of titleid..
A proper dataimport config will look like,
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-pr
,
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068447.html
Sent from the Solr - User mailing list archive at Nabble.com.
My usual admonishment is that Solr isn't a database, and when
you try to use it like one you're just _asking_ for problems. That
said
Consider two options:
1> use a different core for each table.
2> in schema.xml, remove the id field (required="true" _might_ be specified)
Thanks for the hints.
I am not sure how to solve this issue. I previously made a typo, there
are definetly two different tables.
Here is my real configuration:
http://pastebin.com/JUDzaMk0
For testing purposes I added "LIMIT 10" to the SQL-statements because my
tables are very huge and tests
On 6 June 2013 00:09, Stavros Delisavas wrote:
>
> Thanks so far.
>
> This change makes Solr work over the title-entries too, yay! Unfortunatly
> they don't get processed(skipped rows). In my log it says
> "missing required field id" for every entry.
>
> I checked my schema.xml. In there "id" is n
On Jun 5, 2013, at 20:39 , Stavros Delisavas wrote:
> Thanks so far.
>
> This change makes Solr work over the title-entries too, yay! Unfortunatly
> they don't get processed(skipped rows). In my log it says
> "missing required field id" for every entry.
>
> I checked my schema.xml. In there "id
.
removing the uniquekey-property also leads to no improvement.
Any further ideas?
Am 05.06.2013 18:01, schrieb sodoo:
Maybe problem is two document declare in data-config.xml.
You will try change this one.
--
View this message in context:
http://lucene.472066.n3.nabbl
Maybe problem is two document declare in data-config.xml.
You will try change this one.
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068306p4068373.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hello Solr-Friends,
I have a problem with my current solr configuration. I want to import
two tables into solr. I got it to work for the first table, but the
second table doesn't get imported (no errormessage, 0 rows skipped).
I have two tables called name and title and i want to load their fie
Hello Solr-Friends,
I have a problem with my current solr configuration. I want to import
two tables into solr. I got it to work for the first table, but the
second table doesn't get imported (no errormessage, 0 rows skipped).
I have two tables called name and title and i want to load their fie
Hello Solr-Friends,
I have a problem with my current solr configuration. I want to import
two tables into solr. I got it to work for the first table, but the
second table doesn't get imported (no errormessage, 0 rows skipped).
I have two tables called name and title and i want to load their fie
We're getting a little far afield...but here is the incantation:
mysql> grant all on DBNAME.* to 'USER'@'IP-ADDRESS' identified by
'PASSWORD';
mysql> flush privileges;
cheers,
Travis
On Tue, Oct 30, 2012 at 2:40 PM, Amit Nithian wrote:
> This error is typically because of a mysql permissions
This error is typically because of a mysql permissions problem. These
are usually resolved by a GRANT statement on your DB to allow for
users to connect remotely to your database server.
I don't know the full syntax but a quick search on Google should yield
what you are looking for. If you don't c
Like Amit said, this appears not to be a Solr problem. From the command
line of your machine, try this:
mysql -u'readonly' -p'readonly' -h'10.86.29.32' hpcms_db_new
If that works, and 10.86.29.32 is the server referenced by the URL in your
data-config.xml problem, then at least you know you have
Hi,
This is my data-config file:-
and password is not null. and 10.86.29.32 is my unix server ip.
regards,
kunal
On Tue, Oct 30, 2012 at 2:42 PM, Dave Stuart wrote:
> It looks as though you have a password set on your unix server. you will
> need to either remove this
It looks as though you have a password set on your unix server. you will need
to either remove this or ti add the password into the connection string
e.g. readonly:[yourpassword]@'10.86.29.32'
>> 'readonly'@'10.86.29.32'
>> (using password: NO)"
On 30 Oct 2012, at 09:08, kunal sachdeva wrote:
Hi,
I'm not getting this error while running in local machine. Please Help
Regards,
Kunal
On Tue, Oct 30, 2012 at 10:32 AM, Amit Nithian wrote:
> This looks like a MySQL permissions problem and not a Solr problem.
> "Caused by: java.sql.SQLException: Access denied for user
> 'readonly'@'10.86.
This looks like a MySQL permissions problem and not a Solr problem.
"Caused by: java.sql.SQLException: Access denied for user
'readonly'@'10.86.29.32'
(using password: NO)"
I'd advise reading your stack traces a bit more carefully. You should
check your permissions or if you don't own the DB, chec
: solr-user@lucene.apache.org
> Betreff: data-import problem
> 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.
&
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/da
n apply that later
>>>
>>
>> Yep, that was just a bit of a wild stab in the dark to see if it made any
>> difference.
>>
>> Thanks,
>>
>> Andrew.
>>
>> --
>> View this message in context:
>> http://old.nabble.com/Data-import-proble
chedSqlEntityProcessor first and then apply that later
>>
>
> Yep, that was just a bit of a wild stab in the dark to see if it made any
> difference.
>
> Thanks,
>
> Andrew.
>
> --
> View this message in context:
> http://old.nabble.com/Data-import-problem-with
ort.temp.xml dataimport.temp.xml
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> do w/o CachedSqlEntityProcessor first and then apply that later
>
Yep, that was just a bit of a wild stab in the dark to see if it made any
difference.
Thanks,
Andrew.
--
View this message in context:
http://old.n
so I can work round
> it), or an unexpected case (if so I'll file a bug report), please shout. I'm
> using 1.4.
>
> Yet again, many thanks :-)
>
> Andrew.
>
> --
> View this message in context:
> http://old.nabble.com/Data-import-problem-with-child-entity-from-different-database-tp26334948p26334948.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
-
Noble Paul | Principal Engineer| AOL | http://aol.com
w.
--
View this message in context:
http://old.nabble.com/Data-import-problem-with-child-entity-from-different-database-tp26334948p26334948.html
Sent from the Solr - User mailing list archive at Nabble.com.
36 matches
Mail list logo
