Hi, I am using Hive 0.9.0, and not sure why the from_utc_timestamp gave me
error to the following value, but works for others.
The following example shows 2 bigint as 2 epoch value of milliseconds level.
They are only 11 seconds difference. One works fine in hive 0.9.0 with
from_utc_timestamp UDF, the others just broken. Why?
yzhang@yzhang-linux:~> hivehive> use tracking2;OKTime taken: 1.569 secondshive>
select from_utc_timestamp(1371746476159, 'EST') from track_sent;OK2013-06-20
07:41:16.3182013-06-20 07:41:16.318Time taken: 8.64 secondshive> select
from_utc_timestamp(1371746487759, 'EST') from track_sent;FAILED: Hive Internal
Error: java.lang.IllegalArgumentException(Value out of
range)java.lang.IllegalArgumentException: Value out of range at
java.sql.Timestamp.setNanos(Timestamp.java:287) at
org.apache.hadoop.hive.ql.udf.generic.GenericUDFFromUtcTimestamp.applyOffset(GenericUDFFromUtcTimestamp.java:101)
at
org.apache.hadoop.hive.ql.udf.generic.GenericUDFFromUtcTimestamp.evaluate(GenericUDFFromUtcTimestamp.java:94)
at
org.apache.hadoop.hive.ql.udf.generic.GenericUDF.initializeAndFoldConstants(GenericUDF.java:127)
at
org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc.newInstance(ExprNodeGenericFuncDesc.java:214)
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:767)
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:888)
at
org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:89)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:88)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:125)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:102)
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:165)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:7755)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:2310)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:2112)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPostGroupByBodyPlan(SemanticAnalyzer.java:6165)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:6136)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:6762)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7531)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:431) at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336) at
org.apache.hadoop.hive.ql.Driver.run(Driver.java:909) at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258) at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215) at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406) at
org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689) at
org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611) at
org.apache.hadoop.util.RunJar.main(RunJar.java:156)
