hive show databases；报错

Question

其他都正常就使用 show databases报错

hive> 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
hive> show tables;
OK
Time taken: 1.353 seconds
hive> create database test;
OK
Time taken: 7.084 seconds
hive> use test;
OK
Time taken: 0.136 seconds
hive> show tables;
OK
Time taken: 0.121 seconds
hive> 

错误日志如下:

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

2017-09-05T08:07:52,154 ERROR [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] 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
2017-09-05T08:07:52,155  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Completed executing command(queryId=root_20170905080752_6b919743-7ff4-4cf5-aa1c-6971f8a9ed02); Time taken: 0.08 seconds
2017-09-05T08:07:52,157  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] exec.ListSinkOperator: Closing operator LIST_SINK[0]
2017-09-05T08:07:52,159  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] conf.HiveConf: Using the default value passed in for log id: 49a6d8b4-1972-4470-b11d-ab20a58dc4d2
2017-09-05T08:07:52,160  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] session.SessionState: Resetting thread name to  main
2017-09-05T08:08:14,285  INFO [main] conf.HiveConf: Using the default value passed in for log id: 49a6d8b4-1972-4470-b11d-ab20a58dc4d2
2017-09-05T08:08:14,286  INFO [main] session.SessionState: Updating thread name to 49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main
2017-09-05T08:08:14,291  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Compiling command(queryId=root_20170905080814_7e2f688e-0594-4699-bd37-afb47e7873ce): show databases
2017-09-05T08:08:14,311  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Semantic Analysis Completed
2017-09-05T08:08:14,314  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from deserializer)], properties:null)
2017-09-05T08:08:14,319  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] exec.ListSinkOperator: Initializing operator LIST_SINK[0]
2017-09-05T08:08:14,322  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Completed compiling command(queryId=root_20170905080814_7e2f688e-0594-4699-bd37-afb47e7873ce); Time taken: 0.032 seconds
2017-09-05T08:08:14,322  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Concurrency mode is disabled, not creating a lock manager
2017-09-05T08:08:14,322  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Executing command(queryId=root_20170905080814_7e2f688e-0594-4699-bd37-afb47e7873ce): show databases
2017-09-05T08:08:14,325  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Starting task [Stage-0:DDL] in serial mode
2017-09-05T08:08:14,352  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] exec.DDLTask: results : 3
2017-09-05T08:08:14,369 ERROR [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] 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:412)
    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:2515)
    at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:439)
    at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199)
    at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)
    at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2182)
    at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1838)
    at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1525)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1236)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1226)
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

2017-09-05T08:08:14,370 ERROR [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] 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
2017-09-05T08:08:14,370  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] ql.Driver: Completed executing command(queryId=root_20170905080814_7e2f688e-0594-4699-bd37-afb47e7873ce); Time taken: 0.048 seconds
2017-09-05T08:08:14,371  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] exec.ListSinkOperator: Closing operator LIST_SINK[0]
2017-09-05T08:08:14,373  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] conf.HiveConf: Using the default value passed in for log id: 49a6d8b4-1972-4470-b11d-ab20a58dc4d2
2017-09-05T08:08:14,373  INFO [49a6d8b4-1972-4470-b11d-ab20a58dc4d2 main] session.SessionState: Resetting thread name to  main

Answer 1

在hive启动时指定
export LD_LIBRARY_PATH=${HADOOP_HOME}/lib/native:${LD_LIBRARY_PATH};