Often, some requests for reports seem simple and straightforward. But it is challenging to find a better solution to be applied. Cloudera’s Impala provides several features, and in order to accomplish the tasks in the best possible way, an analyst needs to be aware of them.
Assume that, after filtering out specific values, there are two separate result sets that need to be combined into a single output with distinct values. How would you do that?
Let’s see with an example.
SELECT * FROM SHJ_Products WHERE Price > 500