[test_case]
test = perfrunner.tests.n1ql.N1QLJoinThroughputTest

[showfast]
title = Q11, Complex Join, MOI, not_bounded
component = n1ql
category = join_unnest

[cluster]
mem_quota = 51200
index_mem_quota = 200000
initial_nodes = 6
num_buckets = 3

[compaction]
db_percentage = 100

[bucket]
replica_number = 0

[secondary]
indexer.settings.storage_mode = memory_optimized

[load]
items = 10000000
size = 1024
workers = 80
doc_gen = ext_reverse_lookup,join,ref

[index]
statements =
    CREATE INDEX by_capped ON `bucket-2`(capped);

[access]
creates = 0
reads = 0
updates = 100
deletes = 0
throughput = 7500
items = 10000000
workers = 20
time = 1200
n1ql_gen = join
n1ql_queries = complex-join
n1ql_workers = 360
workload_instances = 2

[n1ql-complex-join]
statement = SELECT u.email AS email, COUNT(t.title) FROM `bucket-2` t INNER JOIN `bucket-3` c ON META(c).id IN t.categories LEFT OUTER JOIN `bucket-1` u ON t.owner = META(u).id WHERE t.capped = $1 AND c.name = $2 GROUP BY u.email;
scan_consistency = not_bounded
args = ["{capped}","{categories[0]}"]

[clients]
libcouchbase = 2.9.3
python_client = 2.5.0