c# - Parser Error with HIVE ODBC -

i'm writing code in c# invoke hive script via odbc. i'm using hortonworks hive odbc driver (though i've tried several others , same error). can connect fine via odbc , simple commands work (for example select * mytable limit 10; should). run trouble longer scripts have processing have multiple 'chunks' of sql (each terminated semi-colon). example, first statement creates temp table, next inserts it, maybe select different table, etc, typical sql. keep getting following error on line specifies s3 location file parser error:

error while compiling statement: failed: parseexception line 8:85 missing eof @ ';' near ''s3n://somebucket/somefolder/etc'

here's example of failing:

create external table if not exists mytesttable(    id int,    anotherid int,    name string    ) row format delimited fields terminated '\t' lines terminated '\n' location 's3n://somebucket/somefolder/etc';  ...script continues here next chunk of sql 

what doing wrong? also, if ssh in , run script command line works perfectly.

ok, in testing, hive shell accept multiple statements in query. breaking query multiple separate statements , issuing them hive separate queries.

the odbc drivers not work multi-statement queries, if you're interested in having capability added should contact distribution got odbc driver from, or can contact simba (http://www.simba.com/connectors/apache-hadoop-hive-driver) if you're using apache distribution create technology used distributions.