while creating Widget table in mysql getting the below error
ERROR 3 (HY000): Error writing file ‘./sqoopex/widgets.frm’ (Errcode: 28 - No space left on device)
I tried to import other table(categories) which are present in sqoopex using sqoop import command but there i am getting below error
-bash-4.2$ sqoop import --connect jdbc:mysql://cxln2.c.thelab-240901.internal/sqoopex --table categories --username sqoopuser --password NHkkP876rp
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/accumulo/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See SLF4J Error Codes for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
21/06/03 17:35:15 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.2.0-205
21/06/03 17:35:15 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
21/06/03 17:35:15 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
21/06/03 17:35:15 INFO tool.CodeGenTool: Beginning code generation
21/06/03 17:35:16 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM categories AS t LIMIT 1
21/06/03 17:35:16 ERROR manager.CatalogQueryManager: Failed to list columns from query: SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SC
HEMA = (SELECT SCHEMA()) AND TABLE_NAME = ‘categories’
java.sql.SQLException: Got error 28 from storage engine
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1614)
at org.apache.sqoop.manager.CatalogQueryManager.getColumnNames(CatalogQueryManager.java:150)
at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1808)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1662)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)