[ https://issues.apache.org/jira/browse/HIVE-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14031816#comment-14031816 ]
Lefty Leverenz commented on HIVE-3976: -------------------------------------- [~lars_francke] documented this in the wiki: * [Hive Data Types -- Decimals | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Decimals] * [doc diffs for HIVE-3976 | https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=27838462&selectedPageVersions=26&selectedPageVersions=25] > Support specifying scale and precision with Hive decimal type > ------------------------------------------------------------- > > Key: HIVE-3976 > URL: https://issues.apache.org/jira/browse/HIVE-3976 > Project: Hive > Issue Type: New Feature > Components: Query Processor, Types > Affects Versions: 0.11.0 > Reporter: Mark Grover > Assignee: Xuefu Zhang > Fix For: 0.13.0 > > Attachments: HIVE-3976.1.patch, HIVE-3976.10.patch, > HIVE-3976.11.patch, HIVE-3976.2.patch, HIVE-3976.3.patch, HIVE-3976.4.patch, > HIVE-3976.5.patch, HIVE-3976.6.patch, HIVE-3976.7.patch, HIVE-3976.8.patch, > HIVE-3976.9.patch, HIVE-3976.patch, remove_prec_scale.diff > > > HIVE-2693 introduced support for Decimal datatype in Hive. However, the > current implementation has unlimited precision and provides no way to specify > precision and scale when creating the table. > For example, MySQL allows users to specify scale and precision of the decimal > datatype when creating the table: > {code} > CREATE TABLE numbers (a DECIMAL(20,2)); > {code} > Hive should support something similar too. -- This message was sent by Atlassian JIRA (v6.2#6252)