spark.vm.js 18 KB

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