[
https://issues.apache.org/jira/browse/DRILL-583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13983827#comment-13983827
]
Mehant Baid commented on DRILL-583:
-----------------------------------
There isn't an obvious way to control this from SQL.
Sparse representation is used to perform mathematical functions. Dense
representation is used for sorting, comparisons etc. By default we keep the
representation in dense format but once we have to perform math functions we
convert it to sparse.
> 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)
