spark.ko.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595
  1. // Licensed to Cloudera, Inc. under one
  2. // or more contributor license agreements. See the NOTICE file
  3. // distributed with this work for additional information
  4. // regarding copyright ownership. Cloudera, Inc. licenses this file
  5. // to you under the Apache License, Version 2.0 (the
  6. // "License"); you may not use this file except in compliance
  7. // with the License. You may obtain a copy of the License at
  8. //
  9. // http://www.apache.org/licenses/LICENSE-2.0
  10. //
  11. // Unless required by applicable law or agreed to in writing, software
  12. // distributed under the License is distributed on an "AS IS" BASIS,
  13. // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. // See the License for the specific language governing permissions and
  15. // limitations under the License.
  16. var Result = function (snippet, result) {
  17. var self = this;
  18. self.id = ko.observable(typeof result.id != "undefined" && result.id != null ? result.id : UUID());
  19. self.type = ko.observable(typeof result.type != "undefined" && result.type != null ? result.type : 'table');
  20. self.hasResultset = ko.observable(typeof result.hasResultset != "undefined" && result.hasResultset != null ? result.hasResultset : true);
  21. self.handle = ko.observable({});
  22. self.meta = ko.observableArray(typeof result.meta != "undefined" && result.meta != null ? result.meta : []);
  23. self.meta.extend({ rateLimit: 50 });
  24. self.cleanedMeta = ko.computed(function(){
  25. return ko.utils.arrayFilter(self.meta(), function(item) {
  26. return item.name != ''
  27. });
  28. });
  29. function isNumericColumn(type) {
  30. return $.inArray(type, ['TINYINT_TYPE', 'SMALLINT_TYPE', 'INT_TYPE', 'BIGINT_TYPE', 'FLOAT_TYPE', 'DOUBLE_TYPE', 'DECIMAL_TYPE', 'TIMESTAMP_TYPE', 'DATE_TYPE']) > -1;
  31. }
  32. function isDateTimeColumn(type) {
  33. return $.inArray(type, ['TIMESTAMP_TYPE', 'DATE_TYPE']) > -1;
  34. }
  35. function isStringColumn(type) {
  36. return !isNumericColumn(type) && !isDateTimeColumn(type);
  37. }
  38. self.cleanedNumericMeta = ko.computed(function(){
  39. return ko.utils.arrayFilter(self.meta(), function(item) {
  40. return item.name != '' && isNumericColumn(item.type)
  41. });
  42. });
  43. self.cleanedStringMeta = ko.computed(function(){
  44. return ko.utils.arrayFilter(self.meta(), function(item) {
  45. return item.name != '' && isStringColumn(item.type)
  46. });
  47. });
  48. self.cleanedDateTimeMeta = ko.computed(function(){
  49. return ko.utils.arrayFilter(self.meta(), function(item) {
  50. return item.name != '' && isDateTimeColumn(item.type)
  51. });
  52. });
  53. self.data = ko.observableArray(typeof result.data != "undefined" && result.data != null ? result.data : []);
  54. self.data.extend({ rateLimit: 50 });
  55. self.logs = ko.observable('');
  56. self.errors = ko.observable('');
  57. self.hasSomeResults = ko.computed(function(){
  58. return self.hasResultset() && self.data().length > 0; // status() == 'available'
  59. });
  60. if (typeof result.handle != "undefined" && result.handle != null) {
  61. $.each(result.handle, function(key, val) {
  62. self.handle()[key] = val;
  63. });
  64. }
  65. self.clear = function() {
  66. $.each(self.handle, function(key, val) {
  67. delete self.handle()[key];
  68. });
  69. self.meta.removeAll();
  70. self.data.removeAll();
  71. self.logs('');
  72. self.errors('');
  73. };
  74. }
  75. var TYPE_EDITOR_MAP = {
  76. 'hive': 'text/x-hiveql',
  77. 'impala': 'text/x-impalaql',
  78. 'python': 'text/x-python',
  79. 'scala': 'text/x-scala',
  80. 'pig': 'text/x-pig'
  81. }
  82. var Snippet = function (notebook, snippet) {
  83. var self = this;
  84. self.id = ko.observable(typeof snippet.id != "undefined" && snippet.id != null ? snippet.id : UUID());
  85. self.name = ko.observable(typeof snippet.name != "undefined" && snippet.name != null ? snippet.name : '');
  86. self.type = ko.observable(typeof snippet.type != "undefined" && snippet.type != null ? snippet.type : "hive");
  87. self.editorMode = ko.observable(TYPE_EDITOR_MAP[self.type()]);
  88. self.statement_raw = ko.observable(typeof snippet.statement_raw != "undefined" && snippet.statement_raw != null ? snippet.statement_raw : '');
  89. //self.statement_raw.extend({ rateLimit: 150 });
  90. self.status = ko.observable(typeof snippet.status != "undefined" && snippet.status != null ? snippet.status : 'loading');
  91. self.settings = ko.mapping.fromJS(typeof snippet.settings != "undefined" && snippet.settings != null ? snippet.settings : {});
  92. self.variables = ko.observableArray([]);
  93. self.variableNames = ko.computed(function () {
  94. var matches = [];
  95. var myRegexp = /(?:[^\\]\$)([^\d'" ]\w*)/g;
  96. var match = myRegexp.exec(self.statement_raw());
  97. while (match != null) {
  98. matches.push(match[1]);
  99. match = myRegexp.exec(self.statement());
  100. }
  101. return matches;
  102. });
  103. self.variableNames.extend({ rateLimit: 150 });
  104. self.variableNames.subscribe(function (newVal) {
  105. var toDelete = [];
  106. var toAdd = [];
  107. $.each(newVal, function (key, name) {
  108. var match = ko.utils.arrayFirst(self.variables(), function (_var) {
  109. return _var.name() == name;
  110. });
  111. if (!match) {
  112. toAdd.push(name);
  113. }
  114. });
  115. $.each(self.variables(), function (key, _var) {
  116. var match = ko.utils.arrayFirst(newVal, function (name) {
  117. return _var.name() == name;
  118. });
  119. if (!match) {
  120. toDelete.push(_var);
  121. }
  122. });
  123. $.each(toDelete, function (index, item) {
  124. self.variables.remove(item);
  125. });
  126. $.each(toAdd, function (index, item) {
  127. self.variables.push(ko.mapping.fromJS({'name': item, 'value': ''}));
  128. });
  129. self.variables.sort(function (left, right) {
  130. var leftIndex = newVal.indexOf(left.name());
  131. var rightIndex = newVal.indexOf(right.name());
  132. return leftIndex == rightIndex ? 0 : (leftIndex < rightIndex ? -1 : 1);
  133. });
  134. });
  135. self.statement = ko.computed(function () {
  136. var statement = self.statement_raw();
  137. $.each(self.variables(), function (index, variable) {
  138. statement = statement.replace(RegExp("([^\\\\])\\$" + variable.name(), "g"), "$1" + variable.value());
  139. });
  140. return statement;
  141. });
  142. self.result = new Result(snippet, snippet.result);
  143. self.showGrid = ko.observable(typeof snippet.showGrid != "undefined" && snippet.showGrid != null ? snippet.showGrid : true);
  144. self.showChart = ko.observable(typeof snippet.showChart != "undefined" && snippet.showChart != null ? snippet.showChart : false);
  145. self.showLogs = ko.observable(typeof snippet.showLogs != "undefined" && snippet.showLogs != null ? snippet.showLogs : false);
  146. self.progress = ko.observable(typeof snippet.progress != "undefined" && snippet.progress != null ? snippet.progress : 0);
  147. self.progress.subscribe(function (val){
  148. $(document).trigger("progress", {data: val, snippet: self});
  149. });
  150. self.showGrid.subscribe(function (val){
  151. if (val){
  152. self.showChart(false);
  153. }
  154. });
  155. self.showChart.subscribe(function (val){
  156. if (val){
  157. self.showGrid(false);
  158. self.isLeftPanelVisible(true);
  159. $(document).trigger("forceChartDraw", self);
  160. }
  161. });
  162. self.showLogs.subscribe(function (val){
  163. if (val){
  164. self.getLogs();
  165. }
  166. });
  167. self.size = ko.observable(typeof snippet.size != "undefined" && snippet.size != null ? snippet.size : 12).extend({ numeric: 0 });
  168. self.offset = ko.observable(typeof snippet.offset != "undefined" && snippet.offset != null ? snippet.offset : 0).extend({ numeric: 0 });
  169. self.isLoading = ko.computed(function(){
  170. return self.status() == "loading";
  171. });
  172. self.klass = ko.computed(function () {
  173. return "snippet card card-widget";
  174. });
  175. self.editorKlass = ko.computed(function(){
  176. return "editor span" + self.size() + (self.offset() * 1 > 0 ? " offset" + self.offset() : "");
  177. });
  178. self.resultsKlass = ko.computed(function(){
  179. return "results " + self.type();
  180. });
  181. self.chartType = ko.observable(typeof snippet.chartType != "undefined" && snippet.chartType != null ? snippet.chartType : ko.HUE_CHARTS.TYPES.BARCHART);
  182. self.chartSorting = ko.observable(typeof snippet.chartSorting != "undefined" && snippet.chartSorting != null ? snippet.chartSorting : "none");
  183. self.chartScatterGroup = ko.observable(typeof snippet.chartScatterGroup != "undefined" && snippet.chartScatterGroup != null ? snippet.chartScatterGroup : null);
  184. self.chartScatterSize = ko.observable(typeof snippet.chartScatterSize != "undefined" && snippet.chartScatterSize != null ? snippet.chartScatterSize : null);
  185. self.chartX = ko.observable(typeof snippet.chartX != "undefined" && snippet.chartX != null ? snippet.chartX : null);
  186. self.chartYSingle = ko.observable(typeof snippet.chartYSingle != "undefined" && snippet.chartYSingle != null ? snippet.chartYSingle : null);
  187. self.chartYMulti = ko.observableArray(typeof snippet.chartYMulti != "undefined" && snippet.chartYMulti != null ? snippet.chartYMulti : []);
  188. self.chartData = ko.observableArray(typeof snippet.chartData != "undefined" && snippet.chartData != null ? snippet.chartData : []);
  189. self.chartMapLabel = ko.observable(typeof snippet.chartMapLabel != "undefined" && snippet.chartMapLabel != null ? snippet.chartMapLabel : null);
  190. self.chartType.subscribe(function(val){
  191. $(document).trigger("forceChartDraw", self);
  192. });
  193. self.tempChartOptions = {};
  194. self.isLeftPanelVisible = ko.observable(typeof snippet.isLeftPanelVisible != "undefined" && snippet.isLeftPanelVisible != null ? snippet.isLeftPanelVisible : false);
  195. self.toggleLeftPanel = function () {
  196. self.isLeftPanelVisible(! self.isLeftPanelVisible());
  197. $(document).trigger("toggleLeftPanel", self);
  198. };
  199. self.expand = function () {
  200. self.size(self.size() + 1);
  201. $("#snippet_" + self.id()).trigger("resize");
  202. }
  203. self.compress = function () {
  204. self.size(self.size() - 1);
  205. $("#snippet_" + self.id()).trigger("resize");
  206. }
  207. self.moveLeft = function () {
  208. self.offset(self.offset() - 1);
  209. }
  210. self.moveRight = function () {
  211. self.offset(self.offset() + 1);
  212. }
  213. self.remove = function (notebook, snippet) {
  214. notebook.snippets.remove(snippet);
  215. }
  216. self.checkStatusTimeout = null;
  217. self._ajax_error = function(data) {
  218. if (data.status == -2) {
  219. self.create_session();
  220. }
  221. else if (data.status == -3) {
  222. self.status('expired');
  223. }
  224. else if (data.status == 1) {
  225. self.status('failed');
  226. self.result.errors(data.message);
  227. } else {
  228. $(document).trigger("error", data.message);
  229. self.status('failed');
  230. }
  231. };
  232. self.create_session = function() {
  233. $.post("/spark/api/create_session", {
  234. notebook: ko.mapping.toJSON(notebook),
  235. snippet: ko.mapping.toJSON(self)
  236. }, function (data) {
  237. if (data.status == 0) {
  238. notebook.addSession(ko.mapping.fromJS(data.session));
  239. self.status('ready');
  240. }
  241. else {
  242. $(document).trigger("error", data.message);
  243. }
  244. }).fail(function (xhr, textStatus, errorThrown) {
  245. $(document).trigger("error", xhr.responseText);
  246. });
  247. };
  248. self.execute = function () {
  249. $(document).trigger("executeStarted", self);
  250. $(".jHueNotify").hide();
  251. logGA('/execute/' + self.type());
  252. self.result.clear();
  253. self.progress(0);
  254. self.status('running');
  255. $.post("/spark/api/execute", {
  256. notebook: ko.mapping.toJSON(notebook),
  257. snippet: ko.mapping.toJSON(self)
  258. }, function (data) {
  259. if (data.status == 0) {
  260. $.each(data.handle, function (key, val) {
  261. self.result.handle()[key] = val;
  262. });
  263. self.result.hasResultset(data.handle.has_result_set);
  264. self.checkStatus();
  265. } else {
  266. self._ajax_error(data);
  267. }
  268. }).fail(function (xhr, textStatus, errorThrown) {
  269. $(document).trigger("error", xhr.responseText);
  270. self.status('failed');
  271. });
  272. };
  273. self.fetchResult = function(rows, startOver) {
  274. if (typeof startOver == "undefined") {
  275. startOver = true;
  276. }
  277. self.fetchResultData(rows, startOver);
  278. //self.fetchResultMetadata(rows);
  279. };
  280. self.fetchResultData = function(rows, startOver) {
  281. $.post("/spark/api/fetch_result_data", {
  282. notebook: ko.mapping.toJSON(notebook),
  283. snippet: ko.mapping.toJSON(self),
  284. rows: rows,
  285. startOver: startOver
  286. }, function (data) {
  287. if (data.status == 0) {
  288. rows -= data.result.data.length;
  289. if (self.result.meta().length == 0) {
  290. data.result.meta.unshift({type: "INT_TYPE", name: "", comment: null});
  291. self.result.meta(data.result.meta);
  292. }
  293. var _initialIndex = self.result.data().length;
  294. var _tempData = [];
  295. $.each(data.result.data, function (index, row) {
  296. row.unshift(_initialIndex + index);
  297. self.result.data.push(row);
  298. _tempData.push(row);
  299. });
  300. $(document).trigger("renderData", {data: _tempData, snippet: self, initial: _initialIndex == 0});
  301. if (data.result.has_more && rows > 0) {
  302. setTimeout(function () {
  303. self.fetchResultData(rows, false);
  304. }, 500);
  305. }
  306. } else {
  307. self._ajax_error(data);
  308. }
  309. }).fail(function (xhr, textStatus, errorThrown) {
  310. $(document).trigger("error", xhr.responseText);
  311. });
  312. };
  313. self.fetchResultMetadata = function () {
  314. $.post("/spark/api/fetch_result_metadata", {
  315. notebook: ko.mapping.toJSON(notebook),
  316. snippet: ko.mapping.toJSON(self),
  317. }, function (data) {
  318. if (data.status == 0) {
  319. self.result.meta(data.result.meta);
  320. } else {
  321. $(document).trigger("error", data.message);
  322. }
  323. }).fail(function (xhr, textStatus, errorThrown) {
  324. $(document).trigger("error", xhr.responseText);
  325. self.status('failed');
  326. });
  327. };
  328. self.checkStatus = function() {
  329. $.post("/spark/api/check_status", {
  330. notebook: ko.mapping.toJSON(notebook),
  331. snippet: ko.mapping.toJSON(self)
  332. }, function (data) {
  333. if (data.status == 0) {
  334. self.status(data.query_status.status);
  335. self.getLogs();
  336. if (self.status() == 'running') {
  337. self.checkStatusTimeout = setTimeout(self.checkStatus, 1000);
  338. }
  339. else if (self.status() == 'available') {
  340. self.fetchResult(100);
  341. self.progress(100);
  342. }
  343. } else {
  344. self._ajax_error(data);
  345. }
  346. }).fail(function (xhr, textStatus, errorThrown) {
  347. $(document).trigger("error", xhr.responseText);
  348. self.status('failed');
  349. });
  350. };
  351. self.cancel = function() {
  352. if (self.checkStatusTimeout != null) {
  353. clearTimeout(self.checkStatusTimeout);
  354. self.checkStatusTimeout = null;
  355. }
  356. $.post("/spark/api/cancel_statement", {
  357. notebook: ko.mapping.toJSON(notebook),
  358. snippet: ko.mapping.toJSON(self)
  359. }, function (data) {
  360. if (data.status == 0) {
  361. self.status('canceled');
  362. } else {
  363. self._ajax_error(data);
  364. }
  365. }).fail(function (xhr, textStatus, errorThrown) {
  366. $(document).trigger("error", xhr.responseText);
  367. self.status('failed');
  368. });
  369. };
  370. self.getLogs = function() {
  371. $.post("/spark/api/get_logs", {
  372. notebook: ko.mapping.toJSON(notebook),
  373. snippet: ko.mapping.toJSON(self)
  374. }, function (data) {
  375. if (data.status == 0) {
  376. self.result.logs(data.logs); // Way to append?
  377. self.progress(data.progress);
  378. } else {
  379. self._ajax_error(data);
  380. }
  381. }).fail(function (xhr, textStatus, errorThrown) {
  382. $(document).trigger("error", xhr.responseText);
  383. self.status('failed');
  384. });
  385. };
  386. self.init = function() {
  387. if (self.status() == 'running') {
  388. self.checkStatus();
  389. }
  390. if (self.status() != 'loading' && self.status() != 'ready') {
  391. self.getLogs();
  392. }
  393. };
  394. }
  395. var Notebook = function (vm, notebook) {
  396. var self = this;
  397. self.id = ko.observable(typeof notebook.id != "undefined" && notebook.id != null ? notebook.id : null);
  398. self.uuid = ko.observable(typeof notebook.uuid != "undefined" && notebook.uuid != null ? notebook.uuid : UUID());
  399. self.name = ko.observable(typeof notebook.name != "undefined" && notebook.name != null ? notebook.name : 'My Notebook');
  400. self.snippets = ko.observableArray();
  401. self.selectedSnippet = ko.observable(vm.availableSnippets()[0].type());
  402. self.sessions = ko.mapping.fromJS(typeof notebook.sessions != "undefined" && notebook.sessions != null ? notebook.sessions : []);
  403. self.getSession = function(session_type) {
  404. var _s = null;
  405. $.each(self.sessions(), function (index, s) {
  406. if (s.type() == session_type) {
  407. _s = s;
  408. return false;
  409. }
  410. });
  411. return _s;
  412. };
  413. self.addSession = function(session) {
  414. var toRemove = []
  415. $.each(self.sessions(), function (index, s) {
  416. if (s.type() == session.type()) {
  417. toRemove.push(s);
  418. }
  419. });
  420. $.each(toRemove, function (index, s) {
  421. self.sessions.remove(s);
  422. });
  423. self.sessions.push(session);
  424. };
  425. self.addSnippet = function(snippet) {
  426. var _snippet = new Snippet(self, snippet);
  427. self.snippets.push(_snippet);
  428. if (self.getSession(_snippet.type()) == null) {
  429. _snippet.create_session();
  430. } else {
  431. _snippet.status('ready');
  432. }
  433. _snippet.init();
  434. };
  435. self.newSnippet = function() {
  436. var _snippet = new Snippet(self, {type: self.selectedSnippet(), result: {}});
  437. self.snippets.push(_snippet);
  438. if (self.getSession(self.selectedSnippet()) == null) {
  439. _snippet.create_session();
  440. } else {
  441. _snippet.status('ready');
  442. }
  443. };
  444. if (notebook.snippets) {
  445. $.each(notebook.snippets, function(index, snippet) {
  446. self.addSnippet(snippet);
  447. });
  448. }
  449. self.save = function () {
  450. $.post("/spark/api/notebook/save", {
  451. "notebook": ko.mapping.toJSON(self)
  452. }, function (data) {
  453. if (data.status == 0) {
  454. self.id(data.id);
  455. $(document).trigger("info", data.message);
  456. if (window.location.search.indexOf("notebook") == -1) {
  457. window.location.hash = '#notebook=' + data.id;
  458. }
  459. }
  460. else {
  461. $(document).trigger("error", data.message);
  462. }
  463. }).fail(function (xhr, textStatus, errorThrown) {
  464. $(document).trigger("error", xhr.responseText);
  465. });
  466. };
  467. }
  468. function EditorViewModel(notebooks, options) {
  469. var self = this;
  470. self.notebooks = ko.observableArray();
  471. self.selectedNotebook = ko.observable();
  472. self.isEditing = ko.observable(false);
  473. self.isEditing.subscribe(function(newVal){
  474. $(document).trigger("editingToggled");
  475. });
  476. self.toggleEditing = function () {
  477. self.isEditing(! self.isEditing());
  478. };
  479. self.isAssistVisible = ko.observable(options.assistVisible);
  480. self.toggleAssist = function () {
  481. self.isAssistVisible(! self.isAssistVisible());
  482. $(document).trigger("toggleAssist");
  483. };
  484. self.assistContent = ko.observable();
  485. self.assistSelectedMainObject = ko.observable();
  486. self.availableSnippets = ko.mapping.fromJS(options.languages);
  487. self.init = function() {
  488. $.each(notebooks, function(index, notebook) {
  489. self.loadNotebook(notebook);
  490. if (self.selectedNotebook() == null){
  491. self.selectedNotebook(self.notebooks()[0]);
  492. }
  493. });
  494. };
  495. self.loadNotebook = function(notebook) {
  496. var _n = new Notebook(self, notebook);
  497. self.notebooks.push(_n);
  498. if (_n.snippets().length > 0){
  499. _n.selectedSnippet(_n.snippets()[_n.snippets().length - 1].type());
  500. }
  501. };
  502. self.newNotebook = function() {
  503. self.notebooks.push(new Notebook(self, {}));
  504. self.selectedNotebook(self.notebooks()[self.notebooks().length - 1]);
  505. };
  506. self.saveNotebook = function() {
  507. self.selectedNotebook().save();
  508. };
  509. }
  510. function logGA(page) {
  511. if (typeof trackOnGA == 'function') {
  512. trackOnGA('editor/' + page);
  513. }
  514. }