一个字段在solr中没有被索引

Question

我正在尝试使用sql查询DIH索引数据

在dataconfig.xml我把这个-

<entity
name="slot_data_sunday"
dataSource="dineout"
onError="skip"
query="SELECT 
tl_id AS event_id,
MAX(CASE
WHEN (dow = 0) THEN TRUE
ELSE FALSE
END) AS dow_0,
MAX(CASE
WHEN (dow = 1) THEN TRUE
ELSE FALSE
END) AS dow_1,
(CASE
WHEN (dow = 2) THEN TRUE
ELSE FALSE
END) AS dow_2,
MAX(CASE
WHEN (dow = 3) THEN TRUE
ELSE FALSE
END) AS dow_3,
MAX(CASE
WHEN (dow = 4) THEN TRUE
ELSE FALSE
END) AS dow_4,
(CASE
WHEN (dow = 5) THEN TRUE
ELSE FALSE
END) AS dow_5,
MAX(CASE
WHEN (dow = 6) THEN TRUE
ELSE FALSE
END) AS dow_6
FROM
ndf_ticket_slots"
cacheKey="event_id"
cacheLookup="ticket.event_id"
cacheImpl="SortedMapBackedCache" </entity>

在schema.xml中，我将

<field name="dow_0" type="boolean" indexed="true" stored="true"  />   
<field name="dow_1" type="boolean" indexed="true" stored="true"  />   
<field name="dow_2" type="boolean" indexed="true" stored="true"  />   
<field name="dow_3" type="boolean" indexed="true" stored="true"  />   
<field name="dow_4" type="boolean" indexed="true" stored="true"  />   
<field name="dow_5" type="boolean" indexed="true" stored="true"  />   
<field name="dow_6" type="boolean" indexed="true" stored="true"  />   

但是我没有得到这些字段在我的索引，谁能告诉我这里的问题

Answer 1

我发现每当我们在sql查询中使用任何聚合函数(如max/min)并在DIH中使用相同的查询进行索引时，它都不会被索引。所以尽量避免使用它。由于