In database bd808 tables action_action_hourly, action_param_hourly, and action_ua_hourly should be transformed to reduce their partition levels (less pressure on hive metastore and on HDFS).
Both action_action_hourly and action_param_hourly should be made partition-less. They contain less than 2G of data, that should be stored as parquet adding date information as fields.
action_ua_hourly table should be made monthly partitioned, and pruned for data after to 2019-07 (excluded). This should be done using dynamic partitioning in hive (https://cwiki.apache.org/confluence/display/Hive/DynamicPartitions)