[jira] [Created] (DRILL-2649) Math and Trig page seems to refer to types that are not Drill SQL types

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

Daniel Barclay (Drill) created DRILL-2649:
---------------------------------------------

             Summary: Math and Trig page seems to refer to types that are not Drill SQL types
                 Key: DRILL-2649
                 URL: https://issues.apache.org/jira/browse/DRILL-2649
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Daniel Barclay (Drill)


The Math and Trig page at http://drill.apache.org/docs/math-and-trig/ refers to data types UINT1, UINT2, UINT4, UINT8, FLOAT4, FLOAT8, DECIMAL9, and DECIMAL18.

However, these do not seem to be Drill SQL types, at least based on their behavior in CAST expressions.  For example:

0: jdbc:drill:zk=local> SELECT CAST( 1 as UINT4 ) FROM INFORMATION_SCHEMA.CATALOGS;
Mar 31, 2015 9:47:51 PM org.eigenbase.sql.validate.SqlValidatorException <init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Unknown datatype name 'UINT4'
Mar 31, 2015 9:47:51 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column 19 to line 1, column 23: Unknown datatype name 'UINT4'
Query failed: SqlValidatorException: Unknown datatype name 'UINT4'

Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:zk=local> 

Those names seem to refer to Drill _internal_ types (or types used in the storage plugin interface), not Drill _SQL_ types.  

Since the Math and Trig page deals with the SQL interface, it should be in terms of Drill SQL types, not Drill internal/non-SQL types.

Additionally:
- The page says "INT" (a syntax-only shortcut) rather than "INTEGER" (the actual name of the type).
- The page lists SMALLINT but not TINYINT.  Is that inconsistency intended?





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