Timout error on mysql


I am getting following error while executing
select MSISDN,SUM(REVENUE) from TEST.“rev_union” WHERE EVENT_DATE= DATE ‘2019-08-01’ and EVENT_TYPE=‘SMS’ group by MSISDN limit 1000

WARN c.d.e.store.jdbc.JdbcSchemaFetcher - Took longer than 5 seconds to execute query select count(*) fromdremio_test.REV1``.
java.sql.SQLTimeoutException: (conn:922) Query timed out

The query is getting failed after this. How can i resolve this

The MySQL Source has an Advanced Option “Net write timeout (in seconds)”. This is seconds to wait for data from the server before timing out. Please try increasing this parameter.