mutate(as.character) produces an error (unknown type)

[OssiLehtinen]

Issue Description

Similar to the earlier issue with as.integer #42, as.character also produces an error, as 'string' is an unknown type. Here we should use 'varchar'.

Reproducible Example

Example:

library(RAthena)
library(DBI)
con <- dbConnect(RAthena::athena(),
               profile_name = "rathena")

tbl(con, "iris")) %>%
mutate(sepal_length = as.character(sepal_length))

Error: SYNTAX_ERROR: line 1:8: Unknown type: string

Surely related again to the differences between HIVE DDL and Presto SQL Syntax.

[DyfanJones]

Thanks for point this out :) Apologies for this issue, I will fix this.

[DyfanJones]

This has now been fixed in latest dev version. Thanks for identifying bug 👍