Strange behavior on MAP and ARRAY type

2016-09-25 Thread Jungtaek Lim
Hi devs, I'm experimenting with ARRAY and MAP type with Calcite's JaninoRexCompiler. (with Calcite 1.9.0) While testing I found some behaviors, so would like to see they're intentional or bugs we want to resolve. 1. Even though I set map's key/value type or array's type explicitly, compiler

Re: Using Metadata in Query Optimization

2016-09-25 Thread Γιώργος Θεοδωράκης
I believe it has to do with the implementation of my tables, as I get fixed numbers: 1)select * from products => Rows:100 2)select * from products where productid > 5 => Rows:50 3)select * from products where productid = 5 => Rows:25 (and the exact same numbers for the table orders) How can I