Srikanth G N created ZEPPELIN-3110:
--------------------------------------
Summary: JDBCInterpreter, Metadata from getConnection is not
getting cached, getDataModelMetadataCompletions gets invoked for every sql
query
Key: ZEPPELIN-3110
URL: https://issues.apache.org/jira/browse/ZEPPELIN-3110
Project: Zeppelin
Issue Type: Bug
Components: Interpreters
Affects Versions: 0.7.3
Environment: centos
digital ocean
it has good ram and disk capacity
Reporter: Srikanth G N
When ever a sql query is run from the zeppelin notebook, if the number of
tables or the model of the sql database is huge, then it takes lot of time
..upto 4 to 5 minutes to execute a query.
Reason:
Method getDataModelMetadataCompletions is called everytime, and if the database
has lot of tables then metadatauery take too much time, which results in user
made to wait for a long time.
Line no 433 , filname : JDBCInterpreter.java,
propertyKeySqlCompleterMap.put(propertyKey, createSqlCompleter(connection));
When executing this line createSqlCompleter method invokes
getDataModelMetadataCompletions
A possible fix could be checking if the map already contains a proper value for
key : propertyKey and only based on this check we can invoke createSqlCompleter.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
