If you're fighting a TYPE_MISMATCH error in Athena even when your types are correct, you're not crazy. Read this.