| /* |
| * Licensed to the Apache Software Foundation (ASF) under one or more |
| * contributor license agreements. See the NOTICE file distributed with |
| * this work for additional information regarding copyright ownership. |
| * The ASF licenses this file to You under the Apache License, Version 2.0 |
| * (the "License"); you may not use this file except in compliance with |
| * the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| |
| package org.apache.ignite.internal.processors.query; |
| |
| import java.util.Collections; |
| import java.util.List; |
| import java.util.concurrent.Callable; |
| import org.apache.ignite.IgniteCache; |
| import org.apache.ignite.Ignition; |
| import org.apache.ignite.cache.QueryEntity; |
| import org.apache.ignite.cache.affinity.rendezvous.RendezvousAffinityFunction; |
| import org.apache.ignite.cache.query.SqlFieldsQuery; |
| import org.apache.ignite.cache.query.annotations.QuerySqlField; |
| import org.apache.ignite.configuration.CacheConfiguration; |
| import org.apache.ignite.configuration.IgniteConfiguration; |
| import org.apache.ignite.internal.processors.cache.index.AbstractIndexingCommonTest; |
| import org.apache.ignite.testframework.GridTestUtils; |
| import org.junit.Test; |
| |
| /** |
| * Tests for GROUP_CONCAT aggregate function in not collocated mode. |
| */ |
| @SuppressWarnings("unchecked") |
| public class IgniteSqlGroupConcatNotCollocatedTest extends AbstractIndexingCommonTest { |
| /** */ |
| private static final int CLIENT = 7; |
| |
| /** */ |
| private static final String CACHE_NAME = "cache"; |
| |
| /** {@inheritDoc} */ |
| @Override protected IgniteConfiguration getConfiguration(String igniteInstanceName) throws Exception { |
| IgniteConfiguration cfg = super.getConfiguration(igniteInstanceName); |
| |
| cfg.setCacheConfiguration( |
| new CacheConfiguration(CACHE_NAME) |
| .setAffinity(new RendezvousAffinityFunction().setPartitions(8)) |
| .setQueryEntities(Collections.singletonList(new QueryEntity(Key.class, Value.class)))); |
| |
| return cfg; |
| } |
| |
| /** {@inheritDoc} */ |
| @Override protected void beforeTestsStarted() throws Exception { |
| startGridsMultiThreaded(3, false); |
| |
| Ignition.setClientMode(true); |
| try { |
| startGrid(CLIENT); |
| } |
| finally { |
| Ignition.setClientMode(false); |
| } |
| |
| IgniteCache c = grid(CLIENT).cache(CACHE_NAME); |
| |
| int k = 0; |
| |
| for (int grp = 1; grp < 7; ++grp) { |
| for (int i = 0; i < grp; ++i) { |
| c.put(new Key(k, grp), new Value(k, Character.toString((char)('A' + k)))); |
| |
| k++; |
| } |
| } |
| } |
| |
| /** |
| * |
| */ |
| @Test |
| public void testGroupConcatSimple() { |
| IgniteCache c = ignite(CLIENT).cache(CACHE_NAME); |
| |
| List<List<Object>> res = c.query( |
| new SqlFieldsQuery("select grp, GROUP_CONCAT(str0) from Value group by grp")).getAll(); |
| |
| for (List<Object> row : res) { |
| int grp = (int)row.get(0); |
| |
| String str = (String)row.get(1); |
| |
| for (int i = 0; i < grp; ++i) { |
| String s = "" + (char)('A' + i + (grp - 1) * grp / 2); |
| |
| assertTrue("Invalid group_concat result: string doesn't contain value: " + |
| "[str=" + str + ", val=" + s , str.contains(s)); |
| } |
| } |
| } |
| |
| /** |
| * |
| */ |
| @Test |
| public void testGroupConcatCountDistinct() { |
| IgniteCache c = ignite(CLIENT).cache(CACHE_NAME); |
| |
| List<List<Object>> res = c.query( |
| new SqlFieldsQuery("select count(distinct str0), group_concat(str0) from Value group by grp")).getAll(); |
| |
| for (List<Object> row : res) { |
| long cnt = (long)row.get(0); |
| |
| String str = (String)row.get(1); |
| |
| for (int i = 0; i < cnt; ++i) { |
| String s = "" + (char)('A' + i + (cnt - 1) * cnt / 2); |
| |
| assertTrue("Invalid group_concat result: string doesn't contain value: " + |
| "[str=" + str + ", val=" + s , str.contains(s)); |
| } |
| } |
| } |
| |
| /** |
| * |
| */ |
| @Test |
| public void testGroupConcatDistributedException() { |
| final IgniteCache c = ignite(CLIENT).cache(CACHE_NAME); |
| |
| GridTestUtils.assertThrowsAnyCause(log, new Callable<Object>() { |
| @Override public Object call() { |
| c.query(new SqlFieldsQuery("select grp, GROUP_CONCAT(str0 ORDER BY str0) " + |
| "from Value group by grp")).getAll(); |
| |
| return null; |
| } |
| }, IgniteSQLException.class, "Clauses DISTINCT and ORDER BY are unsupported for GROUP_CONCAT " + |
| "for not collocated data"); |
| } |
| |
| /** |
| * |
| */ |
| public static class Key { |
| /** */ |
| @QuerySqlField |
| private int id; |
| |
| /** */ |
| @QuerySqlField |
| private int grp; |
| |
| /** |
| * @param id Id. |
| * @param grp Group. |
| */ |
| public Key(int id, int grp) { |
| this.id = id; |
| this.grp = grp; |
| } |
| } |
| |
| /** |
| * |
| */ |
| public static class Value { |
| /** */ |
| @QuerySqlField |
| private String str0; |
| |
| /** */ |
| @QuerySqlField |
| private String str1; |
| |
| /** */ |
| @QuerySqlField |
| private String strId; |
| |
| /** |
| * @param id Id. |
| * @param str String value. |
| */ |
| public Value(int id, String str) { |
| str0 = str; |
| str1 = str + "_1"; |
| strId = "id#" + id; |
| } |
| } |
| } |