Timout error on mysql

1

Hi

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

2

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.