Hi Sreejith, the table you are trying to create does not define any columns, between the parenthesis I see no column definition, and in the relational model it is not permitted to define a table without columns. Assuming that schema DM_MON_TSV_STG_T1 exists, then you will need to do for example CREATE TABLE "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001" ("column-name" integer); Also I would suggest to make your scripts to read if the command was successful or if there was an error, because monetdb is most likely returning a syntax error of type: syntax error, unexpected ')' which means that you cant have an empty column definition. lefteris On Sat, Mar 10, 2018 at 8:29 AM, Sharma, Sreejith <Sreejith.Sharma@harman.com> wrote:
All,
We are finding a strange issue where below table has been created via a shell script. Strangely it doesn’t show up any columns and when we try to drop it’s saying table doesn’t exists.
Is there any way below can happen? Is this because it’s corrupted? How can we remove this?
CREATE TABLE "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001" (
);
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list