I tried on 1.7.0-SNAPSHOT and mapr 1.6.0 release. Unfortunately, I could not re-produce the problem.
select p_day from dfs.tmp.myview limit 0; +--------+ | p_day | +--------+ +--------+ No rows selected (1.871 seconds) 0: jdbc:drill:zk=local> select p_day from dfs.tmp.myview limit 1; +--------+ | p_day | +--------+ | 1990 | +--------+ 1 row selected (0.316 seconds) 0: jdbc:drill:zk=local> select p_day, l_partkey from dfs.tmp.myview where p_day = '1990' limit 1; +--------+------------+ | p_day | l_partkey | +--------+------------+ | 1990 | 11001 | +--------+------------+ 1 row selected (0.329 seconds) 0: jdbc:drill:zk=local> select p_day, l_partkey from dfs.tmp.myview where p_day = '1990' limit 0; +--------+------------+ | p_day | l_partkey | +--------+------------+ +--------+------------+ On Mon, Jun 27, 2016 at 5:53 AM, John Omernik <[email protected]> wrote: > 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. >>> >> >>
