name=idSchemaFieldName/
field column=name name=nameSchemaFieldName/
field column=value name=valueSchemaFieldName /
/entity
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068447
/
/entity
*entity name=title query=SELECT id, title FROM title where
nameid=${name.id}
*field column=id name=titleid /
field column=title name=title /
/entity
/document
/dataConfig
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem
--
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.
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
.
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.
.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.
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
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
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
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
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 the Solr - User mailing list archive at Nabble.com.
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?
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
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
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
://lucene.472066.n3.nabble.com/data-import-problem-tp4068306p4068373.html
Sent from the Solr - User mailing list archive at Nabble.com.
AS titleid, title FROM
name/entity
/document
--
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.
On Jun 5, 2013, at 20:39 , Stavros Delisavas stav...@delisavas.de 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.
On 6 June 2013 00:09, Stavros Delisavas stav...@delisavas.de 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
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
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)
/
/entity
--
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.
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 anith...@gmail.com wrote:
This looks like a MySQL permissions problem and not a Solr problem.
Caused by: java.sql.SQLException: Access denied for user
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,
This is my data-config file:-
dataConfig
dataSource driver=com.mysql.jdbc.Driver url=jdbc:mysql://
172.16.37.160:3306/hpcms_db_new user=readonly password=readonly/
document
entity
name=package query=select concat('pckg', id) as id,pkg_name,updated_time
from hp_package_info;
/entity
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
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
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 anith...@gmail.com wrote:
This error is typically because of a
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, check
@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.
*I edited the example/solr/conf
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*
requestHandler name=/dataimport
in the entity : child
If anyone knows whether this is a known limitation (if 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
limitation (if 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
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.nabble.com/Data-import-problem
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-child-entity-from-different-database-tp26334948p26335171.html
Sent from the Solr - User mailing list archive at Nabble.com
://old.nabble.com/Data-import-problem-with-child-entity-from-different-database-tp26334948p26335171.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
-
Noble Paul | Principal Engineer| AOL | http://aol.com
--
Lance
36 matches
Mail list logo