datasource.ts 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446
  1. ///<reference path="../../../headers/common.d.ts" />
  2. import angular from 'angular';
  3. import _ from 'lodash';
  4. import moment from 'moment';
  5. import { ElasticQueryBuilder } from './query_builder';
  6. import { IndexPattern } from './index_pattern';
  7. import { ElasticResponse } from './elastic_response';
  8. export class ElasticDatasource {
  9. basicAuth: string;
  10. withCredentials: boolean;
  11. url: string;
  12. name: string;
  13. index: string;
  14. timeField: string;
  15. esVersion: number;
  16. interval: string;
  17. maxConcurrentShardRequests: number;
  18. queryBuilder: ElasticQueryBuilder;
  19. indexPattern: IndexPattern;
  20. /** @ngInject */
  21. constructor(
  22. instanceSettings,
  23. private $q,
  24. private backendSrv,
  25. private templateSrv,
  26. private timeSrv
  27. ) {
  28. this.basicAuth = instanceSettings.basicAuth;
  29. this.withCredentials = instanceSettings.withCredentials;
  30. this.url = instanceSettings.url;
  31. this.name = instanceSettings.name;
  32. this.index = instanceSettings.index;
  33. this.timeField = instanceSettings.jsonData.timeField;
  34. this.esVersion = instanceSettings.jsonData.esVersion;
  35. this.indexPattern = new IndexPattern(
  36. instanceSettings.index,
  37. instanceSettings.jsonData.interval
  38. );
  39. this.interval = instanceSettings.jsonData.timeInterval;
  40. this.maxConcurrentShardRequests =
  41. instanceSettings.jsonData.maxConcurrentShardRequests;
  42. this.queryBuilder = new ElasticQueryBuilder({
  43. timeField: this.timeField,
  44. esVersion: this.esVersion,
  45. });
  46. }
  47. private request(method, url, data?) {
  48. var options: any = {
  49. url: this.url + '/' + url,
  50. method: method,
  51. data: data,
  52. };
  53. if (this.basicAuth || this.withCredentials) {
  54. options.withCredentials = true;
  55. }
  56. if (this.basicAuth) {
  57. options.headers = {
  58. Authorization: this.basicAuth,
  59. };
  60. }
  61. return this.backendSrv.datasourceRequest(options);
  62. }
  63. private get(url) {
  64. var range = this.timeSrv.timeRange();
  65. var index_list = this.indexPattern.getIndexList(
  66. range.from.valueOf(),
  67. range.to.valueOf()
  68. );
  69. if (_.isArray(index_list) && index_list.length) {
  70. return this.request('GET', index_list[0] + url).then(function(results) {
  71. results.data.$$config = results.config;
  72. return results.data;
  73. });
  74. } else {
  75. return this.request(
  76. 'GET',
  77. this.indexPattern.getIndexForToday() + url
  78. ).then(function(results) {
  79. results.data.$$config = results.config;
  80. return results.data;
  81. });
  82. }
  83. }
  84. private post(url, data) {
  85. return this.request('POST', url, data)
  86. .then(function(results) {
  87. results.data.$$config = results.config;
  88. return results.data;
  89. })
  90. .catch(err => {
  91. if (err.data && err.data.error) {
  92. throw {
  93. message: 'Elasticsearch error: ' + err.data.error.reason,
  94. error: err.data.error,
  95. };
  96. }
  97. throw err;
  98. });
  99. }
  100. annotationQuery(options) {
  101. var annotation = options.annotation;
  102. var timeField = annotation.timeField || '@timestamp';
  103. var queryString = annotation.query || '*';
  104. var tagsField = annotation.tagsField || 'tags';
  105. var textField = annotation.textField || null;
  106. var range = {};
  107. range[timeField] = {
  108. from: options.range.from.valueOf(),
  109. to: options.range.to.valueOf(),
  110. format: 'epoch_millis',
  111. };
  112. var queryInterpolated = this.templateSrv.replace(queryString, {}, 'lucene');
  113. var query = {
  114. bool: {
  115. filter: [
  116. { range: range },
  117. {
  118. query_string: {
  119. query: queryInterpolated,
  120. },
  121. },
  122. ],
  123. },
  124. };
  125. var data = {
  126. query: query,
  127. size: 10000,
  128. };
  129. // fields field not supported on ES 5.x
  130. if (this.esVersion < 5) {
  131. data['fields'] = [timeField, '_source'];
  132. }
  133. var header: any = {
  134. search_type: 'query_then_fetch',
  135. ignore_unavailable: true,
  136. };
  137. // old elastic annotations had index specified on them
  138. if (annotation.index) {
  139. header.index = annotation.index;
  140. } else {
  141. header.index = this.indexPattern.getIndexList(
  142. options.range.from,
  143. options.range.to
  144. );
  145. }
  146. var payload = angular.toJson(header) + '\n' + angular.toJson(data) + '\n';
  147. return this.post('_msearch', payload).then(res => {
  148. var list = [];
  149. var hits = res.responses[0].hits.hits;
  150. var getFieldFromSource = function(source, fieldName) {
  151. if (!fieldName) {
  152. return;
  153. }
  154. var fieldNames = fieldName.split('.');
  155. var fieldValue = source;
  156. for (var i = 0; i < fieldNames.length; i++) {
  157. fieldValue = fieldValue[fieldNames[i]];
  158. if (!fieldValue) {
  159. console.log('could not find field in annotation: ', fieldName);
  160. return '';
  161. }
  162. }
  163. return fieldValue;
  164. };
  165. for (var i = 0; i < hits.length; i++) {
  166. var source = hits[i]._source;
  167. var time = source[timeField];
  168. if (typeof hits[i].fields !== 'undefined') {
  169. var fields = hits[i].fields;
  170. if (_.isString(fields[timeField]) || _.isNumber(fields[timeField])) {
  171. time = fields[timeField];
  172. }
  173. }
  174. var event = {
  175. annotation: annotation,
  176. time: moment.utc(time).valueOf(),
  177. text: getFieldFromSource(source, textField),
  178. tags: getFieldFromSource(source, tagsField),
  179. };
  180. // legacy support for title tield
  181. if (annotation.titleField) {
  182. const title = getFieldFromSource(source, annotation.titleField);
  183. if (title) {
  184. event.text = title + '\n' + event.text;
  185. }
  186. }
  187. if (typeof event.tags === 'string') {
  188. event.tags = event.tags.split(',');
  189. }
  190. list.push(event);
  191. }
  192. return list;
  193. });
  194. }
  195. testDatasource() {
  196. this.timeSrv.setTime({ from: 'now-1m', to: 'now' }, true);
  197. // validate that the index exist and has date field
  198. return this.getFields({ type: 'date' }).then(
  199. function(dateFields) {
  200. var timeField = _.find(dateFields, { text: this.timeField });
  201. if (!timeField) {
  202. return {
  203. status: 'error',
  204. message: 'No date field named ' + this.timeField + ' found',
  205. };
  206. }
  207. return { status: 'success', message: 'Index OK. Time field name OK.' };
  208. }.bind(this),
  209. function(err) {
  210. console.log(err);
  211. if (err.data && err.data.error) {
  212. var message = angular.toJson(err.data.error);
  213. if (err.data.error.reason) {
  214. message = err.data.error.reason;
  215. }
  216. return { status: 'error', message: message };
  217. } else {
  218. return { status: 'error', message: err.status };
  219. }
  220. }
  221. );
  222. }
  223. getQueryHeader(searchType, timeFrom, timeTo) {
  224. var query_header: any = {
  225. search_type: searchType,
  226. ignore_unavailable: true,
  227. index: this.indexPattern.getIndexList(timeFrom, timeTo),
  228. };
  229. if (this.esVersion >= 56) {
  230. query_header[
  231. 'max_concurrent_shard_requests'
  232. ] = this.maxConcurrentShardRequests;
  233. }
  234. return angular.toJson(query_header);
  235. }
  236. query(options) {
  237. var payload = '';
  238. var target;
  239. var sentTargets = [];
  240. // add global adhoc filters to timeFilter
  241. var adhocFilters = this.templateSrv.getAdhocFilters(this.name);
  242. for (var i = 0; i < options.targets.length; i++) {
  243. target = options.targets[i];
  244. if (target.hide) {
  245. continue;
  246. }
  247. var queryString = this.templateSrv.replace(
  248. target.query || '*',
  249. options.scopedVars,
  250. 'lucene'
  251. );
  252. var queryObj = this.queryBuilder.build(target, adhocFilters, queryString);
  253. var esQuery = angular.toJson(queryObj);
  254. var searchType =
  255. queryObj.size === 0 && this.esVersion < 5
  256. ? 'count'
  257. : 'query_then_fetch';
  258. var header = this.getQueryHeader(
  259. searchType,
  260. options.range.from,
  261. options.range.to
  262. );
  263. payload += header + '\n';
  264. payload += esQuery + '\n';
  265. sentTargets.push(target);
  266. }
  267. if (sentTargets.length === 0) {
  268. return this.$q.when([]);
  269. }
  270. payload = payload.replace(/\$timeFrom/g, options.range.from.valueOf());
  271. payload = payload.replace(/\$timeTo/g, options.range.to.valueOf());
  272. payload = this.templateSrv.replace(payload, options.scopedVars);
  273. return this.post('_msearch', payload).then(function(res) {
  274. return new ElasticResponse(sentTargets, res).getTimeSeries();
  275. });
  276. }
  277. getFields(query) {
  278. return this.get('/_mapping').then(function(result) {
  279. var typeMap = {
  280. float: 'number',
  281. double: 'number',
  282. integer: 'number',
  283. long: 'number',
  284. date: 'date',
  285. string: 'string',
  286. text: 'string',
  287. scaled_float: 'number',
  288. nested: 'nested',
  289. };
  290. function shouldAddField(obj, key, query) {
  291. if (key[0] === '_') {
  292. return false;
  293. }
  294. if (!query.type) {
  295. return true;
  296. }
  297. // equal query type filter, or via typemap translation
  298. return query.type === obj.type || query.type === typeMap[obj.type];
  299. }
  300. // Store subfield names: [system, process, cpu, total] -> system.process.cpu.total
  301. var fieldNameParts = [];
  302. var fields = {};
  303. function getFieldsRecursively(obj) {
  304. for (var key in obj) {
  305. var subObj = obj[key];
  306. // Check mapping field for nested fields
  307. if (_.isObject(subObj.properties)) {
  308. fieldNameParts.push(key);
  309. getFieldsRecursively(subObj.properties);
  310. }
  311. if (_.isObject(subObj.fields)) {
  312. fieldNameParts.push(key);
  313. getFieldsRecursively(subObj.fields);
  314. }
  315. if (_.isString(subObj.type)) {
  316. var fieldName = fieldNameParts.concat(key).join('.');
  317. // Hide meta-fields and check field type
  318. if (shouldAddField(subObj, key, query)) {
  319. fields[fieldName] = {
  320. text: fieldName,
  321. type: subObj.type,
  322. };
  323. }
  324. }
  325. }
  326. fieldNameParts.pop();
  327. }
  328. for (var indexName in result) {
  329. var index = result[indexName];
  330. if (index && index.mappings) {
  331. var mappings = index.mappings;
  332. for (var typeName in mappings) {
  333. var properties = mappings[typeName].properties;
  334. getFieldsRecursively(properties);
  335. }
  336. }
  337. }
  338. // transform to array
  339. return _.map(fields, function(value) {
  340. return value;
  341. });
  342. });
  343. }
  344. getTerms(queryDef) {
  345. var range = this.timeSrv.timeRange();
  346. var searchType = this.esVersion >= 5 ? 'query_then_fetch' : 'count';
  347. var header = this.getQueryHeader(searchType, range.from, range.to);
  348. var esQuery = angular.toJson(this.queryBuilder.getTermsQuery(queryDef));
  349. esQuery = esQuery.replace(/\$timeFrom/g, range.from.valueOf());
  350. esQuery = esQuery.replace(/\$timeTo/g, range.to.valueOf());
  351. esQuery = header + '\n' + esQuery + '\n';
  352. return this.post('_msearch?search_type=' + searchType, esQuery).then(
  353. function(res) {
  354. if (!res.responses[0].aggregations) {
  355. return [];
  356. }
  357. var buckets = res.responses[0].aggregations['1'].buckets;
  358. return _.map(buckets, function(bucket) {
  359. return {
  360. text: bucket.key_as_string || bucket.key,
  361. value: bucket.key,
  362. };
  363. });
  364. }
  365. );
  366. }
  367. metricFindQuery(query) {
  368. query = angular.fromJson(query);
  369. if (!query) {
  370. return this.$q.when([]);
  371. }
  372. if (query.find === 'fields') {
  373. query.field = this.templateSrv.replace(query.field, {}, 'lucene');
  374. return this.getFields(query);
  375. }
  376. if (query.find === 'terms') {
  377. query.query = this.templateSrv.replace(query.query || '*', {}, 'lucene');
  378. return this.getTerms(query);
  379. }
  380. }
  381. getTagKeys() {
  382. return this.getFields({});
  383. }
  384. getTagValues(options) {
  385. return this.getTerms({ field: options.key, query: '*' });
  386. }
  387. }