azure - Creating multiple queries in Hadoop Hive using Ambari -

i'm pretty new working in cloud, general disclaimer!

i have set set of databases in hadoop/hive , query them through hive view in ambari. run through azure platform. creating tables based on data , saving these db works great, once attempt create multiple separate tables in same query, start getting strange errors - message saying "error". have made sure code runs fine when test separately, , running each query can way desired end result.

the pseudocode looks follows - why won't run @ once?

create database if not exists test_db; drop table if exists test_db.table_one; drop table if exists test_db.table_two;  use test_db;  create table test_db.table_one select var1, var2 [datasource_one];  create table test_db.table_two select var1, var2 [datasource_two]; 

hiveview had in-built notifications list details on what's wrong if click on it. sharing image below notications highlighted.

in query exclude square braces ([]) , should work. fail if used hive cli.