[
https://issues.apache.org/jira/browse/DRILL-2649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-2649:
----------------------------------
Fix Version/s: 1.2.0
> 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
> Components: Documentation
> Reporter: Daniel Barclay (Drill)
> Assignee: Kristine Hahn
> Fix For: 1.2.0
>
>
> 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)
