Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Stack]

On Wed, Mar 30, 2016 at 9:25 AM, Gunnar Tapper 
wrote:

> An API that wraps the new API with the old interface thereby ensuring that
> clients don't have to change just because the underlying software changed.
>

No.

API is a constant inside a major version, 1.x or 2.x, etc., but can change
across major versions. HBase (almost) does http://semver.org/

Having a wrapper for hbase 5.0 API so 1.0 clients don't have to change
would be untenable or, if not that, a significant undertaking tough to
resource in an open source project (who'd want to work on it?).

St.Ack



> On Mar 30, 2016 9:09 AM, "Stack"  wrote:
>
>> On Wed, Mar 30, 2016 at 8:11 AM, Gunnar Tapper 
>> wrote:
>>
>>> It's 1.x AFAIK.
>>>
>>> HBase doesn't provide compatibility APIs, eh? Something to consider in
>>> the future maybe.
>>>
>>>
>> What is a compatibility API?
>> St.Ack
>>
>>
>>
>>> Gunnar
>>>
>>> On Tue, Mar 29, 2016 at 8:47 PM, Stack  wrote:
>>>
 On Tue, Mar 29, 2016 at 2:17 PM, Carol Pearson <
 carol.pearson...@gmail.com> wrote:

> Hi Trafodion Users,
>
> As Trafodion Release 2.0 comes together, it's a challenge to make
> Trafodion work with both HBase 0.98 and HBase 1.1 in the same code base.
>
> From discussions among Trafodion developers over on the dev list, the
> resolution is that the upcoming 2.0 release will work with HBase 1.1 and
> forward ONLY.  That is, there is no current way to use HBase 0.98 in the
> upcoming Trafodion 2.0 release, coming very soon.
>
>

 Sounds good. Could you get away with T* 2.0 works w/ HBase 1.x rather
 than 1.1?  The API is fixed in hbase 1.x. Coprocessors though could change
 across minor versions 1.1 => 1.2 which might mess you up.

 St.Ack



> If you want to use Trafodion with HBase 0.98, that code path is based
> on the Trafodion 1.3 release which is currently available. Trafodion
> Release 1.3 does NOT work with HBase 1.1.
>
> -Carol P.
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>


>>>
>>>
>>> --
>>> Thanks,
>>>
>>> Gunnar
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>>

Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Gunnar Tapper]

An API that wraps the new API with the old interface thereby ensuring that
clients don't have to change just because the underlying software changed.
On Mar 30, 2016 9:09 AM, "Stack"  wrote:

> On Wed, Mar 30, 2016 at 8:11 AM, Gunnar Tapper 
> wrote:
>
>> It's 1.x AFAIK.
>>
>> HBase doesn't provide compatibility APIs, eh? Something to consider in
>> the future maybe.
>>
>>
> What is a compatibility API?
> St.Ack
>
>
>
>> Gunnar
>>
>> On Tue, Mar 29, 2016 at 8:47 PM, Stack  wrote:
>>
>>> On Tue, Mar 29, 2016 at 2:17 PM, Carol Pearson <
>>> carol.pearson...@gmail.com> wrote:
>>>
 Hi Trafodion Users,

 As Trafodion Release 2.0 comes together, it's a challenge to make
 Trafodion work with both HBase 0.98 and HBase 1.1 in the same code base.

 From discussions among Trafodion developers over on the dev list, the
 resolution is that the upcoming 2.0 release will work with HBase 1.1 and
 forward ONLY.  That is, there is no current way to use HBase 0.98 in the
 upcoming Trafodion 2.0 release, coming very soon.


>>>
>>> Sounds good. Could you get away with T* 2.0 works w/ HBase 1.x rather
>>> than 1.1?  The API is fixed in hbase 1.x. Coprocessors though could change
>>> across minor versions 1.1 => 1.2 which might mess you up.
>>>
>>> St.Ack
>>>
>>>
>>>
 If you want to use Trafodion with HBase 0.98, that code path is based
 on the Trafodion 1.3 release which is currently available. Trafodion
 Release 1.3 does NOT work with HBase 1.1.

 -Carol P.
 ---
 Email:carol.pearson...@gmail.com
 Twitter:  @CarolP222
 ---

>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>

Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Stack]

On Wed, Mar 30, 2016 at 8:11 AM, Gunnar Tapper 
wrote:

