关于solr实现多表查询的方法

小陈家的血小板

已于 2022-05-11 15:21:06 修改

阅读量5k

点赞数

分类专栏： Java小技能文章标签：搜索引擎 solr 多表查询

于 2018-10-29 10:18:32 首次发布

本文链接：https://blog.csdn.net/admintys/article/details/83501910

版权

本文介绍了如何在Solr中实现多表查询，重点在于schema.xml的配置和使用copyField来处理关键字段，以避免主键冲突并实现查询功能。同时提供了java代码示例，适合开发者参考学习。

摘要由CSDN通过智能技术生成

关于solr实现多表查询的方法

话不多说上代码.
注意点一:防止主键唯一性的冲突,我选择将主键注释掉(也可以使用uuid代替主键id)
注意点二:实现多表查询的关键是 copyField 将需要分词的关键字段copy.即可实现多表查询/

下面为我的schema.xml 的配置文件

<?xml version="1.0" ?>
<!--
 Licensed to the Apache Software Foundation (ASF) under one or more
 contributor license agreements.  See the NOTICE file distributed with
 this work for additional information regarding copyright ownership.
 The ASF licenses this file to You under the Apache License, Version 2.0
 (the "License"); you may not use this file except in compliance with
 the License.  You may obtain a copy of the License at

     http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing, software
 distributed under the License is distributed on an "AS IS" BASIS,
 WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 See the License for the specific language governing permissions and
 limitations under the License.
-->

<schema name="example core zero" version="1.1">

    <fieldtype name="string"  class="solr.StrField" sortMissingLast="true" omitNorms="true"/>
    <fieldType name="long" class="solr.TrieLongField" precisionStep="0" positionIncrementGap="0"/>
    <fieldType name="date" class="solr.TrieDateField" precisionStep="0" positionIncrementGap="0"/>

    <fieldType name="text_general" class="solr.TextField">

        <analyzer type="index" class="org.wltea.analyzer.lucene.IKAnalyzer" />
        <analyzer type="query" class="org.wltea.analyzer.lucene.IKAnalyzer" />

    </fieldType>

  <!-- general -->
  <!--
  <field name="id"        type="string"   indexed="true"  stored="true"  multiValued="false" required="true"/>
  -->
  <field name="id"        type="string"   indexed="true"  stored="true"  multiValued="false" />
  <field name="type"      type="string"   indexed="true"  stored="true"  multiValued="false" /> 
  <field name="name"      type="text_general"   indexed="true"  stored="true"  multiValued="false" /> 
  <field name="core0"     type="string"   indexed="true"  stored="true"  multiValued="false"