如何对solr中数据进行查询统计并得到全部查询统计结果

发布网友发布时间：2022-04-08 18:32

共2个回答

懂视网时间：2022-04-08 22:53

//查询
http://localhost/order/select?q=item_main_title:澳洲&wt=json&indent=true&fl=id,order_number,src,src_order


http://localhost/order/select?q=*:*&wt=json&indent=true&fq=order_date:[1441555200000 TO *]


SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd‘T‘HH:mm:ss‘Z‘");  
String time = "lostTime:["+sdf.format(new Date())+" TO "+sdf.format(new Date())+"]";

http://localhost/order/select?q=*:*&wt=json&indent=true&fq=channel_id:5 AND order_date:[1441555200000 TO 1441641599000] AND (order_status:E OR order_status:F OR order_status:G OR order_status:H)


http://localhost/wwwItem/select?q=*:*&wt=json&indent=true&fq=key_word:%E5%BD%93%E5%9C%B0%E7%BE%8E%E9%A3%9F&group=true&group.field=second_category_id&start=0&rows=10000&1445419659773

本文出自 “江山如画待赢归” 博客，谢绝转载！

Solr实现SQL的查询语句

标签：solr查询语句

热心网友时间：2022-04-08 20:01

如何对solr中数据进行查询统计并得到全部查询统计结果
条件组合查询
SQL查询语句：
SELECT log_id,start_time,end_time,prov_id,city_id,area_id,idt_id,cnt,net_type
FROM v_i_event
WHERE prov_id = 1 AND net_type = 1 AND area_id = 10304 AND time_type = 1 AND time_id >= 20130801 AND time_id <= 20130815
ORDER BY log_id LIMIT 10;