Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.7.3
-
None
-
None
-
centos
digital ocean
it has good ram and disk capacity
Description
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.