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" <users-list-bounces+lcj34=cornell.edu@monetdb.org on behalf of Stefan.Manegold@cwi.nl> wrote:
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>\</workdir/lcj34/monetdbFiles/michelle_TE/create_teLTRTest.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>\</workdir/lcj34/monetdbFiles/michelle_TE/create_teLTRTest.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