hive java insert_hive表insert报错
发布日期:2021-06-24 10:48:21 浏览次数:4 分类:技术文章

本文共 3762 字,大约阅读时间需要 12 分钟。

环境hive1,Linux6.5,平台是星环的Hadoop4.3

建了一张普通表,非ORC表,insert时报错,具体如下:

insert into temp.monitor_test values ('20160722153748','XXX','XXX','XXX','2016-07-22','0','20160722');

报错为:

[Hive Error]: Query returned non-zero code: 10, cause: FAILED: Error in semantic analysis: Only allow to single insert into Hyperbase/Transaction Orc/Holodesk, other data destination not allowed。

而且报错完后,再去查看其它正常表,报错:[Hive Error]: java.lang.Exception: Cannot enable local mode, please "set ngmr.exec.mode=cluster" to close it.

java.io.IOException: java.lang.Exception: Cannot enable local mode, please "set ngmr.exec.mode=cluster" to close it.

at io.transwarp.inceptor.execution.task.HyperbaseIteratableFetchTask.fetch(HyperbaseIteratableFetchTask.scala:254)

at org.apache.hadoop.hive.ql.Driver.getResultsInternal(Driver.java:2510)

at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2487)

at io.transwarp.inceptor.InceptorDriver.getResults(InceptorDriver.scala:205)

at io.transwarp.inceptor.InceptorServerHandler.fetchN(InceptorServer.scala:561)

at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:1192)

at org.apache.hadoop.hive.service.ThriftHive$Processor$fetchN.getResult(ThriftHive.java:1176)

at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)

at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.lang.Exception: Cannot enable local mode, please "set ngmr.exec.mode=cluster" to close it.

at io.transwarp.inceptor.execution.TableScanOperator.execute(TableScanOperator.scala:614)

at io.transwarp.inceptor.execution.Operator$$anonfun$executeParents$1.apply(Operator.scala:262)

at io.transwarp.inceptor.execution.Operator$$anonfun$executeParents$1.apply(Operator.scala:262)

at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)

at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)

at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)

at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)

at scala.collection.TraversableLike$class.map(TraversableLike.scala:244)

at scala.collection.AbstractTraversable.map(Traversable.scala:105)

at io.transwarp.inceptor.execution.Operator.executeParents(Operator.scala:262)

at io.transwarp.inceptor.execution.UnaryOperator.execute(Operator.scala:455)

at io.transwarp.inceptor.execution.Operator$$anonfun$executeParents$1.apply(Operator.scala:262)

at io.transwarp.inceptor.execution.Operator$$anonfun$executeParents$1.apply(Operator.scala:262)

at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)

at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)

at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)

at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)

at scala.collection.TraversableLike$class.map(TraversableLike.scala:244)

at scala.collection.AbstractTraversable.map(Traversable.scala:105)

at io.transwarp.inceptor.execution.Operator.executeParents(Operator.scala:262)

at io.transwarp.inceptor.execution.FileSinkOperator.execute(FileSinkOperator.scala:174)

at io.transwarp.inceptor.execution.task.HyperbaseIteratableFetchTask.initIterator(HyperbaseIteratableFetchTask.scala:107)

at io.transwarp.inceptor.execution.task.HyperbaseIteratableFetchTask.fetch(HyperbaseIteratableFetchTask.scala:230)

... 12 more

去运行下:set ngmr.exec.mode=cluster,hive正常了。

转载地址:https://blog.csdn.net/weixin_32290249/article/details/114995962 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:java 调试dll jna_Java调用dll的实现,JNA框架 | 学步园
下一篇:golang mongodb mysql_分享一个golang+mongodb+vuejs开发的博客程序 gocms

发表评论

最新留言

路过按个爪印,很不错,赞一个!
[***.219.124.196]2024年04月08日 22时20分48秒