The following two queries should produce identical results, but this is not the case. Both queries use the functional database.
This query seems to produce correct results.
In this query, we replace (smallint_col = double_col) with TRUE, and Impala throws AnalysisException.
Wrap the TRUE constant in an inline view. To fix the example above: