Given the JIRA/Additional information, was anyone else able to reproduce? Thanks
John On Fri, Jun 24, 2016 at 8:57 AM, John Omernik <[email protected]> wrote: > I created a JIRA and included all this here: > https://issues.apache.org/jira/browse/DRILL-4753. I am using the MapR 1.6 > release. Let me know if I can provide any more information. Do note, I was > always using limits, Jingeng - your queries don't seem to use limits... can > you try with limits (both limit 0 and limit 1) and see what the result is? > > Thanks! > > > > View Creation: > > CREATE VIEW dfs.prod.view_mytable AS > SELECT dir0 as `p_day`, `field1`, `field2`, `field3`, `field4`, `field5`, > `field6`, `field7` > FROM dfs.prod.`mytable` > > View File: > > { > "name" : "view_mytable", > "sql" : "SELECT `dir0` as `p_day`, `field1`, `field2`, `field3`, > `field4`, `field5`, `field6`, `field7`\nFROM `dfs`.`prod`.`mytable`", > "fields" : [ { > "name" : "p_day", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field1", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field2", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field3", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field4", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field5", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field6", > "type" : "ANY", > "isNullable" : true > }, { > "name" : "field7", > "type" : "ANY", > "isNullable" : true > } ], > "workspaceSchemaPath" : [ ] > } > > > > select * from view_mytable limit 0; > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > | p_day | field1 | field2 | field3 | field4 | field5 | > field6 | field7 | > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > > select * from view_mytable where p_day = '2016-05-09' limit 0; > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > | p_day | field1 | field2 | field3 | field4 | field5 | > field6 | field7 | > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > > select * from view_mytable limit 1; > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > | dir0 | field1 | field2 | field3 | field4 | field5 | > field6 | field7 | > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > > select * from view_mytable where p_day = '2016-06-09' limit 1; > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > | dir0 | field1 | field2 | field3 | field4 | field5 | > field6 | field7 | > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > +--------+----------------+--------+----------+----------+----------+--------+--------+ > > > select p_day from view_mytable limit 0; > +--------+ > | p_day | > +--------+ > +--------+ > > > select p_day from view_mytable where p_day = '2016-05-09' limit 0; > +--------+ > | p_day | > +--------+ > +--------+ > > > select p_day from view_mytable limit 1; > +------------------------+-------------+ > | _DEFAULT_COL_TO_READ_ | dir0 | > +------------------------+-------------+ > | null | 2016-05-09 | > +------------------------+-------------+ > > > select p_day from view_mytable where p_day = '2016-05-09' limit 1; > +------------------------+-------------+ > | _DEFAULT_COL_TO_READ_ | dir0 | > +------------------------+-------------+ > | null | 2016-05-09 | > +------------------------+-------------+ > > > select p_day, field1 from view_mytable limit 0; > +--------+----------------+ > | p_day | field1 | > +--------+----------------+ > +--------+----------------+ > > > select p_day, field1 from view_mytable where p_day = '2016-05-09' limit > 0; > +--------+----------------+ > | p_day | field1 | > +--------+----------------+ > +--------+----------------+ > > > > select p_day, field1 from view_mytable limit 1; > +-------------+----------------+ > | dir0 | field1 | > +-------------+----------------+ > | 2016-05-09 | 0 | > +-------------+----------------+ > > > select p_day, field1 from view_mytable where p_day = '2016-05-09' limit > 1; > +-------------+----------------+ > | dir0 | field1 | > +-------------+----------------+ > | 2016-05-09 | 0 | > +-------------+----------------+ > > > > On Thu, Jun 23, 2016 at 6:42 PM, Ted Dunning <[email protected]> > wrote: > >> On Thu, Jun 23, 2016 at 12:33 PM, John Omernik <[email protected]> wrote: >> >> > Am I over thinking minutia again? :) >> > >> > >> I htink that this counts as basics, not minutiae. >> > >
