Hello All,
I am trying to index data from SQL Server view to the SOLR using the DIH
with full-import command. The view has 750K rows and 427 columns. During the
first execution i indexed only the first 50 rows of the view, the data got
indexed in 10 min. But, when i executed the same scenario to index the
complete set of 750K rows, the execution continued for 2 days and
roll-backed, giving me the following error:
"Unable to execute the query: select * from....."
Following is my DIH configuration file,
<dataConfig>
<dataSource type="JdbcDataSource"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://server1\sql2012;databaseName=DBName" user="x"
password="x" />
<document name="Search" batchsize="1">
<entity name="Search" query="select top 500 * from view">
<field column="ID" name="Id" />
As suggested in some of the posts, i did try with batchsize="-1", but dint
work out. Please suggest is this the correct approach or any parameter needs
to be modified for tuning.
Thanks!
--
View this message in context:
http://lucene.472066.n3.nabble.com/SOLR-Unable-to-execute-query-error-DIH-tp4051028.html
Sent from the Solr - User mailing list archive at Nabble.com.
