嵌套实体的最大数量?

发布于 2024-12-09 17:34:00 字数 8753 浏览 1 评论 0原文

我在数据导入过程中遇到问题。我在 Tomcat 7 上使用 solr 3.3,并尝试从 MS SQL Server 2008 获取数据。 我已经完成了 DHI 的设置,没有任何问题,并且 DHI 已经可以工作了。 这是我用于导入的实体:

<entity name="hhh" query="Select
                tbl_hhh.ID,
  tbl_hhh.ID_breed,
  tbl_hhh.ID_Color,
  tbl_hhh.ID_sex,
  tbl_verkauf.VD,
  tbl_verkauf.Basisfornegation,
  tbl_verkauf.Price_Euros AS Price,
  tbl_verkauf.Buisiness,
  tbl_verkauf.LastEdit,
  tbl_verkauf.Date,
  tbl_hhh.Temperament,
  tbl_hhh.Age AS Age,
  tbl_hhh.Name,
  C_tbl_weight.weight_g,
  C_tbl_handshigh.handshigh_cm,
  tbl_hhh.ID_description,
  f1.Name As f1Name      ,
  m1.Name As m1Name     ,
  ff2.Name As ff2Name    ,
  fm2.Name As fm2Name    ,
  fff3.Name As fff3Name    ,
  FFM3.Name As FFM3Name    ,
  FMF3.Name As FMF3Name    ,
  FMM3.Name As FMM3Name    ,
  MF2.Name As MF2Name    ,
  MM2.Name As MM2Name    ,
  MFF3.Name As MFF3Name    ,
  MFM3.Name As MFM3Name    ,
  MMF3.Name As MMF3Name    ,
  MMM3.Name As MM3Name   
From
  tbl_verkauf Inner Join
  tbl_hhh On tbl_verkauf.ID_Hhh = tbl_hhh.ID Inner Join
  C_tbl_weight On tbl_hhh.ID_Weight = C_tbl_weight.ID Inner Join       

  C_tbl_handshigh On tbl_hhh.ID_handshigh = C_tbl_handshigh.ID 

  left outer Join  
  A_tbl_ancestry as f1 On tbl_hhh.ID_ancestry_F1 = f1.ID   
                     left outer Join  
  A_tbl_ancestry as m1 On tbl_hhh.ID_ancestry_M1 = m1.ID   
                       left outer Join  
  A_tbl_ancestry as ff2 On tbl_hhh.ID_ancestry_FF2 = ff2.ID 
                       left outer Join  
  A_tbl_ancestry as fm2 On tbl_hhh.ID_ancestry_FM2 = fm2.ID 
                       left outer Join  
  A_tbl_ancestry as fff3 On tbl_hhh.ID_ancestry_FFF3 = fff3.ID 
                       left outer Join  
  A_tbl_ancestry as FFM3 On tbl_hhh.ID_ancestry_FFM3 = FFM3.ID 
                       left outer Join  
  A_tbl_ancestry as FMF3 On tbl_hhh.ID_ancestry_FMF3 = FMF3.ID 
                       left outer Join  
  A_tbl_ancestry as FMM3 On tbl_hhh.ID_ancestry_FMM3 = FMM3.ID                      left outer Join  
  A_tbl_ancestry as MF2 On tbl_hhh.ID_ancestry_MF2 = MF2.ID                      left outer Join  
  A_tbl_ancestry as MM2 On tbl_hhh.ID_ancestry_MM2 = MM2.ID        left outer Join  
  A_tbl_ancestry as MFF3 On tbl_hhh.ID_ancestry_MFF3 = MFF3.ID left outer Join  
  A_tbl_ancestry as MFM3 On tbl_hhh.ID_ancestry_MFM3 = MFM3.ID left outer Join  
  A_tbl_ancestry as MMF3 On tbl_hhh.ID_ancestry_MMF3 = MMF3.ID 
  left outer Join  
  A_tbl_ancestry as MMM3 On tbl_hhh.ID_ancestry_MMM3 = MMM3.ID   
 ">
</entity>

现在我添加了一些子实体:

