Details
-
Type:
Improvement
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 1.1.0
-
Fix Version/s: None
-
Component/s: import
-
Labels:None
-
Environment:Relates to a Sqoop import for an Oracle table
Description
(1) Create an oracle table, such as...
create table customers ("first name" varchar2(50), id number);
insert into customers ("first name", id) values ("Guy", 1);
commit;
(2) Attempt to perform a Sqoop import of this table's data using the "columns" clause...
sqoop import ... --table customers --columns "\"\"first name\"\""
10/09/01 14:20:48 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at com.cloudera.sqoop.orm.ClassWriter.generateFields(ClassWriter.java:431)
at com.cloudera.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1102)
at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:974)
at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:329)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:415)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:134)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:170)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:196)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:205)
-------------------------------------------------------------
During generateFields(), the following line fails...
int sqlType = columnTypes.get(col);
This fails because col is (including the quotes)...
"col1 with spaces"
...while the column name in the map is...
col1 with spaces