Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
MapReduce, mail # user - Re: sqoop oracle connection error


+
Krishnan Narayanan 2013-08-31, 08:35
Copy link to this message
-
Re: sqoop oracle connection error
Ram 2013-09-05, 05:07
Hi Ravi,
   Thanks for post. The problem is listener and privileges and Database
name, username and tablename are in CAPITAL Letters. here is the query.

sqoop import --connect
jdbc:oracle:thin:@//ramesh.ops.cloudwick.com/CLOUD--username RAMESH
--password password --table TEST -m 1
Here is the output.

[root@ramesh bin]# sqoop import --connect jdbc:oracle:thin:@//
ramesh.ops.cloudwick.com/CLOUD --username RAMESH --password password
--table TEST -m 1
13/09/05 10:34:20 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.

13/09/05 10:34:21 INFO manager.SqlManager: Using default fetchSize of 1000
13/09/05 10:34:21 INFO tool.CodeGenTool: Beginning code generation
13/09/05 10:34:22 INFO manager.OracleManager: Time zone has been set to GMT
13/09/05 10:34:22 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM TEST t WHERE 1=0
13/09/05 10:34:22 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is
/usr/lib/hadoop
13/09/05 10:34:22 INFO orm.CompilationManager: Found hadoop core jar at:
/usr/lib/hadoop/hadoop-core.jar
Note: /tmp/sqoop-root/compile/2633ca54b23921416d40e2bdd5141abb/TEST.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
13/09/05 10:34:24 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-root/compile/2633ca54b23921416d40e2bdd5141abb/TEST.jar
13/09/05 10:34:24 INFO manager.OracleManager: Time zone has been set to GMT
13/09/05 10:34:24 INFO manager.OracleManager: Time zone has been set to GMT
13/09/05 10:34:24 INFO mapreduce.ImportJobBase: Beginning import of TEST
13/09/05 10:34:25 INFO manager.OracleManager: Time zone has been set to GMT
13/09/05 10:34:29 INFO mapred.JobClient: Running job: job_201309051031_0001
13/09/05 10:34:30 INFO mapred.JobClient:  map 0% reduce 0%
13/09/05 10:34:44 INFO mapred.JobClient:  map 100% reduce 0%
13/09/05 10:34:46 INFO mapred.JobClient: Job complete: job_201309051031_0001
13/09/05 10:34:46 INFO mapred.JobClient: Counters: 18
13/09/05 10:34:46 INFO mapred.JobClient:   Job Counters
13/09/05 10:34:46 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=12771
13/09/05 10:34:46 INFO mapred.JobClient:     Total time spent by all
reduces waiting after reserving slots (ms)=0
13/09/05 10:34:46 INFO mapred.JobClient:     Total time spent by all maps
waiting after reserving slots (ms)=0
13/09/05 10:34:46 INFO mapred.JobClient:     Launched map tasks=1
13/09/05 10:34:46 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
13/09/05 10:34:46 INFO mapred.JobClient:   File Output Format Counters
13/09/05 10:34:46 INFO mapred.JobClient:     Bytes Written=24
13/09/05 10:34:46 INFO mapred.JobClient:   FileSystemCounters
13/09/05 10:34:46 INFO mapred.JobClient:     HDFS_BYTES_READ=87
13/09/05 10:34:46 INFO mapred.JobClient:     FILE_BYTES_WRITTEN=58070
13/09/05 10:34:46 INFO mapred.JobClient:     HDFS_BYTES_WRITTEN=24
13/09/05 10:34:46 INFO mapred.JobClient:   File Input Format Counters
13/09/05 10:34:46 INFO mapred.JobClient:     Bytes Read=0
13/09/05 10:34:46 INFO mapred.JobClient:   Map-Reduce Framework
13/09/05 10:34:46 INFO mapred.JobClient:     Map input records=6
13/09/05 10:34:46 INFO mapred.JobClient:     Physical memory (bytes)
snapshot=117080064
13/09/05 10:34:46 INFO mapred.JobClient:     Spilled Records=0
13/09/05 10:34:46 INFO mapred.JobClient:     CPU time spent (ms)=2320
13/09/05 10:34:46 INFO mapred.JobClient:     Total committed heap usage
(bytes)=105775104
13/09/05 10:34:46 INFO mapred.JobClient:     Virtual memory (bytes)
snapshot=861552640
13/09/05 10:34:46 INFO mapred.JobClient:     Map output records=6
13/09/05 10:34:46 INFO mapred.JobClient:     SPLIT_RAW_BYTES=87
13/09/05 10:34:46 INFO mapreduce.ImportJobBase: Transferred 24 bytes in
21.2419 seconds (1.1298 bytes/sec)
13/09/05 10:34:46 INFO mapreduce.ImportJobBase: Retrieved 6 records.
[root@ramesh bin]#
Hi,

From,
Ramesh.
On Sat, Aug 31, 2013 at 2:45 PM, Ravi Kiran <[EMAIL PROTECTED]>wrote:

> Hi ,
>    Can you check if you are able to ping or telnet to the ip address and