[ https://issues.apache.org/jira/browse/TRAFODION-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller resolved TRAFODION-2467. ------------------------------------ Resolution: Fixed > 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)