Presto failed: com.facebook.presto.spi.type.VarcharType

Question

I created a table with three columns - id, name, position, then I stored the data into s3 using orc format using spark.

When I query select * from person it returns everything.

But when I query from presto, I get this error:

Query 20180919_151814_00019_33f5d failed: com.facebook.presto.spi.type.VarcharType

Answer 1

I have found the answer for the problem, when I stored the data in s3, the data inside the file was with one more column that was not defined in the hive table metastore.

So when Presto tried to query the data, it found that there are varchar instead of integer.

This also might happen if one record has a a type different than what is defined in the metastore.

I had to delete my data and import it again without that extra unneeded column