Paste P8373

ElasticSearch terms lookup queries
ActivePublic
Actions

Authored by Addshore on Apr 8 2019, 11:03 PM.

Tags

None

Referenced Files

	F28596429: raw.txt
	Apr 8 2019, 11:03 PM

Subscribers

None

	{ "terms": { "title.keyword" : [ "Q123", "Q124" ] } }


	time curl -X GET "https://search.svc.codfw.wmnet:9243/wikidatawiki_content_1537474902/_mget?_source=labels" -H 'Content-Type: application/json' -d'
	{"ids": [
	"2529806","2533557","2534508","29731","2553386","2559294","257508","2560669","2566092","2567140","2568968","2572477","2573593","2575550","2575556","259388","260135","260145","2588786","2595783","2595801","2595919","2596326","2596824","2596992","2598515","2600250","2600559","2601024","2601500","2602044","2602665","2603127","2603254","2603341","2604583","2604605","2604686","950878","953823","959056","959059","966617","973512","11565293","11569449","11576621","11578161","976686","105389","11585767","11585772","11587422","11589017","11593026","11598643","11599968","11600093","11603723","11618730","11618923","11619181","11620980","11621548","11627584","11627709","11633129","11634382","11640128","11640457","11642029","983364","11645865","11647267","11650958","11652942","11653104","11653734","11654421","11659842","11663025","985164","11664909","11665843","11668558","11671225","11674000","11676988","11686734","11688406","11689173","11689219","988336","11698003","11698104","11698491","11698765","988738","11704569","11714427","11716397","11722996","11730183","11740440","11749206","11756076","11756735","11756860","11757727","11759328","11759507","11763330","11776447","11782512","11798414","11802012","11803163","11809640","11811511","11814860","11815578","11816773","11817228","11817256","11818392","11821183","11831650","11835713","11840529","11847425","11850307","11851228","11853744","1005614","11859278","11864262","11867933","11868372","11869389","11872767","11873199","11873496","11873499","11874257","1007536","11876319","11877760","11879047","11880509","1008796","11887597","11890413","11892469","11893939","11894680","1009850","11901075","11902766","11905896","11906015","11907877","11910973","11913544","11913843","11915285","11915354","11916373","109010","11917911","11919847","11920028","11923681","11925699","11927044","1013262","11928102","11928428","11937062","11937456","11937693","1014536","11942021","11942643","11942663","11942762","11943023","11943178","11950589","11953138","11953193","11955600","11958990","11959918","11967351","11973582","11978884","11983636","1019661","11987185","11991534","11996799","11998859","12000131","12029368","1024070","12036089","12047048","12061348","12066456","12068419","12068726","12072423","12079440","1029013","12085828","12092738","1030262","12099542","12323","12327","1040219","1041309","1042324","12340094","1064804","1081271","1082497","1082796","116851","1089763","117482","118418","118491","118762","1109224","118853","12821138","12827065","1117420","1118385","120411","1125422","12978455","12980836","1130882","1134157","1134200","121364","13149158","1140610","1147773","13273108","1153264","1167692","13478163","1168302","1168595","1168994","125502","1182509","14089448","1221496","14287715","14351610","1240466","1241230","1241829","1242319","1243711","1243740","1244169","1244814","132447","1246215","1247325","14607010","14612533","1248401","1248552","132804","132828","1249891","1251722","133081","133251","1254050","1254313","133346","133413","1255970","1256782","133566","133651","1258777","1259113","1259174","1259358","133817","133926","14838468","134044","134047","1263267","1263282","134381","134435","134438","134498","1268586","1268603","134743","134877","135059","135110","135192","1274811","135290","1276553","135493","135526","135548","135556","135597","135606","1278597","1278740","135697","135750","1279879","135801","135927","135994","15108139","15108201","1282847","15112335","136204","15136088","136435","15166681","136973","137074","137291","15242692","15244765","137480","15256160","137560","137702","1301022","15273631","1301206","137955","1302228","1306768","138523","1307830","138685","138730","1309326","138783","138798","15382929","139052","139061","139207","15411638","139345","15421053","1321666","1322639","140139","1323653","15504352","140173","15506038","140192","15522529","140349","15559750","22908992","141002","141201","275","15690509","1343276","142226","15736611","142473","15754726","15754807","142629","142704","142904","142966","143059","15814476","143237","143342","15896174","143982","144147","144162","15929762","15957520","144563","144719","144788","144897","145081","145397","145652","16082615","1380766","16107405","146062","146209","16139988","16147340","16162791","1387590","16168346","16176169","16180722","16181501","16183044","16185869","16194922","1391055","16203673","16208816","147049","16215338","16228228","16230692","16234942","19590993","16237689","147476","16266075","147539","16266576","16275251","16281394","1399049","147699","16286233","1399806","16292936","16299640","16300082","16300975","16329205","16362214","16362915","148583","148634","148643","148939","16405994","16427971","1415983","149452","16486233","1420151","149859","149891","150197","16541134","16552494","16556113","150463","16562035","16565722","150549","16592878","16596520","16601355","16602661","16613725","150953","151001","16622978","1434652","151261","151371","151393","151411","151433","16708693","151890","152057","152119","1444298","16773519","16783001","16807717","16808158","16861804","16871144","153622","16912182","16929472","16938073","16945310","1469392","17049257","17055903","1477562","1480665","17087258","17095215","17104769","17817","1485175","17825","17171440","1492208","17258506","17273202","17280647","157633","157785","157787","17318694","17321428","17325494","157983","17346092","17346760","17346808","1508260","17366841","17367403","17371900","158438","158547","158549","17389505","158704","158820","159035","159055","159107","159223","159339","159386","1522753","17498452","159793","17554720","17554888","17554969","160311","17564292","17564543","17564861","17565218","17570909","17573346","1531351","17586234","17586363","17594401","17597147","160948","1536274","1542405","17696322","1544956","1546329","1546695","162170","162425","162518","162922","162966","17888497","163665","163702","1563864","163929","17952297","164687","164933","18138454","19239","165942","1586820","1589103","18177082","18207789","1593098","18249974","18330415","18342064","18434007","18489400","18523144","18537444","18551336","18567914","18587067","18588898","18597331","1641554","18726374","18729253","18759621","18795040","18872573","18872763","18873782","18875831","18877794","18877798","18877856","18877882","18880244","18880268","18882632","18882874","18883352","18883882","18884151","18895325","18898930","18899799","18912548","18945113","173628","18972404","18974319","18974340","18975867","18975869","18985537","1672031","18992889","1673727","19006595","19016635","174262","19053968","19077591","19107251","19110981","1687516","1687826","1688738","19150157","1688802","1689363","1690292","1690313","1690324","1690366","19172489","1690855","1691213","1693493","1694045","1694460","19226903","1695768","1696450","1698055","1698074","1698652","1699343","1699775","1700766","177663","19535243","19634211","19634306","19639883","19640948","1747881","19698877","19698920","1748534","19706766","1751022","1757320","1758970","1763326","19865449","19924668","19929057","183088","20055465","20055572","20055925","20056286","20056601","20058732","1787232","20115444","20116380","20116419","20118296","20118683","20119116","20124513","20126903","20128989","1790173","20138033","20139118","20140993","1796507","20204461","20205158","185778","1806963","1807649","1815219","1816768","22046","1826779","1841002","1844040","1850438","1851444","1855645","1856747","191114","1861966","1862062","1863667","1863815","1863925","1865559","1865812","1865890","1865923","1867596","1867860","1867884","1870132","1870641","1874397","1875272","1875526","1876031","1876463","21080899","1878590","1878946","1880873","1881712","1881715","1882969","1884238","1887950","1890006","1893351","1893441","21249027","21375273","21405409","1909780","21427904","1918255","21539951","21540005","196495","21594930","21602142","1929110","1931767","1940841","1942913","1943287","1944299","1947887","1947890","1958420","1958989","1959465","1959777","200012","1964184","200105","200106","1966879","1968752","1981162","1983621","1989861","1990357","1992405","1994935","1996042","203222","22468035","1999440","22497231","24121","2009239","2011730","22601311","2013304","2013337","2014196","22621324","22629723","2016146","205499","2022713","2023161","206159","23147165","2038617","24461","2044899","207622","23260717","23261922","23262103","23265561","23267280","23271915","23275070","23276482","23276805","23278639","23391355","23407103","23410517","23443086","23446098","23484848","23485632","23485761","23485778","23485873","23486234","23486550","23486842","23486924","23487139","23491682","23491812","2072666","23536853","23547228","23547656","23548065","23548068","23548070","23555540","2082231","2084214","211352","23743955","2096256","25056","212588","2108565","2109198","213485","2110907","2122405","24029867","214990","2130237","215842","215861","216137","216310","2141870","218032","2157771","2158085","2158406","2158452","2158863","14832626","25711","2171971","2176460","2176696","2177552","2183199","2190342","26094","24792510","2208246","2212246","24933957","24933962","24933963","2218339","2221331","25026960","25027014","2224583","25056871","25081742","25081747","2230537","2233325","2238998","2254657","2259601","2260655","2262206","2266564","2273272","2276531","2278265","2282366","2284571","2287245","2287405","2290635","2293098","25762003","25768405","2296787","2297766","2301636","231641","2302803","25836495","25838177","25889309","2310248","2312611","2316892","2316917","234455","2331421","2331602","26133997","2332846","2335165","26149997","2343716","2350506","2353014","2353705","2357761","2357960","237235","2369132","2372478","2373571","2380996","239664","2385750","2389224","240460","240646","2394868","2397789","2401766","241603","2405685","2408816","242578","2418260","2419886","2423220","2424734","2426427","2436490","245113","245401","2444101","2445436","27318903","27319146","27320757","246382","28805","2458884","248716","27614144","2476692","2478952","2479166","2480157","2486290","27745257","2488951","2489740","29253","2494418","27865916","2501812","2506357","2507717","2516202","2519450","2522371","2526016","29636","2529806","2533557","2534508","29731","2553386","2559294","257508","2560669","2566092","2567140","2568968","2572477","2573593","2575550","2575556","259388","260135","260145","2588786","2595783","2595801","2595919","2596326","2596824","2596992","2598515","2600250","2600559","2601024","2601500","2602044","2602665","2603127","2603254","2603341","2604583","2604605","2604686","2604732","2604934","2605384","2605546","2605712","2605723","2605829","2606375","2606785","2606792","2607016","2607067","2607396","2608581","2609412","2610435","2610985","2612314","2614053","2623615","2625314","2633378","266688","267477","31136","2675109","2676173","2676507","2685001","2687181","31483","2691672","271697","2694689","2703135","2703162","2703163","2703598","2711139","2711166","2712519","2715140","2717838","2719746","2722711","31814","275333","2730760","276510","2739599","276620","2744414","277230","2746288","2750193","277788","2752575","2757592","278689","2760004","278720","2763634","279217","2765771","2766581","32258","2770519","32298","2775213","2776770","280699","30712561","281008","281092","281841","281919","282011","282046","2791987","2792794","2792957","2792971","282310","282541","282547","282557","2806813","2815791","2818119","285266","2826972","2834971","286468","286729","2853983","2862412","2865255","2867221","2872816","2875635","2875716","2875875","2877320","2880402","2880898","2881216","2881360","31773480","2884487","2885927","2889496","2890431","2891545","2891673","33439","2912461","2919583","2920829","2920839","2926530","2936940","2939652","2945892","2953788","297763","298119","298334","298621","298693","298842","298988","299117","299144","299161","299209","299314","299369","299580","299662","2977186","299894","299967","300303","300332","300453","2997337","2999038","2999646","3001612","3006799","3012593","3021092","3027624","3029228","3030684","3033397","3033458","3039739","3042587","3051566","3054698","3056056","3057265","3058417","3085656","3086097","3089704","3093488","311315","3094229","3108431","34045781","3114115","3114885","3117823","3129076","3129366","3134584","3139648","3141554","3155878","3156578","3156675","3156908","3157048","3157338","3160303","3160315","3161730","3165820","3168196","3179818","3201880","3203132","3203996","3209836","3211084","322931","3226270","3232539","3232555","3233641","3235654","3235748","3235866","325774","3245982","3249151","3267663","3269437","328757","3274503","3275158","3279136","3292355","3292578","3297267","37398","3307472","3307531","3322792","3329033","3329143","3335109","3336129","3354755","338148","3374764","3374956","3382276","3385204","3398939","3404292","3424245","3432131","4514","3466161","3501999","351049","3518873","3521168","3524580","3524776","3525896","3527774","3529985","3531504","3531591","3532147","3541558","3542039","3545659","3545971","3547347","3547439","3552013","354686","3557188","3559567","3560021","3566312","3578391","3578498","3580520","3584306","3584531","3585257","3589000","3592299","3600197","359896","3609235","3610745","3626137","3628653","3632479","3645203","3651328","3654095","3663631","3663684","3663907","365692","3679222","367177","3684871","41288","3715178","3716622","3717409","371053","3727034","3727078","3727101","3736357","3743386","41719","3749790","3752193","3769993","3782372","3782373","3793276","3812655","3813903","3814527","3818967","3821784","3822424","3823057","3833974","3836246","3846251","3846462","3847681","3847699","3848429","3849708","3850812","3852563","3853160","3853670","3855914","3856946","3858385","3859391","3860824","3860880","3875271","18900923","3923231","3923460","3926721","3926784","3926835","3926930","3927023","3927078","3927300","3927732","3928052","3928861","3931798","3948910","3949231","3980576","3980585","3988082","3990152","3990425","3992779","4003539","4028700","4056102","4056630","4093715","4096933","4100878","4102360","4103005","405137","4110619","405949","4113329","4114455","4116328","4118249","4118272","4154695","4159080","4159329","4161631","4175924","4189596","4211915","4216331","4220028","4274041","46972","4283327","4285870","4287955","4309785","4321900","4338798","4339148","4360697","48222","48254","4425984","4428419","4440878","4444009","4450667","4465106","4466083","4466187","4467920","4468504","4473374","4473524","441898","441956","4484056","442956","4516353","4516807","445898","4524011","4528894","4531706","4536749","4537370","4553684","4557907","4559301","4562450","4562707","4567665","4568064","4574020","4576258","4578973","4592443","4596944","4596948","4597368","4601847","453663","4603587","4611799","4629249","4629548","4647480","4660171","4665177","461551","4694572","4699162","4700569","4707237","4719755","4720793","4727968","4763072","4763253","4770357","4774675","4775664","133","4780128","4793848","4794321","4795379","472181","4799671","4801209","4801423","4803565","4805249","4808323","4808853","4808948","4821940","4823214","4823853","4829405","4830839","4838308","4838631","4839056","4839099","4839481","4840655","4841821","478264","4875516","479729","4875652","4877084","479891","4877377","4883081","4893185","4897989","4898953","4909485","4909768","4909804","4912837","483823","483920","4920031","4921175","4921395","485179","4930441","4930891","4933678","4934159","4936230","4940612","486333","4944769","4953204","4954783","4956403","14365914","4957833","488009","4960994","4961182","4961356","4961368","4961390","6133","4965060","4966105","4969117","489111","4985302","4988813","4989564","4989962","4990348","4990441","4990981","4991634","4991720","4992301","4993988","4994331","4995431","4997050","4997436","4998426","5001617","5001925","5004122","5005559","5005590","5005816","5009661","5026538","5030667","5032016","5033961","495608","5036375","5041753","5041885","496690","5050620","5050829","5052478","5052725","5057951","5063051","5063072","498474","498862","5073100","5079568","5084223","5086503","501197","5125749","5126005","5127720","56134","505346","5138761","5142522","5142539","506538","5147114","5147761","5150445","5155264","5162712","5167846","5170064","5170182","5174022","5174222","5178645","510421","510942","510972","5206332","5208845","513508","5216657","5216799","5223593","515484","5240448","516545","57600","5270908","5278147","5279215","5279331","5288165","5288378","5292004","5295845","58203","5308905","5316094","5319277","5320526","5322831","524175","5331435","5332552","5333925","5338135","526568","5352889","5353147","5354390","5365918","5368224","5375908","5383140","5386339","5404457","5408143","5413185","5413190","5418483","5424093","5438665","5440196","5459658","5460883","5461232","5461351","5467995","5474208","5476170","5477302","539057","5514981","5537944","5538591","5545964","543281","544185","5560344","544774","5567098","5567168","546776","547449","548819","5608975","5614603","551123","5652514","5653184","5653638","5660753","554939","5676535","5677292","5680086","557042","5691516","559034","5719087","5729806","5732973","5734510","5737791","561274","5749861","5755324","62613","5762681","62689","564083","5783625","62989","567410","63098","63099","5836021","5845672","5847722","571537","571885","5864975","572371","5869615","572725","5874310","573014","5875810","5875858","573865","574115","5899113","5919418","5927278","5930228","5934091","5937854","5941306","579521","5948579","5964908","5976451","586249","6108321","592878","6119598","6182150","599981","6193319","6208924","604128","6243436","6245095","6255320","6260002","6261922","6265857","6267077","6279363","608733","609355","6299429","6300656","6306669","6307456","6312111","611847","6321460","6323899","612418","6331851","6345576","6347758","6347778","6347784","6348033","6348133","6352836","6354671","616007","6372280","616791","6375710","617729","6388460","6406030","620996","621356","623321","6495589","630708","6562706","6562712","6587077","6597376","6620775","6640954","6643231","6644373","6651349","6659575","6661793","6661860","642671","6681377","643553","644090","6691574","6691611","6691980","6692597","6693011","6696803","6703711","6715632","648978","649045","6754327","6755424","6766590","6769567","6769568","652909","6852553","6868646","6960489","6970895","6971491","6980418","6982243","6988992","6989635","6999893","6999932","7000012","7002717","7003803","7003911","7011583","7011599","7011729","7018153","7022584","7023061","7024592","7026961","7030756","7031494","7033026","673420","7065828","7069684","7072831","7081734","7095891","7096405","7102866","7102901","7103340","7107399","7107473","7107518","677424","678566","7128594","7128860","7128998","7129436","7130805","7132851","680841","7145671","7157620","7158448","7159312","7160472","7163522","7165803","7166747","7167187","683085","7176921","685426","7207474","7211599","7215397","7218823","7225702","7226025","7226812","7227273","7227493","7227497","7227770","7228102","688659","7237516","7237518","7265350","7265512","692615","7279072","8616","7305542","7315997","7319083","7326463","7336456","7341976","699360","7350757","7368821","7372282","7376053","704225","7411144","77733","7421368","7494896","7494945","7494997","7496613","7500503","7525982","7526224","7526558","7527907","7536399","7537568","7538534","7545592","7584687","7585280","7604059","7605900","7608546","7610635","7611406","7615849","723465","7631871","7631903","7632524","7632926","7632954","7635963","724837","725632","727681","730362","7713631","7717706","7729885","7730042","7730951","733429","7759293","7769898","7774945","7775255","7775586","7782654","7785698","7786320","739018","740090","7815426","7818310","7835481","7838030","7861546","7868124","7873614","7926015","7933882","7939853","82583","7954566","7989771","7990833","7991175","7992900","8015184","83177","8024165","8025625","762489","83511","764519","8315655","8138876","8140084","8155391","8162269","776746","8197093","8203540","8204431","8206168","8206187","8206983","8208031","8208032","8208488","85105","780039","784090","9612","85578","8305765","8305779","8311657","86011","792700","793285","793876","794243","794862","796052","8438691","8439225","799203","8452787","802386","8533212","810365","811605","818740","824856","8787439","828392","8798373","8798834","8877355","90936","843574","9019155","9020504","9020923","9020932","9021936","9061697","9061731","9062260","9063004","9064870","9065151","9065575","9071701","9072570","9072582","9081309","9085096","9087007","9092955","9094035","9097129","9098282","9099060","9101876","9102405","9120081","9124452","9125365","9126244","9127231","9131438","9131480","9133943","9136807","9142364","9142460","9142993","9150104","9152693","9155655","9157645","9166616","9166767","9166840","9167104","9167245","860771","862649","863455","864507","865346","867375","871366","872058","872745","878588","9400887","9401721","9402281","880320","882244","9439851","887632","888136","888479","889031","889797","890698","891332","891654","893351","893610","895395","899481","901984","903443","905276","905433","907419","909061","910006","9780952","911183","9838730","9898912","921387","922518","922883","923007","925678","926906","927196","935834"
	]}'




	time curl -X GET "https://search.svc.codfw.wmnet:9243/wikidatawiki_content_1537474902/_search?from=0&size=1000" -H 'Content-Type: application/json' -d'
	{ "_source":["labels.de","descriptions.de"],"query" : { "terms": { "title.keyword" : [ "Q123", "Q124" ] } } }'

Event Timeline

Addshore created this paste.Apr 8 2019, 11:03 PM

Addshore mentioned this in T220823: Use ElasticSearch for bulk Wikidata entity term lookup.Apr 12 2019, 1:51 PM