/* * 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.cassandra.cql3; import java.util.ArrayList; import java.util.List; import java.util.stream.Collectors; import org.apache.cassandra.schema.ColumnMetadata; import org.apache.cassandra.schema.TableMetadata; import org.apache.cassandra.cql3.Term.MultiColumnRaw; import org.apache.cassandra.cql3.Term.Raw; import org.apache.cassandra.cql3.restrictions.MultiColumnRestriction; import org.apache.cassandra.cql3.restrictions.Restriction; import org.apache.cassandra.cql3.statements.Bound; import org.apache.cassandra.exceptions.InvalidRequestException; import static org.apache.cassandra.cql3.statements.RequestValidations.checkFalse; import static org.apache.cassandra.cql3.statements.RequestValidations.checkTrue; import static org.apache.cassandra.cql3.statements.RequestValidations.invalidRequest; /** * A relation using the tuple notation, which typically affects multiple columns. * Examples: * {@code * - SELECT ... WHERE (a, b, c) > (1, 'a', 10) * - SELECT ... WHERE (a, b, c) IN ((1, 2, 3), (4, 5, 6)) * - SELECT ... WHERE (a, b) < ? * - SELECT ... WHERE (a, b) IN ? * } */ public class MultiColumnRelation extends Relation { private final List<ColumnMetadata.Raw> entities; /** A Tuples.Literal or Tuples.Raw marker */ private final Term.MultiColumnRaw valuesOrMarker; /** A list of Tuples.Literal or Tuples.Raw markers */ private final List<? extends Term.MultiColumnRaw> inValues; private final Tuples.INRaw inMarker; private MultiColumnRelation(List<ColumnMetadata.Raw> entities, Operator relationType, Term.MultiColumnRaw valuesOrMarker, List<? extends Term.MultiColumnRaw> inValues, Tuples.INRaw inMarker) { this.entities = entities; this.relationType = relationType; this.valuesOrMarker = valuesOrMarker; this.inValues = inValues; this.inMarker = inMarker; } /** * Creates a multi-column EQ, LT, LTE, GT, or GTE relation. * {@code * For example: "SELECT ... WHERE (a, b) > (0, 1)" * } * @param entities the columns on the LHS of the relation * @param relationType the relation operator * @param valuesOrMarker a Tuples.Literal instance or a Tuples.Raw marker * @return a new <code>MultiColumnRelation</code> instance */ public static MultiColumnRelation createNonInRelation(List<ColumnMetadata.Raw> entities, Operator relationType, Term.MultiColumnRaw valuesOrMarker) { assert relationType != Operator.IN; return new MultiColumnRelation(entities, relationType, valuesOrMarker, null, null); } /** * Creates a multi-column IN relation with a list of IN values or markers. * For example: "SELECT ... WHERE (a, b) IN ((0, 1), (2, 3))" * @param entities the columns on the LHS of the relation * @param inValues a list of Tuples.Literal instances or a Tuples.Raw markers * @return a new <code>MultiColumnRelation</code> instance */ public static MultiColumnRelation createInRelation(List<ColumnMetadata.Raw> entities, List<? extends Term.MultiColumnRaw> inValues) { return new MultiColumnRelation(entities, Operator.IN, null, inValues, null); } /** * Creates a multi-column IN relation with a marker for the IN values. * For example: "SELECT ... WHERE (a, b) IN ?" * @param entities the columns on the LHS of the relation * @param inMarker a single IN marker * @return a new <code>MultiColumnRelation</code> instance */ public static MultiColumnRelation createSingleMarkerInRelation(List<ColumnMetadata.Raw> entities, Tuples.INRaw inMarker) { return new MultiColumnRelation(entities, Operator.IN, null, null, inMarker); } public List<ColumnMetadata.Raw> getEntities() { return entities; } /** * For non-IN relations, returns the Tuples.Literal or Tuples.Raw marker for a single tuple. * @return a Tuples.Literal for non-IN relations or Tuples.Raw marker for a single tuple. */ public Term.MultiColumnRaw getValue() { return relationType == Operator.IN ? inMarker : valuesOrMarker; } public List<? extends Term.Raw> getInValues() { assert relationType == Operator.IN; return inValues; } @Override public boolean isMultiColumn() { return true; } @Override protected Restriction newEQRestriction(TableMetadata table, VariableSpecifications boundNames) { List<ColumnMetadata> receivers = receivers(table); Term term = toTerm(receivers, getValue(), table.keyspace, boundNames); return new MultiColumnRestriction.EQRestriction(receivers, term); } @Override protected Restriction newINRestriction(TableMetadata table, VariableSpecifications boundNames) { List<ColumnMetadata> receivers = receivers(table); List<Term> terms = toTerms(receivers, inValues, table.keyspace, boundNames); if (terms == null) { Term term = toTerm(receivers, getValue(), table.keyspace, boundNames); return new MultiColumnRestriction.InRestrictionWithMarker(receivers, (AbstractMarker) term); } if (terms.size() == 1) return new MultiColumnRestriction.EQRestriction(receivers, terms.get(0)); return new MultiColumnRestriction.InRestrictionWithValues(receivers, terms); } @Override protected Restriction newSliceRestriction(TableMetadata table, VariableSpecifications boundNames, Bound bound, boolean inclusive) { List<ColumnMetadata> receivers = receivers(table); Term term = toTerm(receivers(table), getValue(), table.keyspace, boundNames); return new MultiColumnRestriction.SliceRestriction(receivers, bound, inclusive, term); } @Override protected Restriction newContainsRestriction(TableMetadata table, VariableSpecifications boundNames, boolean isKey) { throw invalidRequest("%s cannot be used for multi-column relations", operator()); } @Override protected Restriction newIsNotRestriction(TableMetadata table, VariableSpecifications boundNames) { // this is currently disallowed by the grammar throw new AssertionError(String.format("%s cannot be used for multi-column relations", operator())); } @Override protected Restriction newLikeRestriction(TableMetadata table, VariableSpecifications boundNames, Operator operator) { throw invalidRequest("%s cannot be used for multi-column relations", operator()); } @Override protected Term toTerm(List<? extends ColumnSpecification> receivers, Raw raw, String keyspace, VariableSpecifications boundNames) throws InvalidRequestException { Term term = ((MultiColumnRaw) raw).prepare(keyspace, receivers); term.collectMarkerSpecification(boundNames); return term; } protected List<ColumnMetadata> receivers(TableMetadata table) throws InvalidRequestException { List<ColumnMetadata> names = new ArrayList<>(getEntities().size()); int previousPosition = -1; for (ColumnMetadata.Raw raw : getEntities()) { ColumnMetadata def = raw.prepare(table); checkTrue(def.isClusteringColumn(), "Multi-column relations can only be applied to clustering columns but was applied to: %s", def.name); checkFalse(names.contains(def), "Column \"%s\" appeared twice in a relation: %s", def.name, this); // check that no clustering columns were skipped checkFalse(previousPosition != -1 && def.position() != previousPosition + 1, "Clustering columns must appear in the PRIMARY KEY order in multi-column relations: %s", this); names.add(def); previousPosition = def.position(); } return names; } public Relation renameIdentifier(ColumnMetadata.Raw from, ColumnMetadata.Raw to) { if (!entities.contains(from)) return this; List<ColumnMetadata.Raw> newEntities = entities.stream().map(e -> e.equals(from) ? to : e).collect(Collectors.toList()); return new MultiColumnRelation(newEntities, operator(), valuesOrMarker, inValues, inMarker); } @Override public String toString() { StringBuilder builder = new StringBuilder(Tuples.tupleToString(entities)); if (isIN()) { return builder.append(" IN ") .append(inMarker != null ? '?' : Tuples.tupleToString(inValues)) .toString(); } return builder.append(" ") .append(relationType) .append(" ") .append(valuesOrMarker) .toString(); } }