<entity name="hhh" query="Select
                tbl_hhh.ID,
  tbl_hhh.ID_breed,
  tbl_hhh.ID_Color,
  tbl_hhh.ID_sex,
  tbl_verkauf.VD,
  tbl_verkauf.Basisfornegation,
  tbl_verkauf.Price_Euros AS Price,
  tbl_verkauf.Buisiness,
  tbl_verkauf.LastEdit,
  tbl_verkauf.Date,
  tbl_hhh.Temperament,
  tbl_hhh.Age AS Age,
  tbl_hhh.Name,
  C_tbl_weight.weight_g,
  C_tbl_handshigh.handshigh_cm,
  tbl_hhh.ID_description,
  f1.Name As f1Name      ,
  m1.Name As m1Name     ,
  ff2.Name As ff2Name    ,
  fm2.Name As fm2Name    ,
  fff3.Name As fff3Name    ,
  FFM3.Name As FFM3Name    ,
  FMF3.Name As FMF3Name    ,
  FMM3.Name As FMM3Name    ,
  MF2.Name As MF2Name    ,
  MM2.Name As MM2Name    ,
  MFF3.Name As MFF3Name    ,
  MFM3.Name As MFM3Name    ,
  MMF3.Name As MMF3Name    ,
  MMM3.Name As MM3Name   
From
  tbl_verkauf Inner Join
  tbl_hhh On tbl_verkauf.ID_Hhh = tbl_hhh.ID Inner Join
  C_tbl_weight On tbl_hhh.ID_Weight = C_tbl_weight.ID Inner Join       

  C_tbl_handshigh On tbl_hhh.ID_handshigh = C_tbl_handshigh.ID 

  left outer Join  
  A_tbl_ancestry as f1 On tbl_hhh.ID_ancestry_F1 = f1.ID   
                     left outer Join  
  A_tbl_ancestry as m1 On tbl_hhh.ID_ancestry_M1 = m1.ID   
                       left outer Join  
  A_tbl_ancestry as ff2 On tbl_hhh.ID_ancestry_FF2 = ff2.ID 
                       left outer Join  
  A_tbl_ancestry as fm2 On tbl_hhh.ID_ancestry_FM2 = fm2.ID 
                       left outer Join  
  A_tbl_ancestry as fff3 On tbl_hhh.ID_ancestry_FFF3 = fff3.ID 
                       left outer Join  
  A_tbl_ancestry as FFM3 On tbl_hhh.ID_ancestry_FFM3 = FFM3.ID 
                       left outer Join  
  A_tbl_ancestry as FMF3 On tbl_hhh.ID_ancestry_FMF3 = FMF3.ID 
                       left outer Join  
  A_tbl_ancestry as FMM3 On tbl_hhh.ID_ancestry_FMM3 = FMM3.ID                      left outer Join  
  A_tbl_ancestry as MF2 On tbl_hhh.ID_ancestry_MF2 = MF2.ID                      left outer Join  
  A_tbl_ancestry as MM2 On tbl_hhh.ID_ancestry_MM2 = MM2.ID        left outer Join  
  A_tbl_ancestry as MFF3 On tbl_hhh.ID_ancestry_MFF3 = MFF3.ID left outer Join  
  A_tbl_ancestry as MFM3 On tbl_hhh.ID_ancestry_MFM3 = MFM3.ID left outer Join  
  A_tbl_ancestry as MMF3 On tbl_hhh.ID_ancestry_MMF3 = MMF3.ID 
  left outer Join  
  A_tbl_ancestry as MMM3 On tbl_hhh.ID_ancestry_MMM3 = MMM3.ID   
 ">

<entity name="Miscellaneous" processor="CachedSqlEntityProcessor" query="Select
               M_tbl_hhh_miscellaneous.ID_Miscellaneous
From
  M_tbl_hhh_miscellaneous
  where deleted = 'false' and  M_tbl_hhh_miscellaneous.ID_Hhh = '${hhh.ID}'

 ">
        <field column="ID_Miscellaneous" name="ID_Miscellaneous" />

      </entity>


      <entity name="Success_Dressage" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Dressage_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '3'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">


      </entity>

      <entity name="Success_Jumping" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Jumping_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '4'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">
      </entity>

      <entity name="Success_Eventing" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Eventing_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '5'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">
      </entity>

      <entity name="Success_Draghunting" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Draghunting_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '6'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">

</entity>
</entity>

前 3 个也可以工作,但从我添加第 4 个子实体开始,dhi 的调试窗口保持为空。无论我删除或添加哪个实体,第四个实体始终是问题所在。 我查看了日志,只有一条消息:

14.10.2011 13:39:33 org.apache.solr.handler.dataimport.DataImporter verifyWithSchema 信息:LastEdit 是 SolrSchema 中的必填字段。但在DataConfig中没有找到

子实体是否有限制?或者调试导入未运行的另一个原因?

多谢!!!

I’ve got a problem during the dataimport. I’m using solr 3.3 on a Tomcat 7 and I’m trying to get the data from a MS SQL Server 2008.
I’ve done the setup of the DHI without any problems and the DHI worked already.
This was the entity I used for the import:

