"A quick Google search told us that our friend U+FEFF was called a ZERO WIDTH NO-BREAK SPACE. Also, a quick trip to Wikipedia told us about the actual uses for U+FEFF, more commonly known as Byte order mark or BOM."
"The ALL and DISTINCT options specify whether duplicate rows should be returned.", "DISTINCT specifies removal of duplicate rows from the result set. Note, Hive supports SELECT DISTINCT * starting in release 1.1.0 (HIVE-9194)."
PhotoKit | Apple Developer Documentation "Work with image and video assets managed by the Photos app, including those from iCloud Photos and Live Photos."