Hello everyone,
I need to run the following query to import my index from a H2 database:
<entity name="StreetInfo" query="SELECT si.*, zi.inhabitants FROM
StreetInfo si left join (SELECT city, city_appendix,
max(inhabitants) as inhabitants FROM zipinfo group by
city, city_appendix) zi on zi.city = si.city and
zi.city_appendix = si.city_appendix where house_no = '';"></entity>
but if I start to full-import nothing happens. The last information from my log
file is the following:
[25.09.2015 20:06:24.418 INFO commitScheduler-11-thread-1
o.a.s.u.DirectUpdateHandler2.commit:548] start
commit{,optimize=false,openSearcher=false,waitSearcher=true,expungeDeletes=false,softCommit=false,prepareCommit=false}[25.09.2015
20:06:24.418 INFO commitScheduler-11-thread-1
o.a.s.u.DirectUpdateHandler2.commit:588] No uncommitted changes. Skipping
IW.commit.[25.09.2015 20:06:24.419 INFO commitScheduler-11-thread-1
o.a.s.u.DirectUpdateHandler2.commit:637] end_commit_flush
If I try to run the SQL into the H2 directly I'll receive the expected
results.The strange thing is that if I run the following query everything goes
right and my data will be indexed. But I'm confused why the first statement
fails and the second one succeed:
<entity name="StreetInfo" query="SELECT StreetInfo.*, ZipInfo.inhabitants
FROM StreetInfo left join ZipInfo on ZipInfo.zip = StreetInfo.zip and
ZipInfo.city = StreetInfo.city and ZipInfo.city_appendix =
StreetInfo.city_appendix where house_no = '';"></entity>
Have someone of you an Idea why the first statement fails?
Thanks for your help
