The following @Ignore tests can be enabled:
ZetaSQLDialectSpecTest.testSelectDistinct2
GitHub Pull Request #11934