java searchterm_Elasticsearch TermQuery 详解

官方文档地址

JavaClient 查询ES

QueryBuilder queryBuilder = QueryBuilders.termQuery("字段","term值");

SearchResponse response= client.prepareSearch("索引名称").setTypes("type名称").setSearchType(SearchType.DFS_QUERY_THEN_FETCH).setQuery(queryBuilder).execute().actionGet();//获取命中数

System.out.println(response.getHits().totalHits());//获取响应字符串

System.out.println(response.toString());//遍历查询结果输出相关度分值和文档内容

SearchHits searchHits =response.getHits();for(SearchHit searchHit : searchHits){

System.out.println(searchHit.getScore()); System.out.println(searchHit.getSourceAsString());

}

1、term query 分词精确查询

查询hotelName 分词后包含 hotel的term的文档

QueryBuilders.termQuery("hotelName","hotel")

2、terms Query 多term查询

查询hotelName 包含 hotel 或test 中的任何一个或多个的文档

QueryBuilders.termsQuery("hotelName","hotel","test")

3、range query范围查询

QueryBuilders.rangeQuery("hotelNo").gt("10143262306"); //大于 10143262306

QueryBuilders.rangeQuery("hotelNo").lt("101432623062055348221"); //小于 101432623062055348221

QueryBuilders.rangeQuery("hotelNo").includeLower(true);//包括下界

QueryBuilders.rangeQuery("hotelNo").includeUpper(false);//包括上界

4、 exist query 查询字段不为null的文档

查询字段address 不为null的数据

QueryBuilders.existsQuery("address")

5、missing query返回没有字段或值为null或没有值的文档

java client 该方法已经标记为过时,推荐用exist代替 如下

existsQuery BoolQueryBuilder#mustNot(QueryBuilder)

QueryBuilders.missingQuery("accountGuid") 等同 QueryBuilders.boolQuery().mustNot(QueryBuilders.existsQuery("accountGuid"));

6.prefix query 匹配分词前缀

如果字段没分词,就匹配整个字段前缀

QueryBuilders.prefixQuery("hotelName","花园")

7、wildcard query 通配符查询

支持* 任意字符串;?任意一个字符

QueryBuilders.wildcardQuery("channelCode","ctr*")

QueryBuilders.wildcardQuery("channelCode","ctr?")

8、regexp query 正则表达式匹配分词

正则表达式自己写吧 略

9、 fuzzy query 分词模糊查询

通过增加fuzziness 模糊属性,来查询term 如下 能够匹配 hotelName 为 te el tel前或后加一个字母的term的 文档 fuzziness 的含义是检索的term 前后增加或减少n个单词的匹配查询

QueryBuilders.fuzzyQuery("hotelName", "tel").fuzziness(Fuzziness.ONE)

10、type Query

英文原文:Filters documents matching the provided document / mapping type.

QueryBuilders.typeQuery("channelCode")

11、idx Query 根据ID查询

QueryBuilders.idsQuery().addIds("exchange_operate_monitor_db$32293","exchange_operate_monitor_db$32294")

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SELECT * FROM (with t1 as ( SELECT`year`,`week`, targeting ,customersearchterm from amazon_ods.ad_sp_searchterm_delta_wk assdw WHERE shop = 'happytools' --店铺筛选 AND campaignname in (SELECT campaignname from amazon_ods.ad_sp_advertised_delta_wk asadw WHERE asin in ('B09ZKF58VV','B09ZKBGNNN ')) --asin筛选 AND year = 2023 AND campaignname not in (SELECT campaignname from amazon_ods.jianlou_campaigns jc WHERE shop = 'happytools') --剔除捡漏 AND campaignname not LIKE 'JL%' AND campaignname NOT LIKE '捡漏%' and campaignname NOT LIKE '0.1%' AND campaignname NOT LIKE 'ALL%' AND customersearchterm not like 'b0%' ) SELECT t1.*,t2.impression_share,t2.impression_rank,t2.impressions, if(t2.impression_share = 0, null,round(toFloat64((t2.impressions))/toFloat64((t2.impression_share)),2)) as "市场总曝光(估算)" from t1 left join (SELECT `year` , `week` ,customer_searchterm as customersearchterm,impression_rank ,impression_share, targeting ,matchtype ,impressions ,clicks ,spend ,sales ,orders ,shop from amazon_ods.ad_sp_impression_share_delta_wk asisdw WHERE shop = 'happytools' AND `year` = 2023)as t2 on t1.customersearchterm = t2.customersearchterm AND t1.`year` = t2.`year` AND t1.`week` = t2.`week` ORDER BY `week` desc,`市场总曝光(估算)` desc) AS t2 LEFT JOIN (select `year` ,`week` ,searchterm as customersearchterm,search_frequency_rank , concat(cast((one_click_share +two_click_share +three_click_share ) as varchar(12)),'%') as "点击占比", concat(cast((one_conversion_share+two_conversion_share+three_conversion_share) as varchar(12)),'%') as "转化占比" ,one_clicked_asin,two_clicked_asin,three_clicked_asin from amazon_ods.aba_searchterm_ca_delta_wk ascdw and `year` =year(now()) and `week` >=week(now())-8 ) AS t3 WHERE t2.customersearchterm =t3.customersearchterm AND t2.`year` = t3.`year` AND t2.`week` = t3.`week`
06-08
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值