[ https://issues.apache.org/jira/browse/HIVE-25382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Feroze Daud resolved HIVE-25382. -------------------------------- Resolution: Not A Problem > "No space left on device" error when running show database > ---------------------------------------------------------- > > Key: HIVE-25382 > URL: https://issues.apache.org/jira/browse/HIVE-25382 > Project: Hive > Issue Type: Bug > Components: Clients > Affects Versions: 2.3.2 > Reporter: Feroze Daud > Priority: Major > > We are using Hive provided by Amazon EMR. > When executing "show database" command, we are getting a "No space left on > device" exception. > {noformat} > Error running query: show databases like 'my_database' -> > java.sql.SQLException: [Amazon][HiveJDBCDriver](500051) ERROR processing > query/statement. Error Code: 1, SQL state: > org.apache.hive.service.cli.HiveSQLException: Error while processing > statement: FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. java.io.IOException: No space left on > device > at > org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:380) > at > org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:257) > at > org.apache.hive.service.cli.operation.SQLOperation.access$800(SQLOperation.java:91) > at > org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:348) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1844) > at > org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:363) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.apache.hadoop.fs.FSError: java.io.IOException: No space left > on device > at > org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:265) > at > java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) > at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) > at java.io.FilterOutputStream.close(FilterOutputStream.java:158) > at > org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:74) > at > org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:108) > at > org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:414) > at > org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:74) > at > org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:108) > at org.apache.hadoop.io.IOUtils.cleanup(IOUtils.java:251) > at org.apache.hadoop.io.IOUtils.closeStream(IOUtils.java:268) > 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:2183) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1839) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1526) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1237) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1232) > at > org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:255) > ... 11 more > Caused by: java.io.IOException: No space left on device > at java.io.FileOutputStream.writeBytes(Native Method) > at java.io.FileOutputStream.write(FileOutputStream.java:326) > at > org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:263) > ... 31 more > , Query: show databases like 'my_database'. Query: show databases like > 'my_database' Parameters: [] {noformat} > As mentioned we use Amazon EMR, and it comes with it's own Amazon HiveJdbc > client. > I am not sure if this error is happening on the client or the server. I > looked at the client and dont see any disk space issues. > > -- This message was sent by Atlassian Jira (v8.3.4#803005)