在Solr数据导入处理程序中定义嵌套实体(Defining nested entities in Solr Data Import Handler)

 让我先说一下，我已经完成了关于这个主题的所有事情，包括Solr文档和所有的SO问题。 
 
 我有一个Solr实例，使用JDBC驱动程序通过Data Import Hanlder从MSSQL中提取数据。 数据出来了，但它不像我预期的那样基于Solr DIH文档构建 
 
<document>
 <entity>
  <entity />
 </entity>
</document>
 
 我已经尝试了所有的属性，如rootEntity，flatten，使用CachedSqlProvider等。multiValued =“True”结果结束 
 
docs [
{
  recordId: '1234',
  name: 'whatever'
  subrows_col1: ['x','y','z']
  subrows_col2: ['a','b','c']
}
]
 
 当我在找 
 
docs [
{
  recordId: '1234',
  name: 'whatever'
  subrows: [{
     col1: 'x',
     col2: 'a'
 },
  {
     col1: 'y',
     col2: 'b'
 },
 {
     col1: 'z',
     col2: 'c'
 }]
} ]
 
 我已经看到了块连接的东西，但我很困惑它到底在哪里。 我补充说 
 
<add>
 <doc>
  <field />
  <doc>
   <field />
  </doc>
 <doc>
</add>
 
 到DIH requestHandler，但它什么也没做。 我将它添加到/ update requestHandler中，并且出现错误。 我不知道应该去哪里。 它只在查询过程中起作用，还是仅在通过/ update将数据推送到solr时才起作用？ 
 
 我在哪里定义文档的结构？ 我尝试了架构中的嵌套字段，DIH配置中的实体以及requestHandlers中的块连接内容。 没有任何工作。 
 
 显然我错过了一些东西。 

Let me preface by mentioning that I've been through everything I could find about this topic including the Solr docs and all of the SO questions.
 
I have a Solr instance that I've setup with a Data Import Hanlder to pull in data from MSSQL using the JDBC driver. The data comes in, but it isn't structured as I'd expect based on the Solr DIH documentation
 
<document>
 <entity>
  <entity />
 </entity>
</document>
 
I've tried all the attributes like rootEntity, flatten, using CachedSqlProvider, etc. With multiValued="True" The result ends up 
 
docs [
{
  recordId: '1234',
  name: 'whatever'
  subrows_col1: ['x','y','z']
  subrows_col2: ['a','b','c']
}
]
 
When I'm looking for
 
docs [
{
  recordId: '1234',
  name: 'whatever'
  subrows: [{
     col1: 'x',
     col2: 'a'
 },
  {
     col1: 'y',
     col2: 'b'
 },
 {
     col1: 'z',
     col2: 'c'
 }]
} ]
 
I've seen the block-join stuff, but I'm confused as to where it goes. I added 
 
<add>
 <doc>
  <field />
  <doc>
   <field />
  </doc>
 <doc>
</add>
 
to the DIH requestHandler, but it did nothing. I added it to the /update requestHandler and I got an error. I have no clue where that is supposed to go. Does it only work during a query or is it only for when you push data to solr via /update?
 
Where do I define the structure for the document? I tried nested fields in the schema, entities in the DIH config and the block-join stuff in the requestHandlers. nothing has worked yet.
 
Obviously I'm missing something. 

原文：https://stackoverflow.com/questions/24920305