> It's 1.x AFAIK.
>
> HBase doesn't provide compatibility APIs, eh? Something to consider in the
> future maybe.
>
>
What is a compatibility API?
St.Ack



> Gunnar
>
> On Tue, Mar 29, 2016 at 8:47 PM, Stack  wrote:
>
>> On Tue, Mar 29, 2016 at 2:17 PM, Carol Pearson <
>> carol.pearson...@gmail.com> wrote:
>>
>>> Hi Trafodion Users,
>>>
>>> As Trafodion Release 2.0 comes together, it's a challenge to make
>>> Trafodion work with both HBase 0.98 and HBase 1.1 in the same code base.
>>>
>>> From discussions among Trafodion developers over on the dev list, the
>>> resolution is that the upcoming 2.0 release will work with HBase 1.1 and
>>> forward ONLY.  That is, there is no current way to use HBase 0.98 in the
>>> upcoming Trafodion 2.0 release, coming very soon.
>>>
>>>
>>
>> Sounds good. Could you get away with T* 2.0 works w/ HBase 1.x rather
>> than 1.1?  The API is fixed in hbase 1.x. Coprocessors though could change
>> across minor versions 1.1 => 1.2 which might mess you up.
>>
>> St.Ack
>>
>>
>>
>>> If you want to use Trafodion with HBase 0.98, that code path is based on
>>> the Trafodion 1.3 release which is currently available. Trafodion Release
>>> 1.3 does NOT work with HBase 1.1.
>>>
>>> -Carol P.
>>> ---
>>> Email:carol.pearson...@gmail.com
>>> Twitter:  @CarolP222
>>> ---
>>>
>>
>>
>
>
> --
> Thanks,
>
> Gunnar
> *If you think you can you can, if you think you can't you're right.*
>

Re: converting INTEGER to CHAR in Trafodion

[Liu, Ming (Ming)]

Thanks Anoop for the help again :) Yes, I forgot CAST …

发件人: Anoop Sharma [mailto:anoop.sha...@esgyn.com]
发送时间: 2016年3月30日 22:04
收件人: user@trafodion.incubator.apache.org
主题: RE: converting INTEGER to CHAR in Trafodion

Trafodion supports to_date and to_char to convert datetime  values from string 
to datetime, or datetime to string.
It does not support all of oracle to_date/to_char functionality/formats, but a 
subset of it.
One can also use CAST function to convert from numeric from/to string.

For the 2 examples, you can use to_char to convert from DATE to string.
And use CAST to convert from numeric to string.

>>select to_char(date '2016-10-10', '/MM/DD') from (values(1)) X(a);

(EXPR)
--

2016/10/10

--- 1 row(s) selected.
>>select cast(123 as char(3)) from (values(1)) x(a);

(EXPR)
--

123

--- 1 row(s) selected.
>>

From: Liu, Ming (Ming) [mailto:ming@esgyn.cn]
Sent: Wednesday, March 30, 2016 5:12 AM
To: 
user@trafodion.incubator.apache.org
Subject: converting INTEGER to CHAR in Trafodion

Hi, all,

I know it will be much easier to do in C or Java after get the result set, but 
the Oracle users are used to use to_char() function. Is there similar function 
in Trafodion?

Or maybe we can write a UDF for it, but the problem of UDF is it cannot support 
polymorphism, that is, one can only define the syntax/signature of a UDF once, 
is it true?
For example, it cannot define a TO_CHAR that can :
TO_CHAR(123), return is ‘123’.
TO_CHAR(date’2001/11/11’,’/MM/DD’), return is ‘2001-11-11’.

Seems rather difficult to replace Oracle’s TO_CHAR completely.

Or I miss something? Thanks in advance.

Thanks,
Ming

converting INTEGER to CHAR in Trafodion

[Liu, Ming (Ming)]

Hi, all,

I know it will be much easier to do in C or Java after get the result set, but 
the Oracle users are used to use to_char() function. Is there similar function 
in Trafodion?

Or maybe we can write a UDF for it, but the problem of UDF is it cannot support 
polymorphism, that is, one can only define the syntax/signature of a UDF once, 
is it true?
For example, it cannot define a TO_CHAR that can :
TO_CHAR(123), return is '123'.
TO_CHAR(date'2001/11/11','/MM/DD'), return is '2001-11-11'.

Seems rather difficult to replace Oracle's TO_CHAR completely.

Or I miss something? Thanks in advance.

Thanks,
Ming