https://community.qlik.com/t5/Talend-Studio/MySQL-guess-schema-error/m-p/2196139#M422 <P>When you "guess schema" it doesn't read the DB.&nbsp; It reads the Query, it tries to build a schema from the query in the "Query" box.&nbsp; If there is no query, then you get an error.&nbsp;&nbsp;</P><P>&nbsp;</P><P>This is similar to guessing the Query.&nbsp; It doesn't read the DB, but instead reads the specified Schema in your component</P><P>&nbsp;</P><P>So, when you create a new DB connection in the <STRONG>Metadata/Db connections</STRONG> you can right click and "<STRONG>Retrieve Schema</STRONG>" from your DB.&nbsp; Then you can assign the schema to your DB component, then you can use "Guess Query".</P> Thu, 09 Apr 2020 21:56:22 GMT billimmer 2020-04-09T21:56:22Z https://community.qlik.com/t5/Talend-Studio/MySQL-guess-schema-error/m-p/2196138#M421 <P>Hi,</P><P>I have connected the MySQL database. But getting an error, when using guess schema.</P><P>&nbsp;</P><P>can help me this problem.</P> Sat, 16 Nov 2024 02:43:58 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-guess-schema-error/m-p/2196138#M421 BNP 2024-11-16T02:43:58Z https://community.qlik.com/t5/Talend-Studio/MySQL-guess-schema-error/m-p/2196139#M422 <P>When you "guess schema" it doesn't read the DB.&nbsp; It reads the Query, it tries to build a schema from the query in the "Query" box.&nbsp; If there is no query, then you get an error.&nbsp;&nbsp;</P><P>&nbsp;</P><P>This is similar to guessing the Query.&nbsp; It doesn't read the DB, but instead reads the specified Schema in your component</P><P>&nbsp;</P><P>So, when you create a new DB connection in the <STRONG>Metadata/Db connections</STRONG> you can right click and "<STRONG>Retrieve Schema</STRONG>" from your DB.&nbsp; Then you can assign the schema to your DB component, then you can use "Guess Query".</P> Thu, 09 Apr 2020 21:56:22 GMT https://community.qlik.com/t5/Talend-Studio/MySQL-guess-schema-error/m-p/2196139#M422 billimmer 2020-04-09T21:56:22Z