Ted, this is why your participation in Drill is such a gift: cast push-down is an elegant, simple solution that even works in views. Beautiful.
Thanks, - Paul On Friday, April 6, 2018, 11:35:37 AM PDT, Ted Dunning <ted.dunn...@gmail.com> wrote: On Thu, Apr 5, 2018 at 9:43 PM, Paul Rogers <par0...@yahoo.com.invalid> wrote: > Great discussion. Really appreciate the insight from the Drill users! > > To Ted's points: the simplest possible solution is to allow a table > function to express types. Just making stuff up: > > SELECT a FROM schema(myTable, (a: INT)) > Why not just allow cast to be pushed down to the reader? Why invent new language features? Or, really ugly, a session option: > > ALTER SESSION SET schema.myTable="a: INT" > These are a big problem.