AnsweredAssumed Answered

When I click on "Explore" database, it gives me below error. Mysql connectors are up to date.   Unable to retrieve database information because of an error  Error getting views from schema [null] You have an error in your SQL syntax; check the manual that

Question asked by Rajan Kshirsagar on Jun 12, 2019
Latest reply on Jun 12, 2019 by Rajan Kshirsagar

I am using MYSQL 8.0 version. When I click on "Explore" database in pentaho, it gives me below error.

 

1. Mysql connectors are up to date.   

2.Single table "Select" query runs proper and shows data in grid. 

3. Explore only shows error.

 

 


Unable to retrieve database information because of an error

Error getting views from schema [null]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING TABLE_TYPE IN ('VIEW',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SCH' at line 1

Outcomes