Question about sqoop export - If source and destination table has columns mismatch. and destination table has non null values


#1

Hi Team,

how do i export the data from a table(source) having 2 columns and in target table with 3 columns and third column is not null in destination table.
I mean , can we generate 3rd column as dummy or null just to store in 3 column value. is it possible?

Thanks,
Digvijay