How to create a new table in HIVE?

To create a new table in HIVE, you can use the CREATE TABLE statement. Here's the basic syntax:

CREATE TABLE table_name (
    column1 datatype [optional_parameters] [column_constraint],
    column2 datatype [optional_parameters] [column_constraint],
    column3 datatype [optional_parameters] [column_constraint],
    ...
    [table_constraint]
)
[PARTITIONED BY (partition_column1 datatype, partition_column2 datatype, ...)]
[CLUSTERED BY (clustered_column_name) [SORTED BY (sorting_column_name [ASC|DESC]), ...] INTO num_buckets BUCKETS];

Here's an example that creates a new table named employees:

CREATE TABLE employees (
    id INT,
    first_name STRING,
    last_name STRING,
    email STRING,
    hire_date DATE
)
PARTITIONED BY (department STRING, salary_range STRING)
CLUSTERED BY (id) SORTED BY (id) INTO 4 BUCKETS;

This statement creates a new table named employees with five columns: id, first_name, last_name, email, and hire_date. The id column is defined as an integer, and the other columns are defined as strings or dates. The table is also partitioned by department and salary_range columns and clustered by the id column. The clustered table is sorted by the id column in ascending order and is split into four buckets.

Once the table is created, you can insert data into it using the INSERT INTO statement and query the data using the SELECT statement.