"The problem with Trafodion SQL tables is that they use a fixed format to represent column values,
making it harder for native HBase applications to access them. Also, they have a fixed structure, so users lose the flexibility of dynamic columns that comes with HBase." - as per their API Ref Guide. In this regard, I have a question to Phoenix user group. If I have a table with multiple dynamic columns and I do not know the dynamic column names while querying, is it possible to fetch a complete row (static + dynamic columns) in a single query? Regards Sumanta From: Flavio Pompermaier <[email protected]> To: [email protected] Date: 09/12/2014 02:47 PM Subject: Re: Phoenix vs Trafodion Yes, that was a strong poin in favour of Phoenix. But Trafodion tells that they support transaction and that was interesting.. However it looks like a early-staging project, while Phoenix is much more mature I think. I've also read that Phoenix is going to support transaction in the future..do you know when this is going to happen (more or less)? On Fri, Sep 12, 2014 at 11:00 AM, James Taylor <[email protected]> wrote: Hi Flavio, We haven't done any comparison yet, but if you get a chance, please report back. I think you'll need to use the 0.94 version of HBase, though, as I don't believe Trafodion supports 0.98. Thanks, James On Fri, Sep 12, 2014 at 1:50 AM, Flavio Pompermaier <[email protected]> wrote: > Hi to all, > > I'm currently trying to figure it out the pros and cons of the two JDBC > drivers for HBase. > Is there any comparison about that? > > Best, > FP =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
