How to add a Spark Dataframe to the bottom of another dataframe?

Question

I can use withcolumnto add new columns to a Dataframe. But in scala how can I add new rows to a DataFrame?

I'm trying to add a dataframe to the bottom of another one. So either how to add rows in scala or how to add a DataFrame to the bottom of another one will help. Thanks

Answer 1

If they have the same schema, simply use union for spark 2+:

val dfUnion = df1.union(df2) 

Or unionAll for spark 1+:

val dfUnion = df1.unionAll(df2)