How to query partitioned table data in Hive?

4 months ago

1 minute

You can query partitioned table data in Hive by following these steps:

Open the Hive command line interface or use Hive querying tools like Hue.
Use the following command to access the database you want to query:

USE database_name;

Use the following command to view partition information in the partition table:

SHOW PARTITIONS table_name;

Query the data in a specified partition using the following command:

SELECT * FROM table_name WHERE partition_column = 'partition_value';

In this case, table_name refers to the name of the partitioned table to be queried, partition_column represents the column name of the partition, and partition_value is the specific value of the partition to be queried.

By following the steps above, you can successfully query data from a Hive partitioned table.