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
<[email protected]> wrote:
On Thu, Apr 5, 2018 at 9:43 PM, Paul Rogers <[email protected]>
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.