datasource.ts 12 KB

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