twosigma / twosigma/beakerx

Unknown system variable 'query_cache_size'

Open
#8,063 1 comment 0 reactions 1 assignee Claimed by @LeeTZ View on GitHub
Dominant language
Jupyter Notebook
Stars
2.9k
Forks
383
PR merge metrics
No merged PRs in 30d

Description

Hello,
I can use the beaker SQL Notebook to connect myself to a MySql Database with:
%defaultDatasource jdbc:mysql://username:@hostname/dbnameserver?Timezone=Europe/Amsterdam
But after trying a sql query "Select * from " I get the error:
java.sql.SQLException: Unknown system variable 'query_cache_size'
Apparently it is because the MySql Version 8 does not support 'query_cache_size' anymore and the jdbc connector ist too old.
Is there a way to update the jdbc connector?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.