hive java insert_hive表insert报错

环境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正常了。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值