cgivre commented on issue #1627: DRILL-7014: Format plugin for LTSV files URL: https://github.com/apache/drill/pull/1627#issuecomment-464069802 @shimamoto We're making progress! Unfortunately, one unit test is still failing: `testQueryWithConditions()` ``` java.lang.Exception: org.apache.drill.common.exceptions.UserRemoteException: FUNCTION ERROR: Failure reading Function class. Function Class org.apache.drill.exec.expr.fn.impl.gcast.CastVarCharFloat8 Fragment 0:0 [Error Id: 86e337a7-aef1-4011-8192-4d5760d668ba on 192.168.1.21:31013] For query: SELECT * FROM cp.`simple.ltsv` WHERE reqtime > 3.0 ``` I suspect the reason here first of all is that all the fields are being read in as `VARCHAR` and then you try the `>` operator, which requires a numeric field, so it fails. You should be able to remedy this by casting the column to a numeric type with either the `CAST()` or `TO_NUMBER()` functions directly in the `WHERE` clause.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
