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
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