Comparing if two tables have identical content

Have you ever wanted to know if two database tables were the same? Perhaps you made some changes to a query and wanted to know if the result was still the same.

I was essentially looking for a way to diff two tables in Hive SQL, and used:
(TABLE a EXCEPT TABLE b)
UNION ALL
(TABLE b EXCEPT TABLE a);

Volunteer gardening at Cabramatta High School 🌱

I volunteered at Cabramatta High School yesterday as part of their annual Green Day. It sprinkled for about 5 minutes but the rest was overcast. Perfect for gardening! Students from their Environ Club also helped out. All up the school has 1.5k students and they also have an Intensive English Centre which includes students which are migrants, refugees, and international students.

My group helped weed and mulch their Peace Garden:

I’m most proud of this area. We weeded, pruned, and mulched this section:

The clouds started looking ominous which also meant the photos look a bit dark ☹

We mulched both these areas:

Which involved some ingenious ways of moving mulch:

We also had a trailer which was moved BY HAND, by their teacher. He then proceeded to pull the trailer back to the mulch stash with about 10 kids at the back.

It was a great day and I learnt some neat gardening tricks!