首页 > 其他 > 详细

kafka条件查询excel拼接

时间:2018-01-23 18:54:28      阅读:213      评论:0      收藏:0      [点我收藏+]
1
SELECT COUNT(*) FROM wiseweb_crawler_metasearch_page20171214 WHERE (content like %内蒙古%or    content like %呼和浩特%or    content like %赛罕区%or    content like %土默特左旗%or    content like %托克托县%or    content like %和林格尔县%or    content like %清水河县%or    content like %武川县%or    content like %包头%or    content like %昆都仑%or    content like %石拐区%or    content like %白云鄂博%or    content like %土默特右旗%or    content like %固阳县%or    content like %达尔罕茂明安联合旗%or    content like %乌海市%or    content like %海勃湾区%or    content like %乌达区%or    content like %赤峰%or    content like %阿鲁科尔沁旗%or    content like %巴林左旗%or    content like %巴林右旗%or    content like %林西县%or    content like %克什克腾旗%or    content like %翁牛特旗%or    content like %喀喇沁旗%or    content like %宁城县%or    content like %敖汉旗%or    content like %通辽%or    content like %科尔沁%or    content like %开鲁县%or    content like %库伦旗%or    content like %奈曼旗%or    content like %扎鲁特旗%or    content like %霍林郭勒%or    content like %鄂尔多斯%or    content like %东胜区%or    content like %康巴什区%or    content like %达拉特旗%or    content like %准格尔旗%or    content like %鄂托克前旗%or    content like %鄂托克旗%or    content like %杭锦旗%or    content like %乌审旗%or    content like %伊金霍洛旗%or    content like %呼伦贝尔%or    content like %海拉尔区%or    content like %扎赉诺尔区%or    content like %阿荣旗%or    content like %莫力达瓦%or    content like %鄂伦春自治旗%or    content like %鄂温克族自治旗%or    content like %陈巴尔虎旗%or    content like %新巴尔虎左旗%or    content like %新巴尔虎右旗%or    content like %满洲里%or    content like %牙克石市%or    content like %扎兰屯%or    content like %额尔古纳%or    content like %根河市%or    content like %巴彦淖尔%or    content like %五原县%or    content like %磴口县%or    content like %乌拉特前旗%or    content like %乌拉特中旗%or    content like %乌拉特后旗%or    content like %杭锦后旗%or    content like %乌兰察布%or    content like %卓资县%or    content like %化德县%or    content like %商都县%or    content like %兴和县%or    content like %凉城县%or    content like %察哈尔%or    content like %四子王旗%or    content like %丰镇市%or    content like %兴安盟%or    content like %乌兰浩特%or    content like %阿尔山%or    content like %扎赉特旗%or    content like %突泉县%or    content like %锡林郭勒盟%or    content like %二连浩特%or    content like %锡林浩特%or    content like %阿巴嘎旗%or    content like %苏尼特左旗%or    content like %苏尼特右旗%or    content like %东乌珠穆沁旗%or    content like %西乌珠穆沁旗%or    content like %太仆寺旗%or    content like %多伦县%or    content like %阿拉善盟%or    content like %阿拉善%or    content like %额济纳旗%or    content like %杨阿麟%or    content like %云宗元%or    content like %张建成%or    content like %白晓春%or    content like %胡越瑛%or    content like %高玺龙%or    content like %曲国民%or    content like %牛草宽%or    content like %农村信用社%)AND (gathertime BETWEEN 2018-01-23 00:00:01 AND 2018-01-23 23:59:59)

 

社%‘or
3	content like ‘%	内蒙古自治区农村信用合作社	%‘or	content like ‘%内蒙古自治区农村信用合作社%‘or
4	content like ‘%	内蒙古自治区信用社	%‘or	content like ‘%内蒙古自治区信用社%‘or
5	content like ‘%	内蒙古自治区农信社	%‘or	content like ‘%内蒙古自治区农信社%‘or
6	content like ‘%	内蒙古自治区信用联社	%‘or	content like ‘%内蒙古自治区信用联社%‘or
7	content like ‘%	内蒙古自治区农信联社	%‘or	content like ‘%内蒙古自治区农信联社%‘or
8	content like ‘%	内蒙古自治区农联社	%‘or	content like ‘%内蒙古自治区农联社%‘or
9	content like ‘%	内蒙古农村信用社联合社	%‘or	content like ‘%内蒙古农村信用社联合社%‘or
10	content like ‘%	内蒙古农村信用联社	%‘or	content like ‘%内蒙古农村信用联社%‘or
11	content like ‘%	内蒙古农村信用合作社	%‘or	content like ‘%内蒙古农村信用合作社%‘or
12	content like ‘%	内蒙古信用社	%‘or	content like ‘%内蒙古信用社%‘or
13	content like ‘%	内蒙古农信社	%‘or	content like ‘%内蒙古农信社%‘or
14	content like ‘%	内蒙古信用联社	%‘or	content like ‘%内蒙古信用联社%‘or
15	content like ‘%	内蒙古农信联社	%‘or	content like ‘%内蒙古农信联社%‘or
16	content like ‘%	内蒙古农联社	%‘or	content like ‘%内蒙古农联社%‘or
17	content like ‘%	海勃湾区	%‘or	content like ‘%海勃湾区%‘or
18	content like ‘%	乌达区	%‘or	content like ‘%乌达区%‘or
19	content like ‘%	赤峰	%‘or	content like ‘%赤峰%‘or
20	content like ‘%	阿鲁科尔沁旗	%‘or	content like ‘%阿鲁科尔沁旗%‘or
21	content like ‘%	巴林左旗	%‘or	content like ‘%巴林左旗%‘or
22	content like ‘%	巴林右旗	%‘or	content like ‘%巴林右旗%‘or
23	content like ‘%	林西县	%‘or	content like ‘%林西县%‘or
24	content like ‘%	克什克腾旗	%‘or	content like ‘%克什克腾旗%‘or
25	content like ‘%	翁牛特旗	%‘or	content like ‘%翁牛特旗%‘or
26	content like ‘%	喀喇沁旗	%‘or	content like ‘%喀喇沁旗%‘or
27	content like ‘%	宁城县	%‘or	content like ‘%宁城县%‘or
28	content like ‘%	敖汉旗	%‘or	content like ‘%敖汉旗%‘or
29	content like ‘%	通辽	%‘or	content like ‘%通辽%‘or
30	content like ‘%	科尔沁	%‘or	content like ‘%科尔沁%‘or
31	content like ‘%	开鲁县	%‘or	content like ‘%开鲁县%‘or
32	content like ‘%	库伦旗	%‘or	content like ‘%库伦旗%‘or
33	content like ‘%	奈曼旗	%‘or	content like ‘%奈曼旗%‘or
34	content like ‘%	扎鲁特旗	%‘or	content like ‘%扎鲁特旗%‘or

 

kafka条件查询excel拼接

原文:https://www.cnblogs.com/zhanglin123/p/8337136.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!