Re: [ANNOUNCEMENT] liu Yu and Sean Broeder join the committer pool of the Apache Trafodion Project

Congratulations Liu Yu and Sean. Best regards, Suresh On Fri, Feb 2, 2018 at 1:37 PM, Dave Birdsall wrote: > Congratulations to Sean Broader and Liu Yu for becoming committers! > > -Original Message- > From: Carol Pearson [mailto:carol.pearson...@gmail.com] >

Re: how to read debug info after set SUBQUERY_UNNESTING to 'debug'

Hi Ming, The warning messages should show on the screen if we are using sqlci or trafci. The methods used internally is the same as that used to raise any other warning during compilation, say like a missing stats warning. If no messages are seen on screen, then that means there are no correlated

Re: how to read debug info after set SUBQUERY_UNNESTING to 'debug'

Hi Ming, When I try this query I get this plan create table t1 (a1 int not null, a2 int not null); create table t2 (a1 int not null, a2 int not null); cqd subquery_unnesting 'debug' ; explain options 'f' select * from t1 where not exists (select * from t2 where t2.a2 = t1.a1 ); LC RC OP

Re: what is the difference between hbase option COMPACT_COMPRESSION and COMPRESSION

Hi, These are options HBase allows on Create Table. Trafodion passes these options to the HBase layer as mentioned by Dave an others. COMPRESSION specifies the type of compression that will be used to compress data in HFiles (produced my memstore flushes or bulk load writes) COMPACT_COMPRESSION

Re: Upcoming 2.2.0 release

Hi, The warnings raised by JIRA are using this filter project = 12318620 AND fixVersion = 12338559 AND statusCategory = done AND issue.property[development].commits > 0 AND issue.property[development].reviews = 0 ORDER BY priority DESC, key ASC It seems that if we have a review where we simply

Re: How to get vsbb_scan plan?

Hi Yuan, Yes, nested join on primary key is the only case I can think of too. We need a full key match on the predicate, there also has to be multiple requests so that the result contains more than one row, even with a full key predicate. I think nested join on primary key is the only case.

Re: CONNECT BY syntax change

Hi, I would like to learn from this change by Ming. Hope to be done with the review by the end of this week. Thank you Suresh On Wed, Sep 26, 2018 at 3:25 PM Dave Birdsall wrote: > Hi, > > I've been away from Trafodion for a little while. Did some reviews today > to catch up. > > One change I

Re: [VOTE] Apache Trafodion Release 2.4 is ready for release - release candidate 1 (RC1)

+1 (binding) Thank you for doing this Selva.. I downloaded from all the links pointed to from the page above. I compared the directory sizes between 2.3 RC2 and 2.4 RC1. I cannot do a build now since my Linux env is not ready. It will take me a couple more days to do that. Thank you Suresh On