Thank you - Sorry I didn¹t notice the [ vs ) when I looked at the types.
This worked.
On 5/10/16, 5:51 PM, "users-list on behalf of Stefan Manegold"
Hi,
you need to omit the single quotes that are used to indicate literal symbols (as opposed to keywords) in the SQL syntax definition at https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes
i.e., instead of "char '('3')'" and "char'('8')'" the correct SQL syntax is "char (3)" and "char(8)".
Best, Stefan
----- On May 10, 2016, at 11:06 PM, Lynn Carol Johnson lcj34@cornell.edu wrote:
Hi All -
I¹m trying to create a table with specific size for text fields. In particular, I am storing a 3 byte character and an 8 byte character. I tried the following but get errors:
CREATE TABLE te_LTRTest(chr int, pos int, te_gag_protein tinyint, te_ap_protein tinyint, te_integrase_protein tinyint, te_rt_protein tinyint, te_rnaseh_protein tinyint, te_chromodomain_protein tinyint, te_envelope_protein tinyint, te_ltr_age real, te_numb_ltrtes_inside integer , te_superfamily char '('3')' , te_family char '('8') ¹ );
Gives the error:
sql>\
syntax error, unexpected STRING, expecting ')' or ',' in: "create table te_ltrtest(chr int, pos int, te_gag_protein tinyint, te_ap_protein"
sql>
Switching to this:
CREATE TABLE te_LTRTest(chr int, pos int, te_gag_protein tinyint, te_ap_protein tinyint, te_integrase_protein tinyint, te_rt_protein tinyint, te_rnaseh_protein tinyint, te_chromodomain_protein tinyint, te_envelope_protein tinyint, te_ltr_age real, te_numb_ltrtes_inside integer , te_superfamily char [ 3 ], te_family char [ 8 ] );
Gives the following error:
sql>\
syntax error, unexpected '[', expecting ')' or ',' in: "create table te_ltrtest(chr int, pos int, te_gag_protein tinyint, te_ap_protein"
sql>
I have 2.1 billion rows so am using the binary bulk loads. My non-numeric binary files were created to contain 3-byte values and 8-byte values. This is what I am trying to load, however I¹m not getting past the create table stage. I love the binary loader. This is the first time I¹ve needed to include text data in my tables. Is this supported? I¹m hoping it is just my syntax.
Any suggestions?
Thanks - Lynn
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list