Defining the table settings
Procedure
- In Table name field, enter the name of the Hive table to be created. In this scenario, it is employees.
- From the Action on table list, select Create table if not exists.
- From the Format list, select the data format that this Hive table in question is created for. In this scenario, it is TEXTFILE.
-
Select the Set partitions check box to
add the US partition as explained at the
beginning of this scenario. To define this partition, click the
button next to Edit
schema that appears.
- Leave the Set file location check box clear to use the default path for Hive table.
- Select the Set Delimited row format check box to display the available options of row format.
- Select the Field check box and enter a semicolon (;) as field separator in the field that appears.
- Select the Line check box and leave the default value as line separator.