Executing multiple blocks in sequence

[#1]

Hi,

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.

Example:

--Block 1:

create table table_1

<...>;

--Block2:

create table table_2

<...>;

etc. 

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?