Table and view names are case sensitive when using the FileSystemPlugin and a case sensitive filesystem. They are not case sensitive if the filesystem is case insensitive.
-- Jacques Nadeau CTO and Co-Founder, Dremio On Mon, Mar 21, 2016 at 2:50 PM, Abhishek Girish <abhishek.gir...@gmail.com> wrote: > 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 > > > > >
