Question

4. Create a table in database application. Named as "Employee details". Add the following field in the table- Name of the employee Employer ID Date of joining Post/Designation Department Basic salary Sort the basic salary field in ascending order. in database​

Answer 1

Answer:

This chapter explains how to create a table and how to insert data into it. The conventions of creating a table in HIVE is quite similar to creating a table using SQL.

Create Table Statement

Create Table is a statement used to create a table in Hive. The syntax and example are as follows: