[jira] [Commented] (ASTERIXDB-1738) Change feed fails to delete record with meta PK

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

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

ASF subversion and git services commented on ASTERIXDB-1738:
------------------------------------------------------------

Commit d195de1443b0ccf8222770452cced8bcb5c25d5f in asterixdb's branch refs/heads/master from [~iabsalyamov]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=d195de1 ]

Fix for ASTERIXDB-1738: Change feed fails to delete record with meta PK

Change-Id: I5ce8d9c69f96593ee305cfad4b44e486c9f1d6cc
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1351
Reviewed-by: abdullah alamoudi <ba...@gmail.com>
Sonar-Qube: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
BAD: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>


> Change feed fails to delete record with meta PK
> -----------------------------------------------
>
>                 Key: ASTERIXDB-1738
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1738
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Ildar Absalyamov
>
> I am trying to create the following dataset with meta PK and feed in data to it using change-feed localFS adapter
> {noformat}
> drop dataverse test if exists;
> create dataverse test;
> use dataverse test;
> create type TestType as closed {
>     test: string
> }
> create type MetaType as {
> id:int
> }
> create dataset TestDS(TestType) with meta(MetaType) primary key meta().id;
> create index TestIdx on TestDS(test);
> drop feed TestFeed if exists;
> create feed TestFeed using adapter
> (
>     ("parser"="record-with-metadata"),
>     ("reader"="localfs"),
>     ("path"="localhost:///ABSOLUTE_PATH/test.adm"),
>     //type of the record
>     ("type-name"="TestType"),
>     //type of the meta record
>     ("meta-type-name"="MetaType"),
>     //format of the record
>     ("record-format"="adm"),
>     // format of the meta record
>     ("format"="csv"),
>     ("delimiter"=","),
>     // index of the primary key the record (meta or orig)
>     ("key-indexes"="0"),
>     // indicates that PK originates from meta
>     ("key-indicators"="1"),
> 	//index of the record in the meta record
>     ("record-index"="1"),
>     ("change-feed"="true"),
>     // whether CSV header is present in the input
>     ("header"="false")
> );
> set wait-for-completion-feed "false";
> connect feed TestFeed to dataset TestDS;
> {noformat}
> Contents of the test.adm:
> {noformat}
> 1,"{""test"":""test1""}"
> 2,"{""test"":""test2""}"
> 3,"{""test"":""test3""}"
> 3,
> 2,"{""test"":""test4""}"
> {noformat}
> Ingestion is able to update the record with id=2, but fails to delete the third record:
> {noformat}
> for $x in dataset TestDS return {"record": $x, "id": meta().id}
> {noformat}
> Result:
> {noformat}
> { "record": { "test": "test1" }, "id": 1 }
> { "record": { "test": "test4" }, "id": 2 }
> { "record": { "test": "test3" }, "id": 3 }
> {noformat}



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