drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bridget Bevens (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4524) case-sensitive view names
Date Mon, 21 Mar 2016 22:05:25 GMT
Bridget Bevens created DRILL-4524:
-------------------------------------

             Summary: case-sensitive view names
                 Key: DRILL-4524
                 URL: https://issues.apache.org/jira/browse/DRILL-4524
             Project: Apache Drill
          Issue Type: Bug
          Components: Documentation
            Reporter: Bridget Bevens
            Assignee: Bridget Bevens


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 <cmatta@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

cmatta@mapr.com
215-701-3146
​



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message