Hive

Hive :

Beeline versus Hive CLI :

HDP will supports two Hive clients: the Hive CLI and Beeline. The main difference between the two involves how the clients connect to Hive.

The Hive CLI,  connects directly to HDFS and the Hive Metastore, and can be used only on a host with access to those services.
Beeline, which connects to HiveServer2 and requires access to only one .jar file: hive-jdbc-<version>-standalone.jar.

Hive configurations to update a table :

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions.pernode=1000;

set hive.enforce.bucketing = true;