I have been trying to run a set of multiple blocks of SQL code in Hue Hive Hadoop, only to find my blocks of code being either executed in a non-sequenced order, random order, or only a subsection of the queries.
create table table_1
create table table_2
The latest run I ran had six blocks, creating 6 tables. Selecting all code, and executing it, resulted in tables 1 and 3 to be created, no errors.
In some other instances, my code has been aborted mid execution due various errors.
My topic for discussion is thus: how do I ensure hue hive editor to execute blocks of code in both sequence, and without skipping some blocks?