Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BNP
Contributor
Contributor

MySQL guess schema error

Hi,

I have connected the MySQL database. But getting an error, when using guess schema.

 

can help me this problem.

Labels (4)
1 Reply
billimmer
Creator III
Creator III

When you "guess schema" it doesn't read the DB.  It reads the Query, it tries to build a schema from the query in the "Query" box.  If there is no query, then you get an error.  

 

This is similar to guessing the Query.  It doesn't read the DB, but instead reads the specified Schema in your component

 

So, when you create a new DB connection in the Metadata/Db connections you can right click and "Retrieve Schema" from your DB.  Then you can assign the schema to your DB component, then you can use "Guess Query".