KNOWLEDGE BASE

Error "Unable to create extract ... MAX_JOIN_SIZE" Creating MySQL Extract


Published: 11 Nov 2013
Last Modified Date: 03 Nov 2015

Issue

When creating an extract of a MySQL data source in Tableau Desktop, the following error might occur:

Unable to create extract
[MySQL][ODBC 5.2(a) Driver][mysqld-5.5.31-log]The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Environment

  • Tableau Desktop
  • MySQL

Resolution

Work with your MySQL database administrator to make changes at the database level to allow the JOIN statement.

Cause

The extract exceeds the setting for the max_join_size variable in the MySQL configuration. Refer to the Additional Information on MySQL server system variables.
Did this article resolve the issue?