[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=15850217#comment-15850217 ] 

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

Github user asfgit closed the pull request at:

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


> 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.15#6346)