hive表insert报错
0
环境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正常了。
建了一张普通表,非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正常了。
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
MarsJ - 大数据玩家~DS 2016-07-26 回答
赞同来自:
insert into table xxx values (x1,x2...);
leilei1881 2016-07-26 回答
赞同来自: