Dremio sql syntax for multiple lines

DROP TABLE IF EXIST blablah;
CREATE TABLE blabla AS …

seems to throw parsing the query errors.

This is expected behavior. Feel free to comment a line out then rerun.

What flavour of SQL is this then?

It’s ansi, without transaction semantics, and with most of the newer analytical operators like windowing. Where there are variations between sql implementations we follow Oracle more often than not.

You can’t currently issue multiple statements separated by semicolons.

If you have ideas about what you’d like to see in this area of the product we are all ears and will open an internal ticket on your behalf.