[jira] [Commented] (TRAFODION-2464) failure to upsert into a table with an index

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

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

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

GitHub user sureshsubbiah opened a pull request:

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

    [TRAFODION-2464] failure to upsert into a table with an index

    During upsert into table with index there is a temporary scan in optimizer.
    If index access path is chosen for this scan, query would raise an error.
    This is now fixed by using the correct indexDesc from this temporary scan.

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

    $ git pull https://github.com/sureshsubbiah/incubator-trafodion upsert1

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

    https://github.com/apache/incubator-trafodion/pull/935.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 #935
    
----
commit db845285e3386ba5fc59c7a7726be3864b56f2ee
Author: Suresh Subbiah <su...@apache.org>
Date:   2017-01-27T20:37:14Z

    [TRAFODION-2464] failure to upsert into a table with an index
    
    During upsert into table with index there is a temporary scan in optimizer.
    If index access path is chosen for this scan, query would raise an error.
    This is now fixed by using the correct indexDesc from this temporary scan.

----


> failure to upsert into a table with an index
> --------------------------------------------
>
>                 Key: TRAFODION-2464
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2464
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.2-incubating
>            Reporter: Eric Owhadi
>         Attachments: osim.tar
>
>
> create table files
> (
> directory_id char(36) NOT NULL,
> name varchar(256) NOT NULL,
> fsize largeint,
> owner varchar(50),
> primary key (directory_id,name))
> SALT USING 8 partitions on (directory_id)
> HBASE_OPTIONS (DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY');
> create index files_idx_by_directory_id on files(name,directory_id)
> SALT LIKE TABLE 
> HBASE_OPTIONS (DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY');
> prepare s from upsert into files values (?,?,?,?);
> *** ERROR[3241] This MERGE statement is not supported. Reason:  Non-unique ON clause not allowed with INSERT. [2017-01-20 00:38:54]
> *** ERROR[8822] The statement was not prepared. [2017-01-20 00:38:54]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)