hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kumar Jayapal <kjayapa...@gmail.com>
Subject Re: YARN Exceptions
Date Sat, 25 Apr 2015 14:40:08 GMT
Yes Here is the complete log and sqoop import command to get the data from
oracle.

[root@sqpcdh01094p001 ~]# sqoop import  --connect "
jdbc:oracle:thin:@lorct101094t01a.qat.np.costco.com:1521/CT1" --username
"edhdtaesvc" --password "xxxxxxxx" --table "SAPSR3.AUSP"  --target-dir
"/data/crmdq/CT1" --table "SAPSR3.AUSP" --split-by PARTNER_GUID
--as-avrodatafile --compression-codec
org.apache.hadoop.io.compress.SnappyCodec --m 1

Warning:
/opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p654.326/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/04/25 13:37:19 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.3.2
15/04/25 13:37:19 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
15/04/25 13:37:20 INFO oracle.OraOopManagerFactory: Data Connector for
Oracle and Hadoop is disabled.
15/04/25 13:37:20 INFO manager.SqlManager: Using default fetchSize of 1000
15/04/25 13:37:20 INFO tool.CodeGenTool: Beginning code generation
15/04/25 13:37:20 INFO manager.OracleManager: Time zone has been set to GMT
15/04/25 13:37:20 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM SAPSR3.AUSP t WHERE 1=0
15/04/25 13:37:20 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is
/opt/cloudera/parcels/CDH/lib/hadoop-mapreduce
Note:
/tmp/sqoop-root/compile/dbe5b6d69507ee60c249062c54813557/SAPSR3_AUSP.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
15/04/25 13:37:22 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-root/compile/dbe5b6d69507ee60c249062c54813557/SAPSR3.AUSP.jar
15/04/25 13:37:22 INFO mapreduce.ImportJobBase: Beginning import of
SAPSR3.AUSP
15/04/25 13:37:22 INFO Configuration.deprecation: mapred.jar is deprecated.
Instead, use mapreduce.job.jar
15/04/25 13:37:22 INFO manager.OracleManager: Time zone has been set to GMT
15/04/25 13:37:23 INFO manager.OracleManager: Time zone has been set to GMT
15/04/25 13:37:23 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM SAPSR3.AUSP t WHERE 1=0
15/04/25 13:37:23 INFO mapreduce.DataDrivenImportJob: Writing Avro schema
file:
/tmp/sqoop-root/compile/dbe5b6d69507ee60c249062c54813557/sqoop_import_SAPSR3_AUSP.avsc
15/04/25 13:37:23 INFO Configuration.deprecation: mapred.map.tasks is
deprecated. Instead, use mapreduce.job.maps
15/04/25 13:37:23 INFO hdfs.DFSClient: Created HDFS_DELEGATION_TOKEN token
14047 for edhdtaesvc on ha-hdfs:nameservice1
15/04/25 13:37:23 ERROR hdfs.KeyProviderCache: Could not find uri with key
[dfs.encryption.key.provider.uri] to create a keyProvider !!
15/04/25 13:37:23 INFO security.TokenCache: Got dt for hdfs://nameservice1;
Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:nameservice1, Ident:
(HDFS_DELEGATION_TOKEN token 14047 for edhdtaesvc)
15/04/25 13:37:23 ERROR hdfs.KeyProviderCache: Could not find uri with key
[dfs.encryption.key.provider.uri] to create a keyProvider !!
15/04/25 13:37:23 ERROR hdfs.KeyProviderCache: Could not find uri with key
[dfs.encryption.key.provider.uri] to create a keyProvider !!
15/04/25 13:37:25 ERROR hdfs.KeyProviderCache: Could not find uri with key
[dfs.encryption.key.provider.uri] to create a keyProvider !!
15/04/25 13:37:25 INFO db.DBInputFormat: Using read commited transaction
isolation
15/04/25 13:37:25 INFO mapreduce.JobSubmitter: number of splits:1
15/04/25 13:37:26 INFO mapreduce.JobSubmitter: Submitting tokens for job:
job_1429968417065_0004
15/04/25 13:37:26 INFO mapreduce.JobSubmitter: Kind: HDFS_DELEGATION_TOKEN,
Service: ha-hdfs:nameservice1, Ident: (HDFS_DELEGATION_TOKEN token 14047
for edhdtaesvc)
15/04/25 13:37:26 INFO impl.YarnClientImpl: Submitted application
application_1429968417065_0004
15/04/25 13:37:26 INFO mapreduce.Job: The url to track the job:
http://yrncdh01094p001.corp.costco.com:8088/proxy/application_1429968417065_0004/
15/04/25 13:37:26 INFO mapreduce.Job: Running job: job_1429968417065_0004
15/04/25 13:37:40 INFO mapreduce.Job: Job job_1429968417065_0004 running in
uber mode : false
15/04/25 13:37:40 INFO mapreduce.Job:  map 0% reduce 0%
15/04/25 13:37:40 INFO mapreduce.Job: Job job_1429968417065_0004 failed
with state FAILED due to: Application application_1429968417065_0004 failed
2 times due to AM Container for appattempt_1429968417065_0004_000002 exited
with  exitCode: -1000 due to: Application application_1429968417065_0004
initialization failed (exitCode=255) with output: User edhdtaesvc not found

