Re: is there a way to disable a specific check constraint without dropping it?

2017-06-19 Thread Rohit Jain
ented (old age ). For bulk loads it is probably more efficient to drop the constraint, load, and then add the constraint again. For incremental updates that becomes hard to do - just validating the new data. Rohit On Jun 19, 2017, at 3:32 PM, Anoop Sharma <anoop.sha...@esgyn.com<

Re: is there a way to disable a specific check constraint without dropping it?

2017-06-19 Thread Rohit Jain
Right, because re-enabling will have to recheck the constraint anyway. Rohit On Jun 19, 2017, at 1:26 PM, Eric Owhadi <eric.owh...@esgyn.com<mailto:eric.owh...@esgyn.com>> wrote: Hi Dave, It was a trick I was trying to use to store sql statement associated with a table as a check

RE: Make "HBase options" as default setting?

2017-06-07 Thread Rohit Jain
the compression, can we even articulate that? So, from ease of install, support, consistency of performance, etc. I think we should just go ahead and commit to SNAPPY. Rohit From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Wednesday, June 7, 2017 12:35 PM To: user

RE: Make "HBase options" as default setting?

2017-06-07 Thread Rohit Jain
, 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: does trafodion have null value in the index?

2017-06-01 Thread Rohit Jain
rules from what I understand. Rohit From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Thursday, June 1, 2017 10:04 AM To: user@trafodion.incubator.apache.org Subject: RE: does trafodion have null value in the index? traf indexes can be created on nullable columns and they can contain null

RE: MDAM on index

2016-03-28 Thread Rohit
.  Rohit Original message From: Dave Birdsall <dave.birds...@esgyn.com> Date: 03/28/2016 10:12 AM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: RE: MDAM on index Hi, In principle at least, MDAM should be possible with Query 2. Whether it is a goo

RE: 答复: Does Trafodion support to use 'order by' in a subquery

2016-03-24 Thread Rohit
with this one too until we have an artificial intelligent parser that can figure out exactly what you want. In that case migrating SQL from one database to another will not be necessary anymore.  In search of parser nirvana :-) Rohit Original message From: "Liu, Ming

RE: Upsert semantics

2016-03-22 Thread Rohit Jain
Unless I understood what is being proposed incorrectly where we don’t want to merge old values with new ones on an UPSERT, then that really is a DELSERT isn’t it? INSERT if not present, and DELETE and INSERT if it is. *From:* Rohit Jain [mailto:rohit.j...@esgyn.com] *Sent:* Tuesday, March 22

RE: 答复: DDL column DEFAULT question

2016-03-14 Thread Rohit
to document them in a certain sequence anyway, or because it is intentional and they wanted implementations to follow that sequence.  I could have created a JIRA on this. But the way our parser works, this is not a modest change, and this is something that can easily be rectified in the DDL.  Rohit

RE: [VOTE] Apache Trafodion Logo Proposal

2016-02-18 Thread Rohit
+1-13 Rohit Original message From: Roberta Marton <roberta.mar...@esgyn.com> Date: 02/18/2016 8:01 PM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: [VOTE] Apache Trafodion Logo Proposal There has been quite a lot of discussion on our use

Re: 答复: 答复: Logo Proposal

2016-02-14 Thread Rohit
+1 for 13 Rohit Original message From: Ken Holt <knhknhknh...@gmail.com> Date: 02/13/2016 6:49 PM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: Re: 答复: 答复: Logo Proposal Hi All,   A new set of Trafodion logo options are attached, taking a

Re: Logo Proposal

2016-02-12 Thread Rohit
-1 Check out the other logos I sent to the internal dlist.  Rohit Original message From: Gunnar Tapper <tapper.gun...@gmail.com> Date: 02/12/2016 12:50 AM (GMT-06:00) To: user@trafodion.incubator.apache.org Subject: Re: Logo Proposal Hi, I suggest that we

Re: Logo Proposal

2016-02-12 Thread Rohit
It depends on how much value you think Apache adds to Trafodion, as compared to those other logos that perhaps already have some cachet.  I feel that it adds quite a bit of value to Trafodion. Rohit Original message From: Qifan Chen <qifan.c...@esgyn.com> Date: