Re: Export hive table format issue

[Hamza Asad]

im executing following command*
sqoop export --connect jdbc:mysql://localhost/xxxx --table
dump_hive_events_details --export-dir hive/warehouse/xxxx.db/events_details
--input-null-non-string \N --input-fields-terminated-by '#' --username
xxxxxxxx --password xxxxxxxxx*
*
13/06/18 16:26:44 INFO mapred.JobClient: Task Id :
attempt_201306170658_0106_m_000001_0, Status : FAILED
java.lang.NumberFormatException: For input string:
"8119844
1
4472499
2013-01-29
00:00:00.0
1
4
1
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
8
\N
\N
\N
\N
\N
1
\N
\N
3
2
\N
1"
    at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:492)
    at java.lang.Integer.valueOf(Integer.java:582)
    at
dump_hive_events_details.__loadFromFields(dump_hive_events_details.java:949)
    at dump_hive_events_details.parse(dump_hive_events_details.java:901)
    at
org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:77)
    at
org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:36)
    at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
    at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
    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:1121)
    at org.apache.hadoop.mapred.Child.main(Child.java:249)
*


On Tue, Jun 18, 2013 at 4:07 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote:

> check the option --input-fields-terminated-by in sqoop export
>
>
> On Tue, Jun 18, 2013 at 4:31 PM, Hamza Asad <hamza.asa...@gmail.com>wrote:
>
>> I want to export my table in mysql and for that i'm using sqoop export
>> command but in HDFS i've data apparantly without any field seperator But it
>> does contain some field separator. data is saved in the format as shown
>> below
>> *8119844 1 4472499 2013-01-29 00:00:00.0 1 4 1 \N \N \N \N \N \N \N \N
>> \N \N 8 \N \N \N \N \N 1 \N \N 3 2 \N 1*
>> how can i export this type of data to mysql and what field separator i
>> mention it there.. Please help
>>
>> --
>> *Muhammad Hamza Asad*
>>
>
>
>
> --
> Nitin Pawar
>



-- 
*Muhammad Hamza Asad*