sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathleen Ting <kathl...@apache.org>
Subject Re: Oraoop_Issue
Date Thu, 13 Mar 2014 22:02:27 GMT
Moving to user@sqoop.apache.org (please subscribe if you haven't
already, Kartheek).

Hi Kartheek,

As mentioned in the error message "Can't export data, please check
task tracker logs," looks like there will be more helpful debugging
information contained in attempt_201403100147_0004_m_000001_1 - can
you please post the error messages from there?

Regards,
Kate

On Wed, Mar 12, 2014 at 10:22 PM, kartheek reddy
<kartheek.srmuni@outlook.com> wrote:
>
> Hi Kathleen ,
>
>                       Greeting.
>
>                                       This is Kartheek from india. i had
> issue withe oraoop connector.while am exporting the data from hive to oracle
> database  am getting follow error ...please can u help me on this.i posted
> but no body reply me.and one more query like how can i increase my
> export/import performance by using oraoop. if any parameters i have to
> change in oraoop-site.xml.if changes required please tell me what are the
> changes i do.. here am using sqoop version is apache sqopp 1.4.3 and hadoop
> 1.1.2 .
>
> 14/03/10 02:21:46 INFO mapred.JobClient: Task Id :
> attempt_201403100147_0004_m_000001_1, Status : FAILED
> java.io.IOException: Can't export data, please check task tracker logs
>         at
> org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:112)
>         at
> org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:39)
>         at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
>         at
> org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)
>         at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)
>         at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370)
>         at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at javax.security.auth.Subject.doAs(Subject.java:415)
>         at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1149)
>         at org.apache.hadoop.mapred.Child.main(Child.java:249)
> Caused by: java.io.IOException: java.sql.SQLException:
> java.lang.NullPointerException
>         at
> org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:220)
>         at
> com.quest.oraoop.OraOopOutputFormatBase$OraOopDBRecordWriterBase.write(OraOopOutputFormatBase.java:507)
>         at
> com.quest.oraoop.OraOopOutputFormatInsert$OraOopDBRecordWriterInsert.write(OraOopOutputFormatInsert.java:94)
>         at
> com.quest.oraoop.OraOopOutputFormatBase$OraOopDBRecordWriterBase.write(OraOopOutputFormatBase.java:175)
>         at
> org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:639)
>         at
> org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
>         at
> org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:84)
>         ... 10 more
> Caused by: java.sql.SQLException: java.lang.NullPointerException
>         at
> com.quest.oraoop.OraOopOutputFormatInsert$OraOopDBRecordWriterInsert.configurePreparedStatement(OraOopOutputFormatInsert.java:228)
> sqoop export --connect jdbc:oracle:thin:@servername:1521:grasa01 --username
> TEST --password gra --table K --export-dir /user/hive/warehouse/k --columns
> 'c_id' --input-lines-terminated-by '\n'
>
>
> Thanks & Regards
> Kartheek Reddy

Mime
View raw message