hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3976) Support specifying scale and precision with Hive decimal type
Date Mon, 28 Oct 2013 05:49:32 GMT

    [ https://issues.apache.org/jira/browse/HIVE-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13806578#comment-13806578
] 

Hudson commented on HIVE-3976:
------------------------------

FAILURE: Integrated in Hive-trunk-hadoop2 #524 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/524/])
HIVE-3976 - Support specifying scale and precision with Hive decimal type (Xuefu Zhang via
Brock Noland) (brock: http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1536151)
* /hive/trunk/common/src/java/org/apache/hadoop/hive/common/type/HiveDecimal.java
* /hive/trunk/common/src/test/org/apache/hadoop/hive/common/type/TestHiveDecimal.java
* /hive/trunk/data/files/kv9.txt
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveResultSetMetaData.java
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/Utils.java
* /hive/trunk/jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java
* /hive/trunk/jdbc/src/test/org/apache/hive/jdbc/TestJdbcDriver2.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/Driver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/NumericOpMethodResolver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcStruct.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/io/orc/WriterImpl.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ParseUtils.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPDivide.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFOPPlus.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFBridge.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFToDecimal.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFToVarchar.java
* /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/exec/TestFunctionRegistry.java
* /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestOrcFile.java
* /hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/parse/TestHiveDecimalParse.java
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_4.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_5.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_6.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_join.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_precision.q
* /hive/trunk/ql/src/test/queries/clientpositive/decimal_udf.q
* /hive/trunk/ql/src/test/queries/clientpositive/orc_predicate_pushdown.q
* /hive/trunk/ql/src/test/queries/clientpositive/ptf_decimal.q
* /hive/trunk/ql/src/test/queries/clientpositive/serde_regex.q
* /hive/trunk/ql/src/test/queries/clientpositive/udf_pmod.q
* /hive/trunk/ql/src/test/queries/clientpositive/udf_to_double.q
* /hive/trunk/ql/src/test/queries/clientpositive/udf_to_float.q
* /hive/trunk/ql/src/test/queries/clientpositive/udf_to_string.q
* /hive/trunk/ql/src/test/queries/clientpositive/windowing_expressions.q
* /hive/trunk/ql/src/test/queries/clientpositive/windowing_multipartitioning.q
* /hive/trunk/ql/src/test/queries/clientpositive/windowing_navfn.q
* /hive/trunk/ql/src/test/queries/clientpositive/windowing_ntile.q
* /hive/trunk/ql/src/test/queries/clientpositive/windowing_rank.q
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_1.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_2.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_3.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_4.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_5.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_6.q.out
* /hive/trunk/ql/src/test/results/clientnegative/wrong_column_type.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_2.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_3.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_4.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_5.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_6.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_join.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_precision.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_serde.q.out
* /hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out
* /hive/trunk/ql/src/test/results/clientpositive/literal_decimal.q.out
* /hive/trunk/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
* /hive/trunk/ql/src/test/results/clientpositive/ptf_decimal.q.out
* /hive/trunk/ql/src/test/results/clientpositive/serde_regex.q.out
* /hive/trunk/ql/src/test/results/clientpositive/udf7.q.out
* /hive/trunk/ql/src/test/results/clientpositive/udf_pmod.q.out
* /hive/trunk/ql/src/test/results/clientpositive/udf_to_double.q.out
* /hive/trunk/ql/src/test/results/clientpositive/udf_to_float.q.out
* /hive/trunk/ql/src/test/results/clientpositive/udf_to_string.q.out
* /hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out
* /hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
* /hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out
* /hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out
* /hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/io/HiveDecimalWritable.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveDecimal.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyHiveDecimalObjectInspector.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyPrimitiveObjectInspectorFactory.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinaryHiveDecimal.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinarySerDe.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveDecimalObjectInspector.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorFactory.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableConstantHiveDecimalObjectInspector.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveDecimalObjectInspector.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/DecimalTypeInfo.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/HiveDecimalUtils.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfo.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoFactory.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoUtils.java
* /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/VarcharTypeInfo.java


> 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.10.patch, HIVE-3976.11.patch, HIVE-3976.1.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.1#6144)

Mime
View raw message