The function from_unixtime() is actually a Hive UDF and drill doesn’t yet know how to deal with the 2 extra bytes returned from it. It’s better to use the Drill function to_timestamp():
select to_timestamp(1432912733) from `sys`.`version` Chris mattacma...@mapr.com 215-701-3146 On Tue, Jun 9, 2015 at 7:49 AM, Uli Bethke <uli.bet...@sonra.io> wrote: The following query run through Drill Explorer/ODBC returns NULL, while > running > it from SQLLINE it works fine. > > select from_unixtime(1432912733) from `sys`.`version`; > > Is this a limitation of the ODBC driver? > Running on Drill 1.0.0 on Windows in Embedded mode. Using 1.0.0 ODBC driver