User is 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 an explicit conversion by forcing a cast from string to big int. For example:
e.event_id=er.event_id --> e.event_id = CAST(er.event_id as BIGINT)
For more information about available casting functions in Okera, refer to the documentation here.