Implicit Conversions- Datatype not comparable error

Problem

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"

Answer

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.