I’m experiencing case-sensitive view names, the drill documentation here:
https://drill.apache.org/docs/lexical-structure/#case-sensitivity doesn't
explicitly state weather view names are case-insensitive:
0: jdbc:drill:> select state, count(1) from
`yelp/yelp_academic_dataset_business.json` group by state;
+--------+---------+
| state | EXPR$1 |
+--------+---------+
| AZ | 15582 |
| CA | 2 |
| SC | 1 |
+--------+---------+
3 rows selected (0.533 seconds)
0: jdbc:drill:> create or replace view BUSINESS_COUNT as select state,
count(1) from `yelp/yelp_academic_dataset_business.json` group by
state;
+-------+-----------------------------------------------------------------------+
| ok | summary
|
+-------+-----------------------------------------------------------------------+
| true | View 'BUSINESS_COUNT' created successfully in
'maprfs.cmatta' schema |
+-------+-----------------------------------------------------------------------+
1 row selected (0.36 seconds)
0: jdbc:drill:> select * from business_count;
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 28:
Table 'business_count' not found
[Error Id: f2371e7b-f3de-4aef-9879-bae10fddea6b on
se-node13.se.lab:31010] (state=,code=0)
0: jdbc:drill:> select * from BUSINESS_COUNT;
+--------+---------+
| state | EXPR$1 |
+--------+---------+
| AZ | 15582 |
| CA | 2 |
| SC | 1 |
+--------+---------+
3 rows selected (0.554 seconds)
0: jdbc:drill:>
I see this JIRA, but it’s related to the jdbc storage plugin:
https://issues.apache.org/jira/browse/DRILL-4458
Is this expected behavior?
Chris Matta
cma...@mapr.com
215-701-3146
