Union two Ibis tables with columns in different orders

ibis_union_different_column_order.py

import ibis
import random

con = ibis.connect("duckdb://penguins.ddb")
con.create_table(
    "penguins", ibis.examples.penguins.fetch().to_pyarrow(), overwrite = True
)

ibis.options.interactive = True

penguins = con.table("penguins")
penguins.count() # returns 344
penguins

columns = penguins.columns
random.shuffle(columns)

more_penguins = penguins[columns]
more_penguins

double_the_penguins = ibis.union(penguins, more_penguins)
double_the_penguins.count() # returns 688
double_the_penguins