Dmitry Lychagin created ASTERIXDB-2969:
------------------------------------------
Summary: Failure in ArrayIndexRQGIT
Key: ASTERIXDB-2969
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2969
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Affects Versions: 0.9.7
Reporter: Dmitry Lychagin
Assignee: Glenn Justo Galvizo
Fix For: 0.9.7
Failure in SqlppArrayIndexRQGTest.
https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-openjdk11/org.apache.asterix$asterix-app/5173/testReport/junit/org.apache.asterix.test.array/SqlppArrayIndexRQGTest/test_ArrayIndexRQGIT_21___3__/
{noformat}
Error Message
Index testIndex is not being used.
Stacktrace
java.lang.AssertionError: Index testIndex is not being used.
at
org.apache.asterix.test.array.SqlppArrayIndexRQGTest.test(SqlppArrayIndexRQGTest.java:336)
Standard Output
17:02:39.130 [main] SqlppArrayIndexRQGTest -
-------------------------------------------------------
Test Case Name: #21
Test Type: JOIN
Test Order: INSERT -> CREATE INDEX -> QUERY
Indexed Elements:
Element #0:
Kind: UNNEST_OBJECT
UNNEST Field: container_object_1.nesting_1 [NONE]
PROJECT Field:
container_object_1.string_rand_26_b.contained_object_1 [string_rand_26_b]
PROJECT Field:
container_object_2.double_rand_10.contained_object_1 [double_rand_10]
Indexed Query:
Starting FROM Expr:
Dataset Name: ProbeDataset1
As Alias: D2
Join Step:
Subquery FROM Expr:
Dataset Name: IndexedDataset
As Alias: D1
Subquery UNNEST Step:
Source Alias: D1
Array Field: container_object_1.nesting_1
As Alias: G1
Select Expr:
Expr: D2._id
As Alias: PK2
-------------------------------------------------------
17:02:39.457 [main] SqlppArrayIndexRQGTest - Optimized query plan:
distribute result [$$70]
-- DISTRIBUTE_RESULT |UNPARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
limit 100
-- STREAM_LIMIT |UNPARTITIONED|
project ([$$70])
-- STREAM_PROJECT |PARTITIONED|
assign [$$70] <- [{"PK2": $$73}]
-- ASSIGN |PARTITIONED|
exchange
-- SORT_MERGE_EXCHANGE [$$73(ASC) ] |PARTITIONED|
limit 100
-- STREAM_LIMIT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
order (topK: 100) (ASC, $$73)
-- STABLE_SORT [topK: 100] [$$73(ASC)] |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$73])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
left outer join (and(eq($$80, $$75), eq($$80, $$76)))
-- NESTED_LOOP |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
project ([$$73, $$75, $$76])
-- STREAM_PROJECT |PARTITIONED|
assign [$$76, $$75] <-
[numeric-add(to-double($$D2.getField("integer_rand_10")), 0.5),
codepoint-to-string(ordered-list-constructor(numeric-add(100,
$$D2.getField("string_rand_26_b"))))]
-- ASSIGN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$73, $$D2] <-
TestDataverse.ProbeDataset1
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
empty-tuple-source
-- EMPTY_TUPLE_SOURCE |PARTITIONED|
exchange
-- BROADCAST_EXCHANGE |PARTITIONED|
project ([$$80])
-- STREAM_PROJECT |PARTITIONED|
assign [$$80] <-
[$$G1.getField("container_object_1").getField("string_rand_26_b").getField("contained_object_1")]
-- ASSIGN |PARTITIONED|
project ([$$G1])
-- STREAM_PROJECT |PARTITIONED|
unnest $$G1 <- scan-collection($$79)
-- UNNEST |PARTITIONED|
project ([$$79])
-- STREAM_PROJECT |PARTITIONED|
assign [$$79] <-
[$$D1.getField("container_object_1").getField("nesting_1")]
-- ASSIGN |PARTITIONED|
project ([$$D1])
-- STREAM_PROJECT |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$74, $$D1] <-
TestDataverse.IndexedDataset
-- DATASOURCE_SCAN |PARTITIONED|
exchange
-- ONE_TO_ONE_EXCHANGE
|PARTITIONED|
empty-tuple-source
-- EMPTY_TUPLE_SOURCE
|PARTITIONED|
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
