elastic_response.ts 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542
  1. import _ from 'lodash';
  2. import flatten from 'app/core/utils/flatten';
  3. import * as queryDef from './query_def';
  4. import TableModel from 'app/core/table_model';
  5. import { DataFrame, toDataFrame, FieldType, MutableDataFrame } from '@grafana/data';
  6. import { DataQueryResponse } from '@grafana/ui';
  7. import { ElasticsearchAggregation } from './types';
  8. export class ElasticResponse {
  9. constructor(private targets: any, private response: any) {
  10. this.targets = targets;
  11. this.response = response;
  12. }
  13. processMetrics(esAgg: any, target: any, seriesList: any, props: any) {
  14. let metric, y, i, newSeries, bucket, value;
  15. for (y = 0; y < target.metrics.length; y++) {
  16. metric = target.metrics[y];
  17. if (metric.hide) {
  18. continue;
  19. }
  20. switch (metric.type) {
  21. case 'count': {
  22. newSeries = { datapoints: [], metric: 'count', props: props };
  23. for (i = 0; i < esAgg.buckets.length; i++) {
  24. bucket = esAgg.buckets[i];
  25. value = bucket.doc_count;
  26. newSeries.datapoints.push([value, bucket.key]);
  27. }
  28. seriesList.push(newSeries);
  29. break;
  30. }
  31. case 'percentiles': {
  32. if (esAgg.buckets.length === 0) {
  33. break;
  34. }
  35. const firstBucket = esAgg.buckets[0];
  36. const percentiles = firstBucket[metric.id].values;
  37. for (const percentileName in percentiles) {
  38. newSeries = {
  39. datapoints: [],
  40. metric: 'p' + percentileName,
  41. props: props,
  42. field: metric.field,
  43. };
  44. for (i = 0; i < esAgg.buckets.length; i++) {
  45. bucket = esAgg.buckets[i];
  46. const values = bucket[metric.id].values;
  47. newSeries.datapoints.push([values[percentileName], bucket.key]);
  48. }
  49. seriesList.push(newSeries);
  50. }
  51. break;
  52. }
  53. case 'extended_stats': {
  54. for (const statName in metric.meta) {
  55. if (!metric.meta[statName]) {
  56. continue;
  57. }
  58. newSeries = {
  59. datapoints: [],
  60. metric: statName,
  61. props: props,
  62. field: metric.field,
  63. };
  64. for (i = 0; i < esAgg.buckets.length; i++) {
  65. bucket = esAgg.buckets[i];
  66. const stats = bucket[metric.id];
  67. // add stats that are in nested obj to top level obj
  68. stats.std_deviation_bounds_upper = stats.std_deviation_bounds.upper;
  69. stats.std_deviation_bounds_lower = stats.std_deviation_bounds.lower;
  70. newSeries.datapoints.push([stats[statName], bucket.key]);
  71. }
  72. seriesList.push(newSeries);
  73. }
  74. break;
  75. }
  76. default: {
  77. newSeries = {
  78. datapoints: [],
  79. metric: metric.type,
  80. field: metric.field,
  81. metricId: metric.id,
  82. props: props,
  83. };
  84. for (i = 0; i < esAgg.buckets.length; i++) {
  85. bucket = esAgg.buckets[i];
  86. value = bucket[metric.id];
  87. if (value !== undefined) {
  88. if (value.normalized_value) {
  89. newSeries.datapoints.push([value.normalized_value, bucket.key]);
  90. } else {
  91. newSeries.datapoints.push([value.value, bucket.key]);
  92. }
  93. }
  94. }
  95. seriesList.push(newSeries);
  96. break;
  97. }
  98. }
  99. }
  100. }
  101. processAggregationDocs(esAgg: any, aggDef: ElasticsearchAggregation, target: any, table: any, props: any) {
  102. // add columns
  103. if (table.columns.length === 0) {
  104. for (const propKey of _.keys(props)) {
  105. table.addColumn({ text: propKey, filterable: true });
  106. }
  107. table.addColumn({ text: aggDef.field, filterable: true });
  108. }
  109. // helper func to add values to value array
  110. const addMetricValue = (values: any[], metricName: string, value: any) => {
  111. table.addColumn({ text: metricName });
  112. values.push(value);
  113. };
  114. for (const bucket of esAgg.buckets) {
  115. const values = [];
  116. for (const propValues of _.values(props)) {
  117. values.push(propValues);
  118. }
  119. // add bucket key (value)
  120. values.push(bucket.key);
  121. for (const metric of target.metrics) {
  122. switch (metric.type) {
  123. case 'count': {
  124. addMetricValue(values, this.getMetricName(metric.type), bucket.doc_count);
  125. break;
  126. }
  127. case 'extended_stats': {
  128. for (const statName in metric.meta) {
  129. if (!metric.meta[statName]) {
  130. continue;
  131. }
  132. const stats = bucket[metric.id];
  133. // add stats that are in nested obj to top level obj
  134. stats.std_deviation_bounds_upper = stats.std_deviation_bounds.upper;
  135. stats.std_deviation_bounds_lower = stats.std_deviation_bounds.lower;
  136. addMetricValue(values, this.getMetricName(statName), stats[statName]);
  137. }
  138. break;
  139. }
  140. case 'percentiles': {
  141. const percentiles = bucket[metric.id].values;
  142. for (const percentileName in percentiles) {
  143. addMetricValue(values, `p${percentileName} ${metric.field}`, percentiles[percentileName]);
  144. }
  145. break;
  146. }
  147. default: {
  148. let metricName = this.getMetricName(metric.type);
  149. const otherMetrics = _.filter(target.metrics, { type: metric.type });
  150. // if more of the same metric type include field field name in property
  151. if (otherMetrics.length > 1) {
  152. metricName += ' ' + metric.field;
  153. }
  154. addMetricValue(values, metricName, bucket[metric.id].value);
  155. break;
  156. }
  157. }
  158. }
  159. table.rows.push(values);
  160. }
  161. }
  162. // This is quite complex
  163. // need to recurse down the nested buckets to build series
  164. processBuckets(aggs: any, target: any, seriesList: any, table: any, props: any, depth: any) {
  165. let bucket, aggDef: any, esAgg, aggId;
  166. const maxDepth = target.bucketAggs.length - 1;
  167. for (aggId in aggs) {
  168. aggDef = _.find(target.bucketAggs, { id: aggId });
  169. esAgg = aggs[aggId];
  170. if (!aggDef) {
  171. continue;
  172. }
  173. if (depth === maxDepth) {
  174. if (aggDef.type === 'date_histogram') {
  175. this.processMetrics(esAgg, target, seriesList, props);
  176. } else {
  177. this.processAggregationDocs(esAgg, aggDef, target, table, props);
  178. }
  179. } else {
  180. for (const nameIndex in esAgg.buckets) {
  181. bucket = esAgg.buckets[nameIndex];
  182. props = _.clone(props);
  183. if (bucket.key !== void 0) {
  184. props[aggDef.field] = bucket.key;
  185. } else {
  186. props['filter'] = nameIndex;
  187. }
  188. if (bucket.key_as_string) {
  189. props[aggDef.field] = bucket.key_as_string;
  190. }
  191. this.processBuckets(bucket, target, seriesList, table, props, depth + 1);
  192. }
  193. }
  194. }
  195. }
  196. private getMetricName(metric: any) {
  197. let metricDef: any = _.find(queryDef.metricAggTypes, { value: metric });
  198. if (!metricDef) {
  199. metricDef = _.find(queryDef.extendedStats, { value: metric });
  200. }
  201. return metricDef ? metricDef.text : metric;
  202. }
  203. private getSeriesName(series: any, target: any, metricTypeCount: any) {
  204. let metricName = this.getMetricName(series.metric);
  205. if (target.alias) {
  206. const regex = /\{\{([\s\S]+?)\}\}/g;
  207. return target.alias.replace(regex, (match: any, g1: any, g2: any) => {
  208. const group = g1 || g2;
  209. if (group.indexOf('term ') === 0) {
  210. return series.props[group.substring(5)];
  211. }
  212. if (series.props[group] !== void 0) {
  213. return series.props[group];
  214. }
  215. if (group === 'metric') {
  216. return metricName;
  217. }
  218. if (group === 'field') {
  219. return series.field || '';
  220. }
  221. return match;
  222. });
  223. }
  224. if (series.field && queryDef.isPipelineAgg(series.metric)) {
  225. if (series.metric && queryDef.isPipelineAggWithMultipleBucketPaths(series.metric)) {
  226. const agg: any = _.find(target.metrics, { id: series.metricId });
  227. if (agg && agg.settings.script) {
  228. metricName = agg.settings.script;
  229. for (const pv of agg.pipelineVariables) {
  230. const appliedAgg: any = _.find(target.metrics, { id: pv.pipelineAgg });
  231. if (appliedAgg) {
  232. metricName = metricName.replace('params.' + pv.name, queryDef.describeMetric(appliedAgg));
  233. }
  234. }
  235. } else {
  236. metricName = 'Unset';
  237. }
  238. } else {
  239. const appliedAgg: any = _.find(target.metrics, { id: series.field });
  240. if (appliedAgg) {
  241. metricName += ' ' + queryDef.describeMetric(appliedAgg);
  242. } else {
  243. metricName = 'Unset';
  244. }
  245. }
  246. } else if (series.field) {
  247. metricName += ' ' + series.field;
  248. }
  249. const propKeys = _.keys(series.props);
  250. if (propKeys.length === 0) {
  251. return metricName;
  252. }
  253. let name = '';
  254. for (const propName in series.props) {
  255. name += series.props[propName] + ' ';
  256. }
  257. if (metricTypeCount === 1) {
  258. return name.trim();
  259. }
  260. return name.trim() + ' ' + metricName;
  261. }
  262. nameSeries(seriesList: any, target: any) {
  263. const metricTypeCount = _.uniq(_.map(seriesList, 'metric')).length;
  264. for (let i = 0; i < seriesList.length; i++) {
  265. const series = seriesList[i];
  266. series.target = this.getSeriesName(series, target, metricTypeCount);
  267. }
  268. }
  269. processHits(hits: { total: { value: any }; hits: any[] }, seriesList: any[]) {
  270. const hitsTotal = typeof hits.total === 'number' ? hits.total : hits.total.value; // <- Works with Elasticsearch 7.0+
  271. const series: any = {
  272. target: 'docs',
  273. type: 'docs',
  274. datapoints: [],
  275. total: hitsTotal,
  276. filterable: true,
  277. };
  278. let propName, hit, doc: any, i;
  279. for (i = 0; i < hits.hits.length; i++) {
  280. hit = hits.hits[i];
  281. doc = {
  282. _id: hit._id,
  283. _type: hit._type,
  284. _index: hit._index,
  285. };
  286. if (hit._source) {
  287. for (propName in hit._source) {
  288. doc[propName] = hit._source[propName];
  289. }
  290. }
  291. for (propName in hit.fields) {
  292. doc[propName] = hit.fields[propName];
  293. }
  294. series.datapoints.push(doc);
  295. }
  296. seriesList.push(series);
  297. }
  298. trimDatapoints(aggregations: any, target: any) {
  299. const histogram: any = _.find(target.bucketAggs, { type: 'date_histogram' });
  300. const shouldDropFirstAndLast = histogram && histogram.settings && histogram.settings.trimEdges;
  301. if (shouldDropFirstAndLast) {
  302. const trim = histogram.settings.trimEdges;
  303. for (const prop in aggregations) {
  304. const points = aggregations[prop];
  305. if (points.datapoints.length > trim * 2) {
  306. points.datapoints = points.datapoints.slice(trim, points.datapoints.length - trim);
  307. }
  308. }
  309. }
  310. }
  311. getErrorFromElasticResponse(response: any, err: any) {
  312. const result: any = {};
  313. result.data = JSON.stringify(err, null, 4);
  314. if (err.root_cause && err.root_cause.length > 0 && err.root_cause[0].reason) {
  315. result.message = err.root_cause[0].reason;
  316. } else {
  317. result.message = err.reason || 'Unkown elastic error response';
  318. }
  319. if (response.$$config) {
  320. result.config = response.$$config;
  321. }
  322. return result;
  323. }
  324. getTimeSeries() {
  325. const seriesList = [];
  326. for (let i = 0; i < this.response.responses.length; i++) {
  327. const response = this.response.responses[i];
  328. if (response.error) {
  329. throw this.getErrorFromElasticResponse(this.response, response.error);
  330. }
  331. if (response.hits && response.hits.hits.length > 0) {
  332. this.processHits(response.hits, seriesList);
  333. }
  334. if (response.aggregations) {
  335. const aggregations = response.aggregations;
  336. const target = this.targets[i];
  337. const tmpSeriesList: any[] = [];
  338. const table = new TableModel();
  339. this.processBuckets(aggregations, target, tmpSeriesList, table, {}, 0);
  340. this.trimDatapoints(tmpSeriesList, target);
  341. this.nameSeries(tmpSeriesList, target);
  342. for (let y = 0; y < tmpSeriesList.length; y++) {
  343. seriesList.push(tmpSeriesList[y]);
  344. }
  345. if (table.rows.length > 0) {
  346. seriesList.push(table);
  347. }
  348. }
  349. }
  350. return { data: seriesList };
  351. }
  352. getLogs(logMessageField?: string, logLevelField?: string): DataQueryResponse {
  353. const dataFrame: DataFrame[] = [];
  354. const docs: any[] = [];
  355. for (let n = 0; n < this.response.responses.length; n++) {
  356. const response = this.response.responses[n];
  357. if (response.error) {
  358. throw this.getErrorFromElasticResponse(this.response, response.error);
  359. }
  360. const hits = response.hits;
  361. let propNames: string[] = [];
  362. let propName, hit, doc: any, i;
  363. for (i = 0; i < hits.hits.length; i++) {
  364. hit = hits.hits[i];
  365. const flattened = hit._source ? flatten(hit._source, null) : {};
  366. doc = {};
  367. doc[this.targets[0].timeField] = null;
  368. doc = {
  369. ...doc,
  370. _id: hit._id,
  371. _type: hit._type,
  372. _index: hit._index,
  373. ...flattened,
  374. };
  375. // Note: the order of for...in is arbitrary amd implementation dependant
  376. // and should probably not be relied upon.
  377. for (propName in hit.fields) {
  378. if (propNames.indexOf(propName) === -1) {
  379. propNames.push(propName);
  380. }
  381. doc[propName] = hit.fields[propName];
  382. }
  383. for (propName in doc) {
  384. if (propNames.indexOf(propName) === -1) {
  385. propNames.push(propName);
  386. }
  387. }
  388. doc._source = { ...flattened };
  389. docs.push(doc);
  390. }
  391. if (docs.length > 0) {
  392. propNames = propNames.sort();
  393. const series = new MutableDataFrame({ fields: [] });
  394. series.addField({
  395. name: this.targets[0].timeField,
  396. type: FieldType.time,
  397. }).parse = (v: any) => {
  398. return v[0] || '';
  399. };
  400. if (logMessageField) {
  401. series.addField({
  402. name: logMessageField,
  403. type: FieldType.string,
  404. }).parse = (v: any) => {
  405. return v || '';
  406. };
  407. } else {
  408. series.addField({
  409. name: '_source',
  410. type: FieldType.string,
  411. }).parse = (v: any) => {
  412. return JSON.stringify(v, null, 2);
  413. };
  414. }
  415. if (logLevelField) {
  416. series.addField({
  417. name: 'level',
  418. type: FieldType.string,
  419. }).parse = (v: any) => {
  420. return v || '';
  421. };
  422. }
  423. for (const propName of propNames) {
  424. if (propName === this.targets[0].timeField || propName === '_source') {
  425. continue;
  426. }
  427. series.addField({
  428. name: propName,
  429. type: FieldType.string,
  430. }).parse = (v: any) => {
  431. return v || '';
  432. };
  433. }
  434. // Add a row for each document
  435. for (const doc of docs) {
  436. series.add(doc);
  437. }
  438. dataFrame.push(series);
  439. }
  440. if (response.aggregations) {
  441. const aggregations = response.aggregations;
  442. const target = this.targets[n];
  443. const tmpSeriesList: any[] = [];
  444. const table = new TableModel();
  445. this.processBuckets(aggregations, target, tmpSeriesList, table, {}, 0);
  446. this.trimDatapoints(tmpSeriesList, target);
  447. this.nameSeries(tmpSeriesList, target);
  448. for (let y = 0; y < tmpSeriesList.length; y++) {
  449. const series = toDataFrame(tmpSeriesList[y]);
  450. series.labels = {};
  451. dataFrame.push(series);
  452. }
  453. }
  454. }
  455. return { data: dataFrame };
  456. }
  457. }