<entity name="hhh" query="Select
                tbl_hhh.ID,
  tbl_hhh.ID_breed,
  tbl_hhh.ID_Color,
  tbl_hhh.ID_sex,
  tbl_verkauf.VD,
  tbl_verkauf.Basisfornegation,
  tbl_verkauf.Price_Euros AS Price,
  tbl_verkauf.Buisiness,
  tbl_verkauf.LastEdit,
  tbl_verkauf.Date,
  tbl_hhh.Temperament,
  tbl_hhh.Age AS Age,
  tbl_hhh.Name,
  C_tbl_weight.weight_g,
  C_tbl_handshigh.handshigh_cm,
  tbl_hhh.ID_description,
  f1.Name As f1Name      ,
  m1.Name As m1Name     ,
  ff2.Name As ff2Name    ,
  fm2.Name As fm2Name    ,
  fff3.Name As fff3Name    ,
  FFM3.Name As FFM3Name    ,
  FMF3.Name As FMF3Name    ,
  FMM3.Name As FMM3Name    ,
  MF2.Name As MF2Name    ,
  MM2.Name As MM2Name    ,
  MFF3.Name As MFF3Name    ,
  MFM3.Name As MFM3Name    ,
  MMF3.Name As MMF3Name    ,
  MMM3.Name As MM3Name   
From
  tbl_verkauf Inner Join
  tbl_hhh On tbl_verkauf.ID_Hhh = tbl_hhh.ID Inner Join
  C_tbl_weight On tbl_hhh.ID_Weight = C_tbl_weight.ID Inner Join       

  C_tbl_handshigh On tbl_hhh.ID_handshigh = C_tbl_handshigh.ID 

  left outer Join  
  A_tbl_ancestry as f1 On tbl_hhh.ID_ancestry_F1 = f1.ID   
                     left outer Join  
  A_tbl_ancestry as m1 On tbl_hhh.ID_ancestry_M1 = m1.ID   
                       left outer Join  
  A_tbl_ancestry as ff2 On tbl_hhh.ID_ancestry_FF2 = ff2.ID 
                       left outer Join  
  A_tbl_ancestry as fm2 On tbl_hhh.ID_ancestry_FM2 = fm2.ID 
                       left outer Join  
  A_tbl_ancestry as fff3 On tbl_hhh.ID_ancestry_FFF3 = fff3.ID 
                       left outer Join  
  A_tbl_ancestry as FFM3 On tbl_hhh.ID_ancestry_FFM3 = FFM3.ID 
                       left outer Join  
  A_tbl_ancestry as FMF3 On tbl_hhh.ID_ancestry_FMF3 = FMF3.ID 
                       left outer Join  
  A_tbl_ancestry as FMM3 On tbl_hhh.ID_ancestry_FMM3 = FMM3.ID                      left outer Join  
  A_tbl_ancestry as MF2 On tbl_hhh.ID_ancestry_MF2 = MF2.ID                      left outer Join  
  A_tbl_ancestry as MM2 On tbl_hhh.ID_ancestry_MM2 = MM2.ID        left outer Join  
  A_tbl_ancestry as MFF3 On tbl_hhh.ID_ancestry_MFF3 = MFF3.ID left outer Join  
  A_tbl_ancestry as MFM3 On tbl_hhh.ID_ancestry_MFM3 = MFM3.ID left outer Join  
  A_tbl_ancestry as MMF3 On tbl_hhh.ID_ancestry_MMF3 = MMF3.ID 
  left outer Join  
  A_tbl_ancestry as MMM3 On tbl_hhh.ID_ancestry_MMM3 = MMM3.ID   
 ">
</entity>

Now I’ve added some sub-entities:

<entity name="hhh" query="Select
                tbl_hhh.ID,
  tbl_hhh.ID_breed,
  tbl_hhh.ID_Color,
  tbl_hhh.ID_sex,
  tbl_verkauf.VD,
  tbl_verkauf.Basisfornegation,
  tbl_verkauf.Price_Euros AS Price,
  tbl_verkauf.Buisiness,
  tbl_verkauf.LastEdit,
  tbl_verkauf.Date,
  tbl_hhh.Temperament,
  tbl_hhh.Age AS Age,
  tbl_hhh.Name,
  C_tbl_weight.weight_g,
  C_tbl_handshigh.handshigh_cm,
  tbl_hhh.ID_description,
  f1.Name As f1Name      ,
  m1.Name As m1Name     ,
  ff2.Name As ff2Name    ,
  fm2.Name As fm2Name    ,
  fff3.Name As fff3Name    ,
  FFM3.Name As FFM3Name    ,
  FMF3.Name As FMF3Name    ,
  FMM3.Name As FMM3Name    ,
  MF2.Name As MF2Name    ,
  MM2.Name As MM2Name    ,
  MFF3.Name As MFF3Name    ,
  MFM3.Name As MFM3Name    ,
  MMF3.Name As MMF3Name    ,
  MMM3.Name As MM3Name   
