From user-return-1781-apmail-sqoop-user-archive=sqoop.apache.org@sqoop.apache.org Thu Oct 17 12:25:05 2013 Return-Path: X-Original-To: apmail-sqoop-user-archive@www.apache.org Delivered-To: apmail-sqoop-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6086C10C59 for ; Thu, 17 Oct 2013 12:25:05 +0000 (UTC) Received: (qmail 81765 invoked by uid 500); 17 Oct 2013 12:25:05 -0000 Delivered-To: apmail-sqoop-user-archive@sqoop.apache.org Received: (qmail 81693 invoked by uid 500); 17 Oct 2013 12:25:00 -0000 Mailing-List: contact user-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@sqoop.apache.org Delivered-To: mailing list user@sqoop.apache.org Received: (qmail 81683 invoked by uid 99); 17 Oct 2013 12:24:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Oct 2013 12:24:58 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rkreddyhadoop@gmail.com designates 209.85.212.193 as permitted sender) Received: from [209.85.212.193] (HELO mail-wi0-f193.google.com) (209.85.212.193) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Oct 2013 12:24:53 +0000 Received: by mail-wi0-f193.google.com with SMTP id cb5so534046wib.0 for ; Thu, 17 Oct 2013 05:24:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=wZeOkj+JkWAyD+AwbVrPAaUdePHs2+lBoy5HVFjK+Sg=; b=S0Bf12m960YQn/nY7+20Vv+q0htpKx4CcCGIYsTsDIQgHGROihxP5+XQXX83HzAKBC zTINTzymG5JIsm9INXgW0E8sSdAVZxJnrHDIatWv/I21HRd8ZB4yNMu+KmcFK3sXCrgw Een/gcngfNcZDTJJUY11sTjWEzS8EOZHbNaeBHktsuvI945PAlgnMa2Z4pe2UJ/p8Wvl Nr/BbeDbn2nqYfuGhZ6Oy3HhWpURujY7S74Lz1Rw2tuL6mmnx4O/I5Yd29w78M6t3e57 mwstRq9MC4Cc377pZWkt0aRFOpX3CyZsiaMKwqWfkCE5xz734qks5fIf3w8PURUvP1Yd d+WA== MIME-Version: 1.0 X-Received: by 10.194.122.168 with SMTP id lt8mr344226wjb.76.1382012672659; Thu, 17 Oct 2013 05:24:32 -0700 (PDT) Received: by 10.194.158.38 with HTTP; Thu, 17 Oct 2013 05:24:32 -0700 (PDT) Date: Thu, 17 Oct 2013 17:54:32 +0530 Message-ID: Subject: Sqoop Import fails (Sybase to Hive) From: RK Reddy To: user@sqoop.apache.org Content-Type: multipart/alternative; boundary=089e011777af6dd95604e8eee636 X-Virus-Checked: Checked by ClamAV on apache.org --089e011777af6dd95604e8eee636 Content-Type: text/plain; charset=ISO-8859-1 Hello all, I am trying to import data from sybase to hive using sqoop, Sqoop has successfully imported some of tables but the table which is huge its gets fail while importing and shows error. ERROR: 12/10/17 03:45:08 INFO mapred.JobClient: map 0% reduce 0% 12/10/17 03:45:17 INFO mapred.JobClient: map 25% reduce 0% 12/10/17 03:46:15 INFO mapred.JobClient: Task Id : attempt_20131 Status : FAILED on node AAA java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s). Please suggest why is it so and how to solve it Thanks & Regards R. K. Reddy --089e011777af6dd95604e8eee636 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello all,
=A0
I am trying to import data from sybase to hive using s= qoop,
=A0
Sqoop has successfully imported some of tables but the tabl= e which is huge its gets fail while importing and shows error.
=A0
ER= ROR:
=A0
12/10/17 03:45:08 INFO mapred.JobClient:=A0 map 0% reduce 0%
12/1= 0/17 03:45:17 INFO mapred.JobClient:=A0 map 25% reduce 0%
12/10/17 03:46= :15 INFO mapred.JobClient: Task Id : attempt_20131 Status : FAILED on node = AAA=A0 java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQL= Exception: JZ00L: Login failed.=A0 Examine the SQLWarnings chained to this = exception for the reason(s).
=A0
=A0
Please suggest why is it so and how to solve it
=A0
Tha= nks & Regards
R. K. Reddy=20 --089e011777af6dd95604e8eee636--