RE: on cursor

2017-11-21 Thread Dave Birdsall
be used in SJP, as Stored Procedures in Java (SPJs) Guide states, l I didn’t find ODBC reference, but I guess it is supported too, l cursor expression is not supported, right? Then I guess I know how much cursor is supported in Trafodion. Thank you very much. From: Dave Birdsall

RE: change the connection count

2017-07-31 Thread Dave Birdsall
Actual means that number of mxosrvrs are up and running. Down means some mxosrvrs did not come up. I’ll let others comment on what might cause mxsosrvrs to not come up. From: Huang, Jack [mailto:jack.hu...@dell.com] Sent: Sunday, July 30, 2017 9:26 PM To: user@trafodion.incubator.apache.org

RE: Make "HBase options" as default setting?

2017-06-07 Thread Dave Birdsall
FAULTS table are problematic for the reasons I mentioned. Of course, they would be in the compiler’s default settings. Rohit From: Dave Birdsall [mailto:dave.birds...@esgyn.com<mailto:dave.birds...@esgyn.com>] Sent: Wednesday, June 7, 2017 11:28 AM To: user@trafodion.incubator.apache.org<mailt

RE: Make "HBase options" as default setting?

2017-06-07 Thread Dave Birdsall
So, while the flexibility of having so many buttons may be a good thing to cover all possible theoretical combinations one might come up with, from a practical standpoint the KISS (Keep It Simple Stupid) principal trumps all. Rohit From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent:

RE: Make "HBase options" as default setting?

2017-06-07 Thread Dave Birdsall
What might make sense is to add a CQD (or maybe a set of them) with default values for certain HBASE_OPTIONS settings. Then one could put these CQDs in the system DEFAULTS table. So, you’d set it once in a cluster installation and then not have to worry about it afterwards. From: Dave Birdsall

RE: Make "HBase options" as default setting?

2017-06-07 Thread Dave Birdsall
-1 Snappy is often not installed on workstations, so I would not want to make that the default. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Wednesday, June 7, 2017 4:52 AM To: user@trafodion.incubator.apache.org Subject: Re: Make "HBase options" as default setting? +1 Sent from

RE: [Question]Does Trafodion support order by Chinese character?

2017-05-18 Thread Dave Birdsall
The order should reflect the encoding of the characters. Chinese characters are supported in two ways: via UTF-8 encoding (the default) and UCS2 encoding (which you get by specifying CHARACTER SET UCS2 in the column definition). So, when issuing ORDER BY, the order you get will be either UTF-8

RE: [Question]Does Trafodion support median() function as Oracle?

2017-05-08 Thread Dave Birdsall
I don't see any support for MEDIAN in the Trafodion SQL parser. From: Sean Broeder [mailto:sean.broe...@esgyn.com] Sent: Monday, May 8, 2017 9:15 AM To: user@trafodion.incubator.apache.org Subject: RE: [Question]Does Trafodion support median() function as Oracle? There is a getMedian()

RE: issue wtih foreign keys

2017-03-16 Thread Dave Birdsall
(derivative of trafodion), both with autocommit on or off, this set of create table work fine. Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, March 16, 2017 10:33 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: issu

RE: issue wtih foreign keys

2017-03-16 Thread Dave Birdsall
Hi Mathieu, Error 8838 usually indicates a core in the tdm_arkcmp process. So you're likely running into a bug. What version of Trafodion are you using? (What banner comes up when you enter, sqlci?) I tried your CREATE statements in the latest version of Trafodion and they worked for me.

RE: question on using Batch for a select statement with jdbc

2017-01-18 Thread Dave Birdsall
“the above query is not generating nested join plan because my table d is empty still. I am hoping it will do NJ as soon as I have some real data and updated stats… “ You probably cannot infer that you’re not getting nested join due to lack of data in the table if the table is a Trafodion

RE: Put docker image in Trafodion website

