Schema Transaction threw exception “Add classes to Catalog “hive“, Schema “““

最新推荐文章于 2022-11-29 03:22:29 发布

梦见伊兮伊不觉

最新推荐文章于 2022-11-29 03:22:29 发布

阅读量338

点赞数

分类专栏：大数据 hive 文章标签： hive 数据库

本文链接：https://blog.csdn.net/qq_45736790/article/details/115599627

版权

在Hive中加载数据时遇到错误，根源是MySQL中hive表的字符集问题。首先，切换到dhive数据库，修改MySQL数据库设置并刷新授权。如果问题未解决，尝试新建数据库，设置特定字符集，并更新Hive配置文件`hive-site.xml`中的metastore配置。重启Hadoop和Zookeeper服务，确保正常加载数据。

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

hive数据库 load数据的时候报错,报错信息如下:

Loading data to table ods.ods_spider_invs_zhibo_detail partition (dt=2021-04-10)
Failed with exception MetaException(message:javax.jdo.JDODataStoreException: Schema Transaction threw exception "Add classes to Catalog "hive", Schema """
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
        at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
        at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
        at org.apache.hadoop.hive.metastore.ObjectStore.addPartition(ObjectStore.java:1462)
        at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:114)
        at com.sun.proxy.$Proxy2.addPartition(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.append_partition_common(HiveMetaStore.java:1935)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.append_partition_with_environment_context(HiveMetaStore.java:1990)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)
        at com.sun.

最低0.47元/天解锁文章