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正常了。
 
 
已邀请:
0

MarsJ - 大数据玩家~DS 2016-07-26 回答

直接插入值的语句是:
insert into table xxx values (x1,x2...);
0

leilei1881 2016-07-26 回答

就是用的直接插入语句:insert into temp.monitor_test values ('20160722153748','XXX','XXX','XXX','2016-07-22','0','20160722');

要回复问题请先登录注册