As you develop the model for your Hive tables, columns with their types, and indexes, as well as columns-level constraints, Hackolade dynamically generates the corresponding HQL scripts: