I think that part of the doc needs to be updated. Table names & view names are case-sensitive. Also the doc section about double-quoting names is in-correct. Using double quotes gives us a SQL parse error.
On Mon, Mar 21, 2016 at 1:27 PM, Christopher Matta <cma...@mapr.com> wrote: > 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 > >
