GitHub user mebelousov opened a pull request:
https://github.com/apache/zeppelin/pull/2920
[ZEPPELIN-2679] JDBC. precode for session
### What is this PR for?
We have a precode for interpreter (all interpreters) which executes once
after start interpreter. With it we can create shared code that will be
available in the paragraph, create tables in the database and etc.
This precode for jdbc only which executes before run paragraph in same
session (sql). In this precode we can declare session variables that will be
available when you run paragraph (any sql which will be executed before the
paragraph). For example `set application_name='#{user};`
Previous discussion in #2442
### What type of PR is it?
Feature
### What is the Jira issue?
https://issues.apache.org/jira/browse/ZEPPELIN-2679
### How should this be tested?
(jdbc interpreter, postgres)
1. set property **default.statementPrecode** `set
application_name='#{user}';`
2. run paragraph `select current_setting('application_name');`
### Questions:
* Does the licenses files need update? no
* Is there breaking changes for older versions? no
* Does this needs documentation? no
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/TinkoffCreditSystems/zeppelin ZEPPELIN-2679
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/zeppelin/pull/2920.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 #2920
----
commit bd3d80952ca56e709379632318ba1193a17338ae
Author: Tinkoff DWH <tinkoff.dwh@...>
Date: 2017-06-23T11:58:20Z
[ZEPPELIN-2679] jdbc. precode for session
commit ae7a0d63966a1ddbf89292715221d041ecdc2b74
Author: Tinkoff DWH <tinkoff.dwh@...>
Date: 2017-06-26T04:14:11Z
[ZEPPELIN-2679] tests
commit 719d0a2fdf73a478c4475c8147da8d26646933ff
Author: isys.mreshetov <m.reshetov@...>
Date: 2017-06-29T04:35:10Z
ZEPPELIN-2679 docs
commit 7bba0db8ac7f28c7c35798e3292ec0e8dd08fde8
Author: tinkoff-dwh <tinkoff.dwh@...>
Date: 2018-03-13T09:49:56Z
ZEPPELIN-2679 rename session to statement
commit cd0d6ed5dc455bb58d551519732b274121df5198
Author: tinkoff-dwh <tinkoff.dwh@...>
Date: 2018-03-13T11:12:12Z
Merge remote-tracking branch 'upstream/master' into ZEPPELIN-2679
commit 07b41c5110430f3b13ca81088b29fa5eae3d0734
Author: tinkoff-dwh <tinkoff.dwh@...>
Date: 2018-03-13T12:15:49Z
ZEPPELIN-2679 rename test methods
commit f7529cabe9d68202b6c22f5162d527844d48ba4f
Author: tinkoff-dwh <tinkoff.dwh@...>
Date: 2018-03-14T05:28:21Z
Merge remote-tracking branch 'upstream/master' into ZEPPELIN-2679
# Conflicts:
# jdbc/src/test/java/org/apache/zeppelin/jdbc/JDBCInterpreterTest.java
commit 00aeabf5dcc9b78ce40482ae2ffff4aed41da373
Author: tinkoff-dwh <tinkoff.dwh@...>
Date: 2018-03-14T05:37:48Z
ZEPPELIN-2679 fix checkstyle
commit e9d36d2847b3c0246b7242c2d37b1ccd75a262ad
Author: mebelousov <mebelousov@...>
Date: 2018-04-09T06:49:31Z
Merge remote-tracking branch 'apache/master' into ZEPPELIN-2679
# Conflicts:
# jdbc/src/test/java/org/apache/zeppelin/jdbc/JDBCInterpreterTest.java
commit 11f89a590eb5e75830056e2692167cfc72c8124e
Author: mebelousov <mebelousov@...>
Date: 2018-04-09T09:45:56Z
ZEPPELIN-2679 Small fix in docs
----
---
