You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chaoyu Tang (JIRA)" <ji...@apache.org> on 2015/04/07 00:38:12 UTC
[jira] [Created] (HIVE-10231) Compute partition column stats fails
if partition col type is date
Chaoyu Tang created HIVE-10231:
----------------------------------
Summary: Compute partition column stats fails if partition col type is date
Key: HIVE-10231
URL: https://issues.apache.org/jira/browse/HIVE-10231
Project: Hive
Issue Type: Bug
Components: Statistics
Affects Versions: 1.0.0
Reporter: Chaoyu Tang
Assignee: Chaoyu Tang
Fix For: 1.2.0
Currently the command "analyze table .. partition .. compute statistics for columns" may only work for partition column type of string, numeric types, but not others like date. See following case using date as partition coltype:
{code}
create table colstatspartdate (key int, value string) partitioned by (ds date, hr int);
insert into colstatspartdate partition (ds=date '2015-04-02', hr=2) select key, value from src limit 20;
analyze table colstatspartdate partition (ds=date '2015-04-02', hr=2) compute statistics for columns;
{code}
you will get RuntimeException:
{code}
FAILED: RuntimeException Cannot convert to Date from: int
15/04/06 17:30:01 ERROR ql.Driver: FAILED: RuntimeException Cannot convert to Date from: int
java.lang.RuntimeException: Cannot convert to Date from: int
at org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorUtils.getDate(PrimitiveObjectInspectorUtils.java:1048)
at org.apache.hadoop.hive.serde2.objectinspector.primitive.PrimitiveObjectInspectorConverter$DateConverter.convert(PrimitiveObjectInspectorConverter.java:264)
at org.apache.hadoop.hive.ql.optimizer.ConstantPropagateProcFactory.typeCast(ConstantPropagateProcFactory.java:163)
at org.apache.hadoop.hive.ql.optimizer.ConstantPropagateProcFactory.propagate(ConstantPropagateProcFactory.java:333)
at org.apache.hadoop.hive.ql.optimizer.ConstantPropagateProcFactory.foldExpr(ConstantPropagateProcFactory.java:242)
....
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)