Review Board 1.7.22


Patch for SQOOP-351

Review Request #2031 - Created Sept. 23, 2011 and submitted

Kathleen Ting
SQOOP-351
Reviewers
Sqoop
aprabhakar
sqoop-trunk
Updated documentation.
Built docs and verified.

Diff revision 2 (Latest)

1 2
1 2

  1. src/docs/user/troubleshooting.txt: Loading...
src/docs/user/troubleshooting.txt
Revision b2eb5ee New Change
[20] 128 lines
[+20]
129

    
   
129

   
130
----
130
----
131
-D mapred.child.java.opts="\-Djava.security.egd=file:/dev/../dev/urandom"+
131
-D mapred.child.java.opts="\-Djava.security.egd=file:/dev/../dev/urandom"+
132
----
132
----
133

    
   
133

   

    
   
134
Oracle: Case-Sensitive Catalog Query Errors

    
   
135
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    
   
136

   

    
   
137
Problem: While working with Oracle you may encounter problems when Sqoop can

    
   
138
not figure out column names. This happens because the catalog queries that

    
   
139
Sqoop uses for Oracle expect the correct case to be specified for the

    
   
140
user name and table name.

    
   
141

   

    
   
142
One example, using --hive-import and resulting in a NullPointerException:

    
   
143

   

    
   
144
----

    
   
145
1/09/21 17:18:49 INFO manager.OracleManager: Time zone has been set to

    
   
146
GMT

    
   
147
11/09/21 17:18:49 DEBUG manager.SqlManager: Using fetchSize for next

    
   
148
query: 1000

    
   
149
11/09/21 17:18:49 INFO manager.SqlManager: Executing SQL statement:

    
   
150
SELECT t.* FROM addlabel_pris t WHERE 1=0

    
   
151
11/09/21 17:18:49 DEBUG manager.OracleManager$ConnCache: Caching

    
   
152
released connection for jdbc:oracle:thin:

    
   
153
11/09/21 17:18:49 ERROR sqoop.Sqoop: Got exception running Sqoop:

    
   
154
java.lang.NullPointerException

    
   
155
java.lang.NullPointerException

    
   
156
at com.cloudera.sqoop.hive.TableDefWriter.getCreateTableStmt(TableDefWriter.java:148)

    
   
157
at com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:187)

    
   
158
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:362)

    
   
159
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)

    
   
160
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)

    
   
161
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)

    
   
162
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)

    
   
163
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)

    
   
164
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)

    
   
165
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)

    
   
166

   

    
   
167
----

    
   
168

   

    
   
169
.Solution:

    
   
170
. Specify the user name, which Sqoop is connecting as, in upper case (unless

    
   
171
it was created with mixed/lower case within quotes).

    
   
172
. Specify the table name, which you are working with, in upper case (unless

    
   
173
it was created with mixed/lower case within quotes).
  1. src/docs/user/troubleshooting.txt: Loading...