.Failing this attempt.. Failing the application.
15/04/25 13:37:40 INFO mapreduce.Job: Counters: 0
15/04/25 13:37:40 WARN mapreduce.Counters: Group FileSystemCounters is
deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
15/04/25 13:37:40 INFO mapreduce.ImportJobBase: Transferred 0 bytes in
17.5273 seconds (0 bytes/sec)
15/04/25 13:37:40 WARN mapreduce.Counters: Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
15/04/25 13:37:40 INFO mapreduce.ImportJobBase: Retrieved 0 records.
15/04/25 13:37:40 ERROR tool.ImportTool: Error during import: Import job
failed!

thanks
Sajid

On Fri, Apr 24, 2015 at 10:52 PM, Jagat Singh <jagatsingh@gmail.com> wrote:

> What is this error
>
> User edhdtaesvc not found
>
> Are you using any user with that name ?
>
>
>
> On Sat, Apr 25, 2015 at 3:21 PM, Kumar Jayapal <kjayapal17@gmail.com>
> wrote:
>
>> Hi,
>>
>> I am getting the following error while running sqoop import script.
>>
>> can any one please help in resolving this issue.
>>
>>
>>
>> 15/04/25 03:12:34 INFO mapreduce.Job: Running job: job_1429930456969_0006
>> 15/04/25 03:12:48 INFO mapreduce.Job: Job job_1429930456969_0006 running
>> in uber mode : false
>> 15/04/25 03:12:48 INFO mapreduce.Job:  map 0% reduce 0%
>> 15/04/25 03:12:48 INFO mapreduce.Job: Job job_1429930456969_0006 failed
>> with state FAILED due to: Application application_1429930456969_0006 failed
>> 2 times due to AM Container for appattempt_1429930456969_0006_000002 exited
>> with  exitCode: -1000 due to: Application application_1429930456969_0006
>> initialization failed (exitCode=255) with output: User edhdtaesvc not found
>>
>> .Failing this attempt.. Failing the application.
>> 15/04/25 03:12:48 INFO mapreduce.Job: Counters: 0
>> 15/04/25 03:12:48 WARN mapreduce.Counters: Group FileSystemCounters is
>> deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
>> 15/04/25 03:12:48 INFO mapreduce.ImportJobBase: Transferred 0 bytes in
>> 72.8944 seconds (0 bytes/sec)
>> 15/04/25 03:12:48 WARN mapreduce.Counters: Group
>> org.apache.hadoop.mapred.Task$Counter is deprecated. Use
>> org.apache.hadoop.mapreduce.TaskCounter instead
>> 15/04/25 03:12:48 INFO mapreduce.ImportJobBase: Retrieved 0 records.
>> 15/04/25 03:12:48 ERROR tool.ImportTool: Error during import: Import job
>> failed!
>>
>> Thanks
>> Kumar
>>
>>
>

Mime
View raw message