[ https://issues.apache.org/jira/browse/DRILL-583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13985173#comment-13985173 ]
George Chow commented on DRILL-583: ----------------------------------- But it is intended to have access to both representation of decimals from SQL, right? Or is one meant to be an internal intermediate form while the other is the external form? > Decimal in CAST function > ------------------------ > > Key: DRILL-583 > URL: https://issues.apache.org/jira/browse/DRILL-583 > Project: Apache Drill > Issue Type: Bug > Reporter: James Duong > Priority: Minor > > Running the query > {code} > SELECT cast(1 AS decimal) FROM INFORMATION_SCHEMA.`TABLES` LIMIT 1 > {code} > seems to return a FLOAT8 instead of a decimal. > We need to be able to specify the exact decimal type (eg DECIMAL28SPARSE), as > well as the precision/scale for it in the cast operator too. -- This message was sent by Atlassian JIRA (v6.2#6252)