GitHub user oxygen311 opened a pull request:
https://github.com/apache/zeppelin/pull/3064
[ZEPPELIN-3596] Saving resources from pool to SQL
### What is this PR for?
> It's information in resourcePool, but it is only available for viewing.
It would be nice if we can save this data to SQL via JDBC Driver.
Now you can access to `ResourcePool` data from SQL query. For example, if
you write `SELECT * FROM
{ResourcePool.note_id=SOME_NOTE_ID.paragraph_id=SOME_PARAGRAPH_ID};` and it
will be correct SQL query.
How it works:
1. Creates and fills a table named like a `PARAGRAPH_ID`;
2. Expression `{*}` replaces with actual table name;
3. Updated SQL query is running.
Also, you can not specify the note_id, then the note_id of the current
notebook will be used. For example, `SELECT * FROM
{ResourcePool.paragraph_id=SOME_PARAGRAPH_ID};`.
### What type of PR is it?
Improvement
### What is the Jira issue?
[Zeppelin
3596](https://issues.apache.org/jira/projects/ZEPPELIN/issues/ZEPPELIN-3596?filter=allopenissues)
### Questions:
* Does the licenses files need update?
* Is there breaking changes for older versions?
* Does this needs documentation?
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/TinkoffCreditSystems/zeppelin ZEPPELIN-3596
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/zeppelin/pull/3064.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #3064
----
commit 6033d8fddb4b7f21f268a79143baa5903bf6c759
Author: oxygen311 <alex39-09@...>
Date: 2018-07-10T10:18:37Z
Add `preparePoolData` function
commit 882a4ee9aa128d2d06d85841a4ea50e4d01f4aaa
Author: oxygen311 <alex39-09@...>
Date: 2018-07-10T16:06:45Z
Code refactoring
commit af8747b6c19e7ab94e23352ab8162d72c9a19fe0
Author: oxygen311 <alex39-09@...>
Date: 2018-07-11T09:41:28Z
Refactoring
commit 1a32689b101d5974f5e31d1d883befe9d0142eec
Author: oxygen311 <alex39-09@...>
Date: 2018-07-11T11:41:03Z
Add tests
commit d5e57ad5cc5e19b77aded00efcc2a567283f1b1b
Author: oxygen311 <alex39-09@...>
Date: 2018-07-11T11:55:47Z
Remove assignment operation from cycle
----
---
