hive show databases 报错

0
hive (default)> show databases;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.util.NativeCrc32.nativeComputeChunkedSumsByteArray(II[BI[BIILjava/lang/String;JZ)V

下边是debug日志
 
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=Driver.run from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=TimeToSubmit from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=compile from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: DEBUG parse.VariableSubstitution: Substitution is on: show databases
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO parse.ParseDriver: Parsing command: show databases
16/09/28 23:51:26 [main]: INFO parse.ParseDriver: Parse Completed
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=parse start=1475121086074 end=1475121086075 duration=1 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: DEBUG ql.Driver: Encoding valid txns info 9223372036854775807:
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO ql.Driver: Semantic Analysis Completed
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=semanticAnalyze start=1475121086076 end=1475121086082 duration=6 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[database_name] columnTypes=[string] separator=[[B@2b98744] nullstring=  lastColumnTakesRest=false timestampFormats=null
16/09/28 23:51:26 [main]: INFO exec.ListSinkOperator: Initializing operator OP[0]
16/09/28 23:51:26 [main]: DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.DelimitedJSONSerDe initialized with: columnNames= columnTypes= separator=[[B@625f82c1] nullstring=  lastColumnTakesRest=false timestampFormats=null
16/09/28 23:51:26 [main]: INFO exec.ListSinkOperator: Initialization Done 0 OP
16/09/28 23:51:26 [main]: INFO exec.ListSinkOperator: Operator 0 OP initialized
16/09/28 23:51:26 [main]: DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[database_name] columnTypes=[string] separator=[[B@6c817f5b] nullstring=  lastColumnTakesRest=false timestampFormats=null
16/09/28 23:51:26 [main]: INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from deserializer)], properties:null)
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=compile start=1475121086070 end=1475121086096 duration=26 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO metadata.Hive: Dumping metastore api call timing information for : compilation phase
16/09/28 23:51:26 [main]: DEBUG metadata.Hive: Total time spent in each metastore function (ms): {isCompatibleWith_(HiveConf, )=4}
16/09/28 23:51:26 [main]: INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=Driver.execute from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO ql.Driver: Starting command(queryId=root_20160928235126_82fea7b5-4194-4af2-89d9-03d23ad8c772): show databases
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=TimeToSubmit start=1475121086070 end=1475121086099 duration=29 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=runTasks from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=task.DDL.Stage-0 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO ql.Driver: Starting task [Stage-0:DDL] in serial mode
16/09/28 23:51:26 [main]: INFO exec.DDLTask: results : 1
16/09/28 23:51:26 [main]: ERROR exec.DDLTask: java.lang.UnsatisfiedLinkError: org.apache.hadoop.util.NativeCrc32.nativeComputeChunkedSumsByteArray(II[BI[BIILjava/lang/String;JZ)V
        at org.apache.hadoop.util.NativeCrc32.nativeComputeChunkedSumsByteArray(Native Method)
        at org.apache.hadoop.util.NativeCrc32.calculateChunkedSumsByteArray(NativeCrc32.java:86)
        at org.apache.hadoop.util.DataChecksum.calculateChunkedSums(DataChecksum.java:430)
        at org.apache.hadoop.fs.FSOutputSummer.writeChecksumChunks(FSOutputSummer.java:202)
        at org.apache.hadoop.fs.FSOutputSummer.flushBuffer(FSOutputSummer.java:163)
        at org.apache.hadoop.fs.FSOutputSummer.flushBuffer(FSOutputSummer.java:144)
        at org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:407)
        at org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:72)
        at org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:106)
        at org.apache.hadoop.io.IOUtils.cleanup(IOUtils.java:244)
        at org.apache.hadoop.io.IOUtils.closeStream(IOUtils.java:261)
        at org.apache.hadoop.hive.ql.exec.DDLTask.showDatabases(DDLTask.java:2240)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:385)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160)
        at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:88)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1653)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1412)
        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1195)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1059)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1049)
        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:213)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:165)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:376)
        at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:736)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.util.NativeCrc32.nativeComputeChunkedSumsByteArray(II[BI[BIILjava/lang/String;JZ)V
16/09/28 23:51:26 [main]: ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.util.NativeCrc32.nativeComputeChunkedSumsByteArray(II[BI[BIILjava/lang/String;JZ)V
16/09/28 23:51:26 [main]: DEBUG ql.Driver: Shutting down query show databases
16/09/28 23:51:26 [main]: INFO metadata.Hive: Dumping metastore api call timing information for : execution phase
16/09/28 23:51:26 [main]: DEBUG metadata.Hive: Total time spent in each metastore function (ms): {isCompatibleWith_(HiveConf, )=5, getAllDatabases_()=23}
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=Driver.execute start=1475121086098 end=1475121086134 duration=36 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=releaseLocks start=1475121086135 end=1475121086135 duration=0 from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO exec.ListSinkOperator: 0 finished. closing...
16/09/28 23:51:26 [main]: INFO exec.ListSinkOperator: 0 Close done
16/09/28 23:51:26 [main]: DEBUG ql.Driver: Shutting down query show databases
16/09/28 23:51:26 [main]: INFO log.PerfLogger: <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
16/09/28 23:51:26 [main]: INFO log.PerfLogger: </PERFLOG method=releaseLocks start=1475121086139 end=1475121086139 duration=0 from=org.apache.hadoop.hive.ql.Driver>
已邀请:
0

abczhangkai 2016-09-29 回答

都启动了就是不行,show tables 可以,但是建完测试表以后就报和show databases一样的错误,找了几天也没解决。
我用的版本 apache-hive-1.2.1-bin mysql-5.7.15-linux-glibc2.5-x86_64 hadoop-2.7.2
0

MarsJ - 大数据玩家~DS 2016-09-29 回答

HDFS正常启动了吗?Metastore的服务起来吗?
0

那个人 2018-10-27 回答

在hive主节点执行:
hive --service metastore &
如果包1.png中的异常,则杀掉该进程重新执行上面的命令
netstat -anp|grep 9083|grep LISTEN
pwdx |grep pid
 

要回复问题请先登录注册