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