GitHub user tinkoff-dwh opened a pull request: https://github.com/apache/zeppelin/pull/2343
[ZEPPELIN-2538] JDBC completer improvements for work with large meta ### What is this PR for? There are some problems if meta is large (few schemas, each schema contains 500+ tables etc.). Problems: 1. loading is very long 2. each update takes one connection if updates are long, the situation may arise that the entire pool will be busy 3. no cache This PR solves these problems. Added cache and access by full path (schema.table, schema.table.column) ### What type of PR is it? Improvement ### What is the Jira issue? https://issues.apache.org/jira/browse/ZEPPELIN-2538 ### Screenshots (if appropriate)  ### 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/tinkoff-dwh/zeppelin ZEPPELIN-2538 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/zeppelin/pull/2343.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 #2343 ---- commit d600fa16dc5e18c1a6ebdc7de0dfc71b2ddff752 Author: Tinkoff DWH <tinkoff....@gmail.com> Date: 2017-05-12T12:36:12Z [ZEPPELIN-2538] rewrite sql completer to work with large data commit f26ab5dad61c7ea4881b07e58acec53dadb34bed Author: Tinkoff DWH <tinkoff....@gmail.com> Date: 2017-05-15T06:33:46Z [ZEPPELIN-2538] fix tests commit f999488b54769e148cf4fa1134d66b0c55392556 Author: Tinkoff DWH <tinkoff....@gmail.com> Date: 2017-05-15T07:26:23Z Merge remote-tracking branch 'upstream/master' into ZEPPELIN-2538 commit a5788743781d68c3159bd55b68b32d9bc7dc324f Author: Tinkoff DWH <tinkoff....@gmail.com> Date: 2017-05-15T07:32:20Z [ZEPPELIN-2538] protection long download commit e770d261cd492dda4167f0c0b5c69916fb744109 Author: Tinkoff DWH <tinkoff....@gmail.com> Date: 2017-05-15T09:22:39Z [ZEPPELIN-2538] update description ---- --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---