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.
- convert unix timestamp Christopher Matta
- Re: convert unix timestamp Kristine Hahn
- Re: convert unix timestamp Andries Engelbrecht
- Re: convert unix timestamp Andries Engelbrecht
- Re: convert unix timestamp Jason Altekruse
- Re: convert unix timestamp Hao Zhu
- convert unix timestamp Christopher Matta
