Troubleshoot SQL Queries

If you encounter an issue with a SQL query, the first place to look for more information about the issue is the var/log/sql/sql.log file. If you need more verbose log information, change the level to DEBUG for the following loggers in the file conf/sql-log4j2.xml (on Unix) or conf\sql-log4j2.xml (on Windows):

<logger name="com.lucidworks.spark" level="DEBUG"/>
<logger name="com.lucidworks.spark.sql" level="DEBUG"/>

After making changes, you must restart the Fusion SQL service. Give these commands from the bin directory below the Fusion home directory, for example, /opt/fusion/latest.x (on Unix) or C:\lucidworks\fusion\latest.x (on Windows).

On Unix:

./sql restart

On Windows:

sql.cmd restart