- Getting the following error when trying to create a view:
- "Could not execute ddl., detail:AnalysisException: operands of type BIGINT and STRING are not comparable: "Datatype not comparable"
- Okera does not allow Implicit Conversions. In the above error, a user needs to either:
- Change the schema to be BIGINT if possible
- or use Explicit Conversion by explicitly forcing a cast from string to big int.
- Such as: e.event_id=er.event_id --> e.event_id = CAST(er.event_id as BIGINT)