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.
>