From
  tbl_verkauf Inner Join
  tbl_hhh On tbl_verkauf.ID_Hhh = tbl_hhh.ID Inner Join
  C_tbl_weight On tbl_hhh.ID_Weight = C_tbl_weight.ID Inner Join       

  C_tbl_handshigh On tbl_hhh.ID_handshigh = C_tbl_handshigh.ID 

  left outer Join  
  A_tbl_ancestry as f1 On tbl_hhh.ID_ancestry_F1 = f1.ID   
                     left outer Join  
  A_tbl_ancestry as m1 On tbl_hhh.ID_ancestry_M1 = m1.ID   
                       left outer Join  
  A_tbl_ancestry as ff2 On tbl_hhh.ID_ancestry_FF2 = ff2.ID 
                       left outer Join  
  A_tbl_ancestry as fm2 On tbl_hhh.ID_ancestry_FM2 = fm2.ID 
                       left outer Join  
  A_tbl_ancestry as fff3 On tbl_hhh.ID_ancestry_FFF3 = fff3.ID 
                       left outer Join  
  A_tbl_ancestry as FFM3 On tbl_hhh.ID_ancestry_FFM3 = FFM3.ID 
                       left outer Join  
  A_tbl_ancestry as FMF3 On tbl_hhh.ID_ancestry_FMF3 = FMF3.ID 
                       left outer Join  
  A_tbl_ancestry as FMM3 On tbl_hhh.ID_ancestry_FMM3 = FMM3.ID                      left outer Join  
  A_tbl_ancestry as MF2 On tbl_hhh.ID_ancestry_MF2 = MF2.ID                      left outer Join  
  A_tbl_ancestry as MM2 On tbl_hhh.ID_ancestry_MM2 = MM2.ID        left outer Join  
  A_tbl_ancestry as MFF3 On tbl_hhh.ID_ancestry_MFF3 = MFF3.ID left outer Join  
  A_tbl_ancestry as MFM3 On tbl_hhh.ID_ancestry_MFM3 = MFM3.ID left outer Join  
  A_tbl_ancestry as MMF3 On tbl_hhh.ID_ancestry_MMF3 = MMF3.ID 
  left outer Join  
  A_tbl_ancestry as MMM3 On tbl_hhh.ID_ancestry_MMM3 = MMM3.ID   
 ">

<entity name="Miscellaneous" processor="CachedSqlEntityProcessor" query="Select
               M_tbl_hhh_miscellaneous.ID_Miscellaneous
From
  M_tbl_hhh_miscellaneous
  where deleted = 'false' and  M_tbl_hhh_miscellaneous.ID_Hhh = '${hhh.ID}'

 ">
        <field column="ID_Miscellaneous" name="ID_Miscellaneous" />

      </entity>


      <entity name="Success_Dressage" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Dressage_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '3'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">


      </entity>

      <entity name="Success_Jumping" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Jumping_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '4'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">
      </entity>

      <entity name="Success_Eventing" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Eventing_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '5'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">
      </entity>

      <entity name="Success_Draghunting" processor="CachedSqlEntityProcessor" query="Select
  L_tbl_cattegory_discipline_local.Name As Draghunting_success
From
  L_tbl_success Inner Join
  L_tbl_discipline On L_tbl_success.ID_discipline = L_tbl_discipline.ID
  Inner Join
  L_tbl_cattegory_discipline On L_tbl_discipline.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID Inner Join
  L_tbl_cattegory_discipline_local On
    L_tbl_cattegory_discipline_local.ID_cattegory_discipline =
    L_tbl_cattegory_discipline.ID
Where
  L_tbl_cattegory_discipline_local.ID_local = '2' And
  L_tbl_success.ID_Hhh = '${hhh.ID}' And
  L_tbl_success.deleted = 'false' And
  L_tbl_discipline.ID_cattegory = '6'
Group By
  L_tbl_cattegory_discipline_local.Name 

 ">

</entity>
</entity>

The first 3 also worked but from the time I added the 4th the debug-window of the dhi keep empty. It does not matter which of the entities I delete or add, the 4th one is always the problem.
I had a look into the log, there was only the message:

14.10.2011 13:39:33 org.apache.solr.handler.dataimport.DataImporter verifyWithSchema
INFO: LastEdit is a required field in SolrSchema . But not found in DataConfig

Is there a limit of sub-entities? Or another reason why the debug-import is not running?

Thanks a lot!!!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文