Hello! Please advise on how to use Sqoop for the following task: I need to periodically import data from MySQL table to Hive. Records in Hive table should have an additional 'timestamp' field to contain import time. As I understand, I can first create table in Hive with all necessary fields including 'timestamp' and then import data into this empty table. Questions: 1) What value Sqoop will put into fields not existing in the input table, such as 'timetamp' ? 2) Is there any way to ask Sqoop put current time into 'timestamp' field at actual import time?
Thanks!
