Add an extra column with default non-null value during import to HDFS?

We have to add an extra column with default non-null value during import to HDFS?
We have a sql table and the columns in the table are, Book_name, Auth_name, Edition,
Grade.
While importing from SQL to CSV file into HDFS with Sqoop we need to add an extra non-null column Source_n that has a default value "other" for every input record. How to do this in Sqoop? So a resulting record should have the following format:

Source_n, Book_name, Auth_name, Edition, Grade
where Source_n = "other" for every output record

Tagged:
Sign In or Register to comment.