[jira] [Created] (DRILL-4739) "SQL Extensions" doc. errata

[Paul Rogers (JIRA)]

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 10.250.50.31:31010] 
(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
(v6.3.4#6332)