2016-11-30 Thread Dave Birdsall
Copying dev list. This is one of the things Gunnar knows. From: Christophe Le Rouzo [mailto:c...@esgyn.com] Sent: Wednesday, November 30, 2016 9:07 AM To: user@trafodion.incubator.apache.org Subject: RE: Put docker image in Trafodion website Makes sense Eason, from what I recall it’s complicated

RE: [apache/incubator-trafodion] [TRAFODION-1519]Use free tool to build windows ODBC (#116)

2016-10-04 Thread Dave Birdsall
Forwarding this to the Trafodion user list. *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, October 4, 2016 8:22 AM *To:* 'u...@hbase.apache.org' <u...@hbase.apache.org>; 'helloHuiW' < notificati...@github.com> *Cc:* 'Mention' <ment...@noreply.github.com

Trafodion backup question

2016-06-16 Thread Dave Birdsall
Hi, This morning I used Trafodion backup to create a backup of my development instance. I didn’t know the syntax of what it wanted for a backup directory, so I let it pick. It told me what it picked, but unfortunately did so at the very beginning, and that scrolled off. And I wasn’t smart

RE: Cannot find Trafodion 2.0 at http://trafodion.incubator.apache.org/download.html#download

2016-06-16 Thread Dave Birdsall
*From:* Dave Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Thursday, June 16, 2016 8:30 AM *To:* 'user@trafodion.incubator.apache.org' < user@trafodion.incubator.apache.org> *Subject:* RE: Cannot find Trafodion 2.0 at http://trafodion.incubator.apache.org/download.html#download I wil

RE: Cannot find Trafodion 2.0 at http://trafodion.incubator.apache.org/download.html#download

2016-06-16 Thread Dave Birdsall
I will look into it. Dave *From:* Steve Varnau [mailto:steve.var...@esgyn.com] *Sent:* Thursday, June 16, 2016 1:53 AM *To:* user@trafodion.incubator.apache.org *Subject:* Re: Cannot find Trafodion 2.0 at http://trafodion.incubator.apache.org/download.html#download I updated the download

RE: Upsert semantics

2016-03-15 Thread Dave Birdsall
. Example: UPSERT INTO TEST VALUES('foo','bar',3); UPSERT INTO TEST(NAME,ID) VALUES('foo',123); *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, March 15, 2016 2:55 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: Upsert semantics Hi, It seems that when

RE: Upsert semantics

2016-03-15 Thread Dave Birdsall
Hi, It seems that when ANSI first added MERGE to the standard, it was portrayed as “upsert” (see https://en.wikipedia.org/wiki/Merge_(SQL)). I agree though that we are free to define our UPSERT to mean anything we want. I like what you suggest. Since our UPSERT syntax already specifies

RE: 答复: where to download Trafodion odbc/jdbc install package?

2016-03-15 Thread Dave Birdsall
carol.pearson...@gmail.com Twitter: @CarolP222 --- On Tue, Mar 15, 2016 at 8:21 AM, Dave Birdsall <dave.birds...@esgyn.com> wrote: Maybe it would be useful to list on the download page what’s in the Clients package? *From:* Gun

RE: 答复: 答复: Logo Proposal

2016-02-16 Thread Dave Birdsall
Jian Jin (Seth) 1 Christophe LeRouzo 1 1 Prashanth Vasudev 1 1 Dave Birdsall 1 Kevin DeYager 1 14 10 3 1 On Tue, Feb 16, 2016 at 9:52 AM, Gunnar Tapper <tapper.gun...@gmail.com> wrote: +1 On Tue, Feb 16, 2016 at 10:38 AM, Steve Varnau <steve.var...@esgyn.c

RE: Logo Proposal

2016-02-11 Thread Dave Birdsall
zo <c...@esgyn.com> wrote: Thanks Ken, the standalone dragon looks really good. It complements really well the yellow elephant! Regards, -clr *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, February 9, 2016 9:53 AM *To:* user@trafodion.incubator.apache.org *Subject:* RE: Log

RE: nullable primary key index column?

2016-02-02 Thread Dave Birdsall
Hi Eric, Just curious: What is your use case? Why do you need a nullable primary key column? Dave *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 11:43 AM *To:* user@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column?