drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4739) "SQL Extensions" doc. errata
Date Tue, 21 Jun 2016 18:16:58 GMT
Paul Rogers created DRILL-4739:

             Summary: "SQL Extensions" doc. errata
                 Key: DRILL-4739
                 URL: https://issues.apache.org/jira/browse/DRILL-4739
             Project: Apache Drill
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 1.6.0
            Reporter: Paul Rogers
            Priority: Minor

The “sys.drilbits” (http://drill.apache.org/docs/sql-extensions/) example throws an error
when used with the standalone version:

SELECT host FROM sys.drillbits WHERE `current` = true;

Produces the following error:

Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 11: Column 'host' not found
in any table
[Error Id: e1d92308-9235-4699-ac53-03a59d06ce69 on] (state=,code=0)

Performing “select * from sys.drillbits;” shows that the actual column name is “hostname”.
Checking http://drill.apache.org/docs/querying-system-tables/ shows that hostname is the documented
column name.

So, change the above example to:

SELECT hostname FROM sys.drillbits WHERE `current` = true;

Note the use of "hostname" rather than "host".

This message was sent by Atlassian JIRA

View raw message