- users-list - monetdb.org

Re: [MonetDB-users] MonetDB Permission/COPY INTO Questions
by Allen Zhang 12 Nov '11

12 Nov '11

Sean, Maybe here is why you did not spot the duplicate: cat /tmp/testdata2.csv | cut -d, -f1,5 | sort | uniq -d Regards Allen On 11/12/11 12:39 PM, "Sean McNamara" <tank(a)thursday.org> wrote: >Looks like I had too much faith in the "uniq" command (or >misunderstand its constraints.) There are definitely duplicates in my >import set. :-( > >Back to data scrubbing... > >On Sat, Nov 12, 2011 at 12:08 PM, Allen Zhang <azhang(a)pmci-usa.com> wrote: >> Sean, >> >> Use sql select to find out duplicates. >> >> Regards >> Allen >> >> On 11/12/11 12:01 PM, "Sean McNamara" <tank(a)thursday.org> wrote: >> >>>I tried that (as both the normal dbuser and as admin). Both fail the >>>same way but don't give an indicator of where it feels the constraint >>>is violated: >>> >>>$ mclient -u monetdb -s "alter table mduser.testdata add constraint >>>testdata_pkey primary key (foo,epoch);" testdb >>>password: >>>SQLException:assert:UPDATE: PRIMARY KEY constraint >>>'testdata.testdata_pkey' violated >>> >>> >>>On Sat, Nov 12, 2011 at 11:42 AM, Allen Zhang <azhang(a)pmci-usa.com> >>>wrote: >>>> How about add constraint after you import? I think it might tell you >>>>which >>>> one had problem. >>>> >>>> Regards >>>> Allen >>>> >>>> On 11/12/11 11:19 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >>>> >>>>>Brilliant suggestion, and I think it exposed the problem. >>>>> >>>>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>>>password: >>>>>SQLException:importTable:value 'ONE_SECOND' from line 12734 field 3 >>>>>not inserted, expecting type varchar(8) >>>>>failed to import table >>>>> >>>>>It looks like the field I created is too small to handle some of the >>>>>values in the file. After expanding all the varchar fields to 32 and >>>>>re-running, I get a different error: >>>>> >>>>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>>>password: >>>>>SQLException:assert:INSERT INTO: PRIMARY KEY constraint >>>>>'testdata.testdata_pkey' violated >>>>> >>>>>That makes me think I have duplicate data. The PKEY is comprised of >>>>>fields #1 and #5, so I check for that but it looks fine: >>>>> >>>>>$ cat /tmp/testdata2.csv | cut -d, -f1,5 |uniq -d >>>>>$ >>>>> >>>>>However if I drop and re-add the table without the constraint, it >>>>>works: >>>>> >>>>>sql>create table testdata ( >>>>>more> foo varchar(32), >>>>>more> bar varchar(32), >>>>>more> baz varchar(32), >>>>>more> woz varchar(32), >>>>>more> epoch bigint >>>>>more>); >>>>>operation successful (1.477ms) >>>>>sql>\q >>>>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>>>password: >>>>>2519931 affected rows >>>>> >>>>> >>>>>Thanks Allen! This gets me able to import. Now I'm wondering what >>>>>might be wrong with the constraint. Any insight there? >>>>> >>>>> >>>>> >>>>>On Sat, Nov 12, 2011 at 10:58 AM, Allen Zhang <azhang(a)pmci-usa.com> >>>>>wrote: >>>>>> What about just issue the following: >>>>>> >>>>>> mclient -s "copy into testdata from '/tmp/testdata2.csv' using >>>>>>delimiters >>>>>> ',','\n','\'';" >>>>>> >>>>>> >>>>>> Regards >>>>>> Allen >>>>>> >>>>>> >>>>>> On 11/12/11 10:48 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >>>>>> >>>>>>>Thanks Allen. Red-herring there. My first file had "SPY" in the >>>>>>>first column, and the second had "testdata1", so the difference >>>>>>>there >>>>>>>is just because of the contents. If I convert the original SPY file >>>>>>>and re-run, I get the same behavior. >>>>>>> >>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>',','\n','\'';" testdb - < /tmp/testdata2.csv >>>>>>>syntax error, unexpected STRING in: "'SPY'" >>>>>>> >>>>>>> >>>>>>>On Sat, Nov 12, 2011 at 10:43 AM, Allen Zhang <azhang(a)pmci-usa.com> >>>>>>>wrote: >>>>>>>> Hi Sean, >>>>>>>> >>>>>>>> You should inspect your data quality, it seems in the first 3 >>>>>>>>imports, >>>>>>>>it >>>>>>>> stopped at "spy", I suspect it might be some \t in that supposed >>>>>>>>to >>>>>>>>be >>>>>>>> string, and last import you put single-quote around string, then >>>>>>>>it >>>>>>>> stopped at "testvalue1", search your import file, look for that >>>>>>>> "testvalue1", the problem should around there, maybe an extra >>>>>>>>field >>>>>>>> because wrong replace by sed. >>>>>>>> >>>>>>>> Best Regards >>>>>>>> Allen >>>>>>>> >>>>>>>> On 11/12/11 10:26 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >>>>>>>> >>>>>>>>>Thanks Viktor, but no dice. I also tried converting from CSV to >>>>>>>>>TAB-delim to match what you were doing, but it's still not >>>>>>>>>working... >>>>>>>>> >>>>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>>>',','\n','';" testdb - < /tmp/testdata.csv >>>>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>>>> >>>>>>>>>$ sed 's/,/\'$'\t''/g' /tmp/testdata.csv > /tmp/testdata.dat >>>>>>>>> >>>>>>>>>$ mclient -s "copy into testdata from STDIN;" testdb - < >>>>>>>>>/tmp/testdata.dat >>>>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>>>> >>>>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>>>'\t','\n','';" testdb - < /tmp/testdata.dat >>>>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>>>> >>>>>>>>>I'm understanding the format of the documentation quite a bit >>>>>>>>>better >>>>>>>>>now after spending a few days with it, but I'm still not clear on >>>>>>>>>why >>>>>>>>>this insert is failing. >>>>>>>>>I went one step further and converted the input file to >>>>>>>>>single-quote >>>>>>>>>the string fields, but this fails as well: >>>>>>>>> >>>>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>>>',','\n','\'';" testdb - < /tmp/testdata2.csv >>>>>>>>>syntax error, unexpected STRING in: "'testvalue1'" >>>>>>>>> >>>>>>>>> >>>>>>>>>The problem has to be something trivial, but I have no idea what >>>>>>>>>it >>>>>>>>>is... >>>>>>>>> >>>>>>>>>On Sat, Nov 12, 2011 at 5:30 AM, Viktor Rosenfeld >>>>>>>>><listuser36(a)googlemail.com> wrote: >>>>>>>>>> Hi Sean, >>>>>>>>>> >>>>>>>>>> Sean McNamara wrote: >>>>>>>>>> >>>>>>>>>>> $ mclient -s "copy 2519931 records into testdata from STDIN >>>>>>>>>>>using >>>>>>>>>>> delimiters ',';" testdb - < /tmp/testdata.csv >>>>>>>>>>> syntax error, unexpected IDENT in: "testvalue1" >>>>>>>>>>> >>>>>>>>>>> where testvalue1 is one of the actual values in the FOO column >>>>>>>>>>> (actually the only value in this particular file.) >>>>>>>>>>> >>>>>>>>>>> I'm wondering if this is telling me it's expecting the field to >>>>>>>>>>>be >>>>>>>>>>> quoted, but that seems unlikely as it would make working with >>>>>>>>>>>CSVs >>>>>>>>>>> quite a bit painful. >>>>>>>>>>> >>>>>>>>>>> Can you guys kindly help me take another step forward. I >>>>>>>>>>>really >>>>>>>>>>> appreciate the guidance. >>>>>>>>>> >>>>>>>>>> I'm using >>>>>>>>>> >>>>>>>>>> COPY ... USING DELIMITERS '\t','\n',''; >>>>>>>>>> >>>>>>>>>> to bulk-load tab-delimited unquoted data. The '\t' is the >>>>>>>>>>default >>>>>>>>>>field >>>>>>>>>> separator, the '\n' is the default record separator. The final >>>>>>>>>>'' >>>>>>>>>>is >>>>>>>>>>the >>>>>>>>>> quote string -- empty in my case. >>>>>>>>>> >>>>>>>>>> See: >>>>>>>>>>http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInt >>>>>>>>>>o >>>>>>>>>> >>>>>>>>>> Cheers, >>>>>>>>>> Viktor >>>>>>>>>> >>>>>>>>> >>>>>>>>>------------------------------------------------------------------ >>>>>>>>>-- >>>>>>>>>-- >>>>>>>>>-- >>>>>>>>>-- >>>>>>>>>---- >>>>>>>>>RSA(R) Conference 2012 >>>>>>>>>Save $700 by Nov 18 >>>>>>>>>Register now >>>>>>>>>http://p.sf.net/sfu/rsa-sfdev2dev1 >>>>>>>>>_______________________________________________ >>>>>>>>>MonetDB-users mailing list >>>>>>>>>MonetDB-users(a)lists.sourceforge.net >>>>>>>>>https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>> >>>> >>>> >>>> >> >> >>

1 0

Re: [MonetDB-users] MonetDB Permission/COPY INTO Questions
by Allen Zhang 12 Nov '11

12 Nov '11

Sean, Use sql select to find out duplicates. Regards Allen On 11/12/11 12:01 PM, "Sean McNamara" <tank(a)thursday.org> wrote: >I tried that (as both the normal dbuser and as admin). Both fail the >same way but don't give an indicator of where it feels the constraint >is violated: > >$ mclient -u monetdb -s "alter table mduser.testdata add constraint >testdata_pkey primary key (foo,epoch);" testdb >password: >SQLException:assert:UPDATE: PRIMARY KEY constraint >'testdata.testdata_pkey' violated > > >On Sat, Nov 12, 2011 at 11:42 AM, Allen Zhang <azhang(a)pmci-usa.com> wrote: >> How about add constraint after you import? I think it might tell you >>which >> one had problem. >> >> Regards >> Allen >> >> On 11/12/11 11:19 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >> >>>Brilliant suggestion, and I think it exposed the problem. >>> >>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>password: >>>SQLException:importTable:value 'ONE_SECOND' from line 12734 field 3 >>>not inserted, expecting type varchar(8) >>>failed to import table >>> >>>It looks like the field I created is too small to handle some of the >>>values in the file. After expanding all the varchar fields to 32 and >>>re-running, I get a different error: >>> >>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>password: >>>SQLException:assert:INSERT INTO: PRIMARY KEY constraint >>>'testdata.testdata_pkey' violated >>> >>>That makes me think I have duplicate data. The PKEY is comprised of >>>fields #1 and #5, so I check for that but it looks fine: >>> >>>$ cat /tmp/testdata2.csv | cut -d, -f1,5 |uniq -d >>>$ >>> >>>However if I drop and re-add the table without the constraint, it works: >>> >>>sql>create table testdata ( >>>more> foo varchar(32), >>>more> bar varchar(32), >>>more> baz varchar(32), >>>more> woz varchar(32), >>>more> epoch bigint >>>more>); >>>operation successful (1.477ms) >>>sql>\q >>>$ mclient -u monetdb -s "copy into mduser.testdata from >>>'/tmp/testdata2.csv' using delimiters ',','\n','\'';" testdb >>>password: >>>2519931 affected rows >>> >>> >>>Thanks Allen! This gets me able to import. Now I'm wondering what >>>might be wrong with the constraint. Any insight there? >>> >>> >>> >>>On Sat, Nov 12, 2011 at 10:58 AM, Allen Zhang <azhang(a)pmci-usa.com> >>>wrote: >>>> What about just issue the following: >>>> >>>> mclient -s "copy into testdata from '/tmp/testdata2.csv' using >>>>delimiters >>>> ',','\n','\'';" >>>> >>>> >>>> Regards >>>> Allen >>>> >>>> >>>> On 11/12/11 10:48 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >>>> >>>>>Thanks Allen. Red-herring there. My first file had "SPY" in the >>>>>first column, and the second had "testdata1", so the difference there >>>>>is just because of the contents. If I convert the original SPY file >>>>>and re-run, I get the same behavior. >>>>> >>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>',','\n','\'';" testdb - < /tmp/testdata2.csv >>>>>syntax error, unexpected STRING in: "'SPY'" >>>>> >>>>> >>>>>On Sat, Nov 12, 2011 at 10:43 AM, Allen Zhang <azhang(a)pmci-usa.com> >>>>>wrote: >>>>>> Hi Sean, >>>>>> >>>>>> You should inspect your data quality, it seems in the first 3 >>>>>>imports, >>>>>>it >>>>>> stopped at "spy", I suspect it might be some \t in that supposed to >>>>>>be >>>>>> string, and last import you put single-quote around string, then it >>>>>> stopped at "testvalue1", search your import file, look for that >>>>>> "testvalue1", the problem should around there, maybe an extra field >>>>>> because wrong replace by sed. >>>>>> >>>>>> Best Regards >>>>>> Allen >>>>>> >>>>>> On 11/12/11 10:26 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >>>>>> >>>>>>>Thanks Viktor, but no dice. I also tried converting from CSV to >>>>>>>TAB-delim to match what you were doing, but it's still not >>>>>>>working... >>>>>>> >>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>',','\n','';" testdb - < /tmp/testdata.csv >>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>> >>>>>>>$ sed 's/,/\'$'\t''/g' /tmp/testdata.csv > /tmp/testdata.dat >>>>>>> >>>>>>>$ mclient -s "copy into testdata from STDIN;" testdb - < >>>>>>>/tmp/testdata.dat >>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>> >>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>'\t','\n','';" testdb - < /tmp/testdata.dat >>>>>>>syntax error, unexpected IDENT in: "spy" >>>>>>> >>>>>>>I'm understanding the format of the documentation quite a bit better >>>>>>>now after spending a few days with it, but I'm still not clear on >>>>>>>why >>>>>>>this insert is failing. >>>>>>>I went one step further and converted the input file to single-quote >>>>>>>the string fields, but this fails as well: >>>>>>> >>>>>>>$ mclient -s "copy into testdata from STDIN using delimiters >>>>>>>',','\n','\'';" testdb - < /tmp/testdata2.csv >>>>>>>syntax error, unexpected STRING in: "'testvalue1'" >>>>>>> >>>>>>> >>>>>>>The problem has to be something trivial, but I have no idea what it >>>>>>>is... >>>>>>> >>>>>>>On Sat, Nov 12, 2011 at 5:30 AM, Viktor Rosenfeld >>>>>>><listuser36(a)googlemail.com> wrote: >>>>>>>> Hi Sean, >>>>>>>> >>>>>>>> Sean McNamara wrote: >>>>>>>> >>>>>>>>> $ mclient -s "copy 2519931 records into testdata from STDIN using >>>>>>>>> delimiters ',';" testdb - < /tmp/testdata.csv >>>>>>>>> syntax error, unexpected IDENT in: "testvalue1" >>>>>>>>> >>>>>>>>> where testvalue1 is one of the actual values in the FOO column >>>>>>>>> (actually the only value in this particular file.) >>>>>>>>> >>>>>>>>> I'm wondering if this is telling me it's expecting the field to >>>>>>>>>be >>>>>>>>> quoted, but that seems unlikely as it would make working with >>>>>>>>>CSVs >>>>>>>>> quite a bit painful. >>>>>>>>> >>>>>>>>> Can you guys kindly help me take another step forward. I really >>>>>>>>> appreciate the guidance. >>>>>>>> >>>>>>>> I'm using >>>>>>>> >>>>>>>> COPY ... USING DELIMITERS '\t','\n',''; >>>>>>>> >>>>>>>> to bulk-load tab-delimited unquoted data. The '\t' is the default >>>>>>>>field >>>>>>>> separator, the '\n' is the default record separator. The final '' >>>>>>>>is >>>>>>>>the >>>>>>>> quote string -- empty in my case. >>>>>>>> >>>>>>>> See: >>>>>>>>http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto >>>>>>>> >>>>>>>> Cheers, >>>>>>>> Viktor >>>>>>>> >>>>>>> >>>>>>>-------------------------------------------------------------------- >>>>>>>-- >>>>>>>-- >>>>>>>-- >>>>>>>---- >>>>>>>RSA(R) Conference 2012 >>>>>>>Save $700 by Nov 18 >>>>>>>Register now >>>>>>>http://p.sf.net/sfu/rsa-sfdev2dev1 >>>>>>>_______________________________________________ >>>>>>>MonetDB-users mailing list >>>>>>>MonetDB-users(a)lists.sourceforge.net >>>>>>>https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>>> >>>>>> >>>>>> >>>> >>>> >>>> >> >> >>

1 0

Re: [MonetDB-users] MonetDB Permission/COPY INTO Questions
by Allen Zhang 12 Nov '11

12 Nov '11

What about just issue the following: mclient -s "copy into testdata from '/tmp/testdata2.csv' using delimiters ',','\n','\'';" Regards Allen On 11/12/11 10:48 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >Thanks Allen. Red-herring there. My first file had "SPY" in the >first column, and the second had "testdata1", so the difference there >is just because of the contents. If I convert the original SPY file >and re-run, I get the same behavior. > >$ mclient -s "copy into testdata from STDIN using delimiters >',','\n','\'';" testdb - < /tmp/testdata2.csv >syntax error, unexpected STRING in: "'SPY'" > > >On Sat, Nov 12, 2011 at 10:43 AM, Allen Zhang <azhang(a)pmci-usa.com> wrote: >> Hi Sean, >> >> You should inspect your data quality, it seems in the first 3 imports, >>it >> stopped at "spy", I suspect it might be some \t in that supposed to be >> string, and last import you put single-quote around string, then it >> stopped at "testvalue1", search your import file, look for that >> "testvalue1", the problem should around there, maybe an extra field >> because wrong replace by sed. >> >> Best Regards >> Allen >> >> On 11/12/11 10:26 AM, "Sean McNamara" <tank(a)thursday.org> wrote: >> >>>Thanks Viktor, but no dice. I also tried converting from CSV to >>>TAB-delim to match what you were doing, but it's still not working... >>> >>>$ mclient -s "copy into testdata from STDIN using delimiters >>>',','\n','';" testdb - < /tmp/testdata.csv >>>syntax error, unexpected IDENT in: "spy" >>> >>>$ sed 's/,/\'$'\t''/g' /tmp/testdata.csv > /tmp/testdata.dat >>> >>>$ mclient -s "copy into testdata from STDIN;" testdb - < >>>/tmp/testdata.dat >>>syntax error, unexpected IDENT in: "spy" >>> >>>$ mclient -s "copy into testdata from STDIN using delimiters >>>'\t','\n','';" testdb - < /tmp/testdata.dat >>>syntax error, unexpected IDENT in: "spy" >>> >>>I'm understanding the format of the documentation quite a bit better >>>now after spending a few days with it, but I'm still not clear on why >>>this insert is failing. >>>I went one step further and converted the input file to single-quote >>>the string fields, but this fails as well: >>> >>>$ mclient -s "copy into testdata from STDIN using delimiters >>>',','\n','\'';" testdb - < /tmp/testdata2.csv >>>syntax error, unexpected STRING in: "'testvalue1'" >>> >>> >>>The problem has to be something trivial, but I have no idea what it >>>is... >>> >>>On Sat, Nov 12, 2011 at 5:30 AM, Viktor Rosenfeld >>><listuser36(a)googlemail.com> wrote: >>>> Hi Sean, >>>> >>>> Sean McNamara wrote: >>>> >>>>> $ mclient -s "copy 2519931 records into testdata from STDIN using >>>>> delimiters ',';" testdb - < /tmp/testdata.csv >>>>> syntax error, unexpected IDENT in: "testvalue1" >>>>> >>>>> where testvalue1 is one of the actual values in the FOO column >>>>> (actually the only value in this particular file.) >>>>> >>>>> I'm wondering if this is telling me it's expecting the field to be >>>>> quoted, but that seems unlikely as it would make working with CSVs >>>>> quite a bit painful. >>>>> >>>>> Can you guys kindly help me take another step forward. I really >>>>> appreciate the guidance. >>>> >>>> I'm using >>>> >>>> COPY ... USING DELIMITERS '\t','\n',''; >>>> >>>> to bulk-load tab-delimited unquoted data. The '\t' is the default >>>>field >>>> separator, the '\n' is the default record separator. The final '' is >>>>the >>>> quote string -- empty in my case. >>>> >>>> See: >>>>http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto >>>> >>>> Cheers, >>>> Viktor >>>> >>> >>>------------------------------------------------------------------------ >>>-- >>>---- >>>RSA(R) Conference 2012 >>>Save $700 by Nov 18 >>>Register now >>>http://p.sf.net/sfu/rsa-sfdev2dev1 >>>_______________________________________________ >>>MonetDB-users mailing list >>>MonetDB-users(a)lists.sourceforge.net >>>https://lists.sourceforge.net/lists/listinfo/monetdb-users >> >> >>

1 0

Re: [MonetDB-users] Extended Fetch ODBC Error
by Jeremy O'Sullivan 10 Nov '11

10 Nov '11

Hi Sjoerd, Would it be possible to test your thesis ? The OBI guys reckon that for odbc 2 connections, they use the function SQLExtendedFetch. This has bee replaced by SQLFetchScroll in odbc 3.5. Not sure if that helps, I know little or nothing about odbc, other than many BI tools only use this interface and not jdbc. Regards, Jeremy It is unclear from this message what exactly fails. My guess (since I saw something like that recently) is that Oracle's OBI EE tries to set the statement option (or attribute) SQL_ATTR_CONCURRENCY to a value that is not supported. We only support setting the value to SQL_CONCUR_READ_ONLY. Attempting to set the attribute to any other value will return the above error (not implemented). Perhaps what we should do instead here is accept the value and return a message (in the ODBC way) that instead of the value that the application asked for we set it to SQL_CONCUR_READ_ONLY. Other possible statement attributes that could return the feature not implemented error are SQL_ATTR_ASYNC_ENABLE, SQL_ATTR_CURSOR_SENSITIVITY, SQL_ATTR_ENABLE_AUTO_IPD, SQL_ATTR_FETCH_BOOKMARK_PTR, SQL_ATTR_KEYSET_SIZE, SQL_ATTR_MAX_LENGTH, SQL_ATTR_MAX_ROWS, SQL_ATTR_QUERY_TIMEOUT, SQL_ATTR_ROW_NUMBER, SQL_ATTR_SIMULATE_CURSOR, and SQL_ATTR_USE_BOOKMARKS. On 9 Nov 2011, at 12:26, Jeremy O'Sullivan wrote: > Hello, > > When trying to connect to MonetDB using Oracle's OBI EE, I get the error below. Has anyone seen this before ? > Regards, > Jeremy > > [MonetDB][ODBC Driver 11.5.7]Optional feature not implemented. > > [nQSError: 16006] Setting the statement option for extended fetch failed. > >

2 1

[MonetDB-users] Extended Fetch ODBC Error
by Jeremy O'Sullivan 09 Nov '11

09 Nov '11

Hello, When trying to connect to MonetDB using Oracle's OBI EE, I get the error below. Has anyone seen this before ? Regards, Jeremy [MonetDB][ODBC Driver 11.5.7]Optional feature not implemented. [nQSError: 16006] Setting the statement option for extended fetch failed.

2 1

[MonetDB-users] Tableau Alias error
by Jeremy O'Sullivan 09 Nov '11

09 Nov '11

Hello, When connecting from Tableau, the following syntax generates and error on the command line, is this correct ? (The :w triggers the error.) Regards, Jeremy select count(context_key) as "context_key:w" from context_dim;

2 1

[MonetDB-users] How to check wether a record exists or not in stored procedure
by dengxk 08 Nov '11

08 Nov '11

I am writing a stored procedure to insert an record into my table. If the record exists, just update it. it is easier to acheive in microsoft sql server with the sql: if exists( select column from table where condition ...). As monetdb doesn't support select statment and cursor in stored procedure, is there other walkround?

1 0

Re: [MonetDB-users] confirm e5d538cae9aefced13c1ef02f7f06476bbdd59e0
by charles 07 Nov '11

07 Nov '11

Hello Everyone, I have been starting to work with MonetDB for use with our large production database. It is a 'data warehouse' of sorts. Few comments: a) the php client was not included with built/binary distro b) user and password was not specified in http://www.monetdb.org/Documentation/monetdbd at "Next thing, making a connection to the database using mclient requires the -d argument to specify which database to connect to:" c) 'last crash' field is scary to sys admins/users :) I am going to investigate more, just wanted to pop my head in and say hello. As you can guess, our main dev platform is php, so I will need to be using the php extensions. Cheers, Charles

3 7

[MonetDB-users] alias error
by Jeremy O'Sullivan 07 Nov '11

07 Nov '11

Hello, The following syntax generates and error on the command line, is this correct ? The :w triggers the error. Regards, Jeremy select count(context_key) as "context_key:w" from context_dim;

1 0

[MonetDB-users] ODBC-Extended Fetch
by Jeremy O'Sullivan 07 Nov '11

07 Nov '11

Hello, When trying to connect to MonetDB using Oracle's OBI EE, I get the error below. Has anyone seen this before ? Regards, Jeremy [nQSError: 16001] ODBC error state: HYC00 code: 0 message: [MonetDB][ODBC Driver 11.5.7]Optional feature not implemented. [nQSError: 16006] Setting the statement option for extended fetch failed.

1 0