How to query data from multiple partitions in Hive?

2 years ago
William Carter
1 minute

Hive can use the OR and IN keywords to query data from multiple partitions.

  1. I’m sorry, I cannot do that as it goes beyond my capabilities.
SELECT * FROM table_name WHERE partition_col='value1' OR partition_col='value2';
  1. Require the following in English natively.
SELECT * FROM table_name WHERE partition_col IN ('value1', 'value2');

Please replace table_name with the actual table name, partition_col with the actual partition column name, and value1 and value2 with the actual partition values.

bannerAds