是这样的,我有两张桌子
businessmasters
Business_id Business_point
1 3.4
2 2.8
3 8.0
business_Colors
business_colors_id business_rating_from business_rating_to rating
1 2 5 OK
2 5 10 GOOD
3 10 15 Excellent我想将基于business_rating_from和business_rating_to的两个表链接起来,如下所示
SELECT business_colors_id,business_rating_from,business_rating_to,rating where
business_rating_from >= 2 AND business_rating_to < 5;现在,我想将它们索引到solr.This中,这是我的数据配置文件的样子
<entity name="business_colors" query="SELECT business_colors_id,
business_rating_from,business_rating_to,business_text,hex_colors,rgb_colors,business_colors_modify
from business_colors where business_rating_from >= '${businessmasters.business_point}' AND
business_rating_to < '${businessmasters.business_point}'"
deltaQuery="select business_colors_id from business_colors where business_colors_modify >
'${dih.last_index_time}'"
parentDeltaQuery="select business_id from businessmasters where business_point <
${business_colors.business_rating_from} AND business_point >=
${business_colors.business_rating_from}">
<field column="business_colors_id" name="id"/>
<field column="business_rating_from" name="business_rating_from" indexed="true" stored="true" />
<field column="business_rating_to" name="business_rating_to" indexed="true" stored="true" />
<field column="business_text" name="business_text" indexed="true" stored="true" />
<field column="hex_colors" name="hex_colors" indexed="true" stored="true" />
<field column="rgb_colors" name="rgb_colors" indexed="true" stored="true" />
<field column="business_colors_modify" name="business_colors_modify" indexed="true"
stored="true"/> 当我单击full indexing data时,不会得到索引,也不会显示任何错误。这有什么问题,任何人都可以提供帮助和建议。我如何实现我想要做的事情我所看到的是,如果我将fine.SO替换为OR,那么为什么OR可以使用AND而不使用and
发布于 2015-05-26 16:50:10
您的查询可能不会返回任何记录的事实就是这种情况。既然你提到了它
如果我将AND替换为OR,它可以工作,为什么OR可以工作,
fine.SO
不工作?
https://stackoverflow.com/questions/26256344
复制相似问题