[jira] [Commented] (TRAFODION-2908) create table with wrong char length hang and crash

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

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

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

GitHub user traflm opened a pull request:

    https://github.com/apache/trafodion/pull/1441

    [TRAFODION-2908] create table with wrong char length hang and crash

    add a check if the key length is too long report error. Otherwise, SQL will go into a very long process to build the encoded key and finally failed. And in some cases crash, it makes little sense to check why it crash, so just add check and return error when key is too long.
    HBase max rowkey len is 32K, so it is the hard limit for now.

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

    $ git pull https://github.com/traflm/trafodion TRAFODION-2908

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

    https://github.com/apache/trafodion/pull/1441.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 #1441
    
----
commit 5f5808ab9d66bc2fba02292b3a0e5c371d3f5678
Author: Liu Ming <ov...@...>
Date:   2018-02-05T08:11:50Z

    [TRAFODION-2908] create table with wrong char length hang and crash

----


> create table with wrong char length hang and crash
> --------------------------------------------------
>
>                 Key: TRAFODION-2908
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2908
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Major
>
> create table test1 
> (
>   c1 char(30) not null,
>   c2 char(20) not null,
>   c3 char(20) not null,
>   c4 largeint,
>   c5 char(30) character set utf8 not null,
>   c6 char(125304) character set utf8 not null,
> c7 largeint,
>   primary key(c1,c2,c3,c5,c6))
> SALT USING 24 PARTITIONS on (c3)
> ;
> will hang
> and some processes crash



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)