Import HDFS data file into mysql

Question

I am trying to import a large HDFS file into a mysql db. The data in the file is delimiter by a '^A'. How do I tell mysql to separate each column by ctrl-A? Also, is it possible for me to specify what fields I want to import.

Mike Brant · Accepted Answer · 2013-02-07 16:10:43Z

2

See the documentation here:

http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html

You are looking for the --fields-terminated-by=string option. There is not option to only select certain fields for import, though you can use --columns=column_list to map columns in your data to fields in the table.

edited Feb 7, 2013 at 16:10

answered Feb 7, 2013 at 0:24

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Import HDFS data file into mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related