R Error in .jcall(rp, "I", "fetch", stride, block) : java.sql.SQLException: Value is not a number: java.lang.String

Question

I am running a simple sql query in R (using Rstudio). The connection is using Presto driver.

I can run a simple query Select count(*) from schema.mytable with no issues. However, as soon as I try to run Select * from schema.mytable i get the following error

df_zdld001 <- dbGetQuery(conn, input_sql)
Error in .jcall(rp, "I", "fetch", stride, block) : 
  java.sql.SQLException: Value is not a number: java.lang.String

How to solve this?