On 10/05/16 23:06, Lynn Carol Johnson 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:
Please respect the data types and syntax provided by MonetDB. See for a global comparison of various SQL dialects: https://en.wikibooks.org/wiki/SQL_Dialects_Reference
CREATE TABLEte_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>\
correct error message
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" correct error message
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.
char(N) column types only specify the upperbound N, it may be represented differently. Bulk loading character files requires zero terminated strings input files, which are dictionary compressed and stored in the column. regards, Martin
Any suggestions?
Thanks - Lynn
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list