如何在Cloudera中编写"In one of..."形式的条件筛选子句？

Hey there! You're totally right about the syntax issue—using IN is the proper way to match against multiple values in SQL, including in Cloudera's environment (whether you're using Hive, Impala, or another supported engine).

Here's the corrected SQL query that does exactly what you need: pulls all records from the old table where org_zone_name matches any of your specified values:

SELECT *
FROM old
WHERE org_zone_name IN ('Specialist', 'Vet', 'Surgeon', 'Nurse', 'Other');

A quick breakdown of the key parts:

• IN tells the query to check if the column value matches any item in the list that follows
• Each string value is wrapped in single quotes (required for string comparisons in SQL)
• Values are separated by commas, all enclosed within parentheses

If you ever need to exclude these values instead, you can swap IN for NOT IN:

SELECT *
FROM old
WHERE org_zone_name NOT IN ('Specialist', 'Vet', 'Surgeon', 'Nurse', 'Other');

One small heads-up: if your org_zone_name column might contain NULL values, using NOT IN can lead to unexpected results (since NULL comparisons return UNKNOWN). In that case, you might want to add an extra condition like AND org_zone_name IS NOT NULL to avoid missing records.

内容的提问来源于stack exchange，提问作者Anna