phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sumanta Gh <>
Subject Re: Phoenix vs Trafodion
Date Fri, 12 Sep 2014 12:15:33 GMT
"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?


From:   Flavio Pompermaier <>
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 you know when this is going to happen (more or less)?

On Fri, Sep 12, 2014 at 11:00 AM, James Taylor <> 
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.

On Fri, Sep 12, 2014 at 1:50 AM, Flavio Pompermaier
<> 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

View raw message