You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "KIRTI RUGE (Jira)" <ji...@apache.org> on 2022/12/15 08:28:00 UTC
[jira] [Commented] (HIVE-26844) hive 执行 insert overwrite 中带有 GET_JSON_OBJECT 报NoClassDefFoundError: org/codehaus/jackson/annotate/JsonClass问题
[ https://issues.apache.org/jira/browse/HIVE-26844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17647916#comment-17647916 ]
KIRTI RUGE commented on HIVE-26844:
-----------------------------------
Is it reproducible in HIVE 4.0.0?
> hive 执行 insert overwrite 中带有 GET_JSON_OBJECT 报NoClassDefFoundError: org/codehaus/jackson/annotate/JsonClass问题
> -------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-26844
> URL: https://issues.apache.org/jira/browse/HIVE-26844
> Project: Hive
> Issue Type: Bug
> Environment: hive版本：2.3.7
> hadoop版本：2.7.2
> Reporter: yutiantian
> Priority: Major
>
> hive版本：2.3.7
> hadoop版本：2.7.2
> 通过hive 执行 INSERT OVERWRITE TABLE test.test_temp PARTITION(dt = '2021-07-01') SELECT null AS local_time,null AS local_date,TRIM(GET_JSON_OBJECT(request_body, '$.app_version')) AS app_version FROM test.test_ods_checklog WHERE dt = '2021-07-01' limit 1;
> 会报如下错误：
> Caused by: java.lang.NoClassDefFoundError: org/codehaus/jackson/annotate/JsonClass
> at org.codehaus.jackson.map.introspect.JacksonAnnotationIntrospector.findDeserializationType(JacksonAnnotationIntrospector.java:524)
> at org.codehaus.jackson.map.deser.BasicDeserializerFactory.modifyTypeByAnnotation(BasicDeserializerFactory.java:732)
> at org.codehaus.jackson.map.deser.BasicDeserializerFactory.createMapDeserializer(BasicDeserializerFactory.java:337)
> at org.codehaus.jackson.map.deser.StdDeserializerProvider._createDeserializer(StdDeserializerProvider.java:377)
> at org.codehaus.jackson.map.deser.StdDeserializerProvider._createAndCache2(StdDeserializerProvider.java:307)
> at org.codehaus.jackson.map.deser.StdDeserializerProvider._createAndCacheValueDeserializer(StdDeserializerProvider.java:287)
> at org.codehaus.jackson.map.deser.StdDeserializerProvider.findValueDeserializer(StdDeserializerProvider.java:136)
> at org.codehaus.jackson.map.deser.StdDeserializerProvider.findTypedValueDeserializer(StdDeserializerProvider.java:157)
> at org.codehaus.jackson.map.ObjectMapper._findRootDeserializer(ObjectMapper.java:2468)
> at org.codehaus.jackson.map.ObjectMapper._readMapAndClose(ObjectMapper.java:2402)
> at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:1616)
> at org.apache.hadoop.hive.ql.udf.UDFJson.evaluate(UDFJson.java:170)
> ... 27 more
> 但是，单独执行 SELECT null AS local_time,null AS local_date,TRIM(GET_JSON_OBJECT(request_body, '$.app_version')) AS app_version FROM test.test_ods_checklog WHERE dt = '2021-07-01' limit 1; 可以正常执行。
> 请问，这是哪里的问题呢，感谢回复。
--
This message was sent by Atlassian Jira
(v8.20.10#820010)