Thanks, Sidhant07 for the response. Unfortunately, the error I received (can't merge IntegerType to LongType) is the same as not using the option you suggested:

I would really like to stick with this approach rather than the INSERT INTO approach. Any other thoughts?