At the moment you cannot really prevent this issue. It is a warning indicating that some calculations may not be accurate due to overflow (e.g., when multiplying very large cardinalities). The values will be capped at MAX_LONG.

If you don't have reason to believe that your query plans are bad because of this overflow, then I would not worry about those warnings.