hive报错信息

meina6

已于 2024-03-28 15:32:38 修改

阅读量385

点赞数 7

文章标签： hive hadoop 数据仓库

于 2024-01-31 15:36:49 首次发布

本文链接：https://blog.csdn.net/meina2/article/details/135954977

版权

文章描述了在Hive2环境下遇到的初始化错误，涉及LazyTimestampObjectInspector，建议使用Spark或Tez执行引擎替代过时的Hive-on-MR，还提及了JodaTime库在处理时间戳时的异常情况。

摘要由CSDN通过智能技术生成

meinaliu@meinadeMacBook-Pro ~ % hive

Logging initialized using configuration in jar:file:/Users/meinaliu/Desktop/fool/apache-hive-2.3.7-bin/lib/hive-common-2.3.7.jar!/hive-log4j2.properties Async: true

Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.

hive> show databases;

Exception in thread "main" java.lang.ExceptionInInitializerError

at org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyTimestampObjectInspector.<init>(LazyTimestampObjectInspector.java:38)

at org.apache.hadoop.hive.serde2.lazy.objectinspector.primitive.LazyPrimitiveObjectInspectorFactory.<clinit>(LazyPrimitiveObjectInspectorFactory.java:72)

at org.apache.hadoop.hive.serde2.lazy.LazyFactory.createLazyObjectInspector(LazyFactory.java:327)

at org.apache.hadoop.hive.serde2.lazy.LazyFactory.createLazyStructInspector(LazyFactory.java:434)

at org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:119)

at org.apache.hadoop.hive.serde2.AbstractSerDe.initialize(AbstractSerDe.java:54)

at org.apache.hadoop.hive.serde2.SerDeUtils.initializeSerDe(SerDeUtils.java:533)

at org.apache.hadoop.hive.ql.plan.TableDesc.getDeserializer(TableDesc.java:104)

at org.apache.hadoop.hive.ql.plan.TableDesc.getDeserializer(TableDesc.java:95)

at org.apache.hadoop.hive.ql.Driver.getSchema(Driver.java:277)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:530)

at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1317)

at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1457)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1227)

at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233)

at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184)

at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)

at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)

at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.hadoop.util.RunJar.run(RunJar.java:244)

at org.apache.hadoop.util.RunJar.main(RunJar.java:158)

Caused by: org.joda.time.IllegalInstantException: Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1970-01-01T00:00:00.000 (America/Hermosillo)

at org.joda.time.chrono.ZonedChronology.localToUTC(ZonedChronology.java:143)

at org.joda.time.chrono.ZonedChronology.getDateTimeMillis(ZonedChronology.java:118)

at org.joda.time.chrono.AssembledChronology.getDateTimeMillis(AssembledChronology.java:133)

at org.joda.time.base.BaseDateTime.<init>(BaseDateTime.java:258)

at org.joda.time.base.BaseDateTime.<init>(BaseDateTime.java:199)

at org.joda.time.DateTime.<init>(DateTime.java:476)

at org.apache.hive.common.util.TimestampParser.<clinit>(TimestampParser.java:49)