You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/02/01 04:06:51 UTC

[jira] [Commented] (TRAFODION-2467) HBase region start key straddling a datetime key value gives error or crashes

    [ https://issues.apache.org/jira/browse/TRAFODION-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15847988#comment-15847988 ] 

ASF GitHub Bot commented on TRAFODION-2467:
-------------------------------------------

GitHub user zellerh opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/941

    [TRAFODION-2467] HBase region start key straddling a datetime key error

    Make sure we complete a partial region start key for a datetime column
    such that year, month and day are set to at least 1.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/zellerh/incubator-trafodion bug/cses_jan-17

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/941.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #941
    
----
commit 911ca41ad8c073285665f4c6eb128b2e0e5030fb
Author: Hans Zeller <hz...@apache.org>
Date:   2017-02-01T04:00:17Z

    [TRAFODION-2467] HBase region start key straddling a datetime key error
    
    Make sure we complete a partial region start key for a datetime column
    such that year, month and day are set to at least 1.

----


> HBase region start key straddling a datetime key value gives error or crashes
> -----------------------------------------------------------------------------
>
>                 Key: TRAFODION-2467
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2467
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.0-incubating
>         Environment: Any
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>
> There is no simple test case for this, but Wei-Shiun has observed a problem that fits the theory, and I was able to force a problem in a debugger.
> The issue is this: HBase creates region start keys, and the length of those keys may provide only a part (a prefix) of a column value. So, HBase may have a 2 byte region start key of \x07\xCE for a table with a DATE key. This provides the year, 1998 in this case, but not month or day. Normally, we extend this partial key with zeroes for most data types, including date/time/timestamp. However, for these datetime types we need to add logic that set the year, month and day fields to 1 if extending the key with zeroes would make it 0 otherwise.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)