Pie in the sky* is unrealistic expectations or promises (possibly made when pie-eyed which means drunk) A pie can also be a piebald (black and white) animal or bird, a chaotic mess of printers’ type or a former currency unit in India.
*Not to be confused with pie in Skye which is a picnic on a Scottish island.