Tried taking a look at the function to see what the issue was,
from_unixtime is actually a Hive UDF that is just on the classpath and
available by default in Drill. It does look like Andries said that it is
returning var16char, which might be a bug. The fact that it is trying to
cast to bigInt despite it not appearing in the query seems to be an attempt
to use an intermediate implicit cast that cannot actually be executed.

Reply via email to