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)
