The above explanation about unexpected table type is a FACT that you should be aware of. You may create a table with unexpected type when using a standard "CREATE TABLE ..." statement. The SQL script you may be using could be coming from a different database type source such as PostgreSql, SQL server or Oracle. Your objective may be to re-create the same data model on a sap hana tenant database.
Leaving aside any database specificities, the statement "CREATE TABLE ..." is common to most databases. However, Sap hana can create 2 types of tables but only 1 table type "Column or Row table" is created by default. Creating too many and too big row tables in a sap hana database can have an impact in performance and with memory. Row data table is not compressed and will take more memory space than column tables.
Before running any SQL scripts which have been created outside a sap hana environment, check its content and especially the CREATE TABLE SYNTAX. If you have any doubt, replace any "CREATE TABLE" with "CREATE COLUMN TABLE" before executing the script.