It's derived from the Spanish word "piñata," which itself likely comes from the Italian word "pignatta," meaning "pot."
