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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!