io.druid.sql.calcite.expression.RegexpExtractExtractionOperator Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of druid-sql Show documentation
Druid SQL
There is a newer version: 0.12.3
/*
 * Licensed to Metamarkets Group Inc. (Metamarkets) under one
 * or more contributor license agreements. See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership. Metamarkets 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 io.druid.sql.calcite.expression;

import io.druid.query.extraction.ExtractionFn;
import io.druid.query.extraction.RegexDimExtractionFn;
import io.druid.sql.calcite.planner.PlannerContext;
import org.apache.calcite.rex.RexCall;
import org.apache.calcite.rex.RexLiteral;
import org.apache.calcite.rex.RexNode;
import org.apache.calcite.sql.SqlFunction;
import org.apache.calcite.sql.SqlFunctionCategory;
import org.apache.calcite.sql.SqlKind;
import org.apache.calcite.sql.type.OperandTypes;
import org.apache.calcite.sql.type.ReturnTypes;
import org.apache.calcite.sql.type.SqlTypeFamily;
import org.apache.calcite.sql.type.SqlTypeName;

import java.util.List;

public class RegexpExtractExtractionOperator implements SqlExtractionOperator
{
  private static final String NAME = "REGEXP_EXTRACT";
  private static final SqlFunction SQL_FUNCTION = new RegexpExtractSqlFunction();

  @Override
  public SqlFunction calciteFunction()
  {
    return SQL_FUNCTION;
  }

  @Override
  public RowExtraction convert(
      final PlannerContext plannerContext,
      final List rowOrder,
      final RexNode expression
  )
  {
    final RexCall call = (RexCall) expression;
    final RowExtraction rex = Expressions.toRowExtraction(
        plannerContext,
        rowOrder,
        call.getOperands().get(0)
    );
    if (rex == null) {
      return null;
    }

    final String pattern = RexLiteral.stringValue(call.getOperands().get(1));
    final int index = call.getOperands().size() >= 3 ? RexLiteral.intValue(call.getOperands().get(2)) : 0;
    final ExtractionFn extractionFn = new RegexDimExtractionFn(pattern, index, true, null);

    return RowExtraction.of(
        rex.getColumn(),
        ExtractionFns.compose(extractionFn, rex.getExtractionFn())
    );
  }

  private static class RegexpExtractSqlFunction extends SqlFunction
  {
    private static final String SIGNATURE1 = "'" + NAME + "(subject, pattern)'\n";
    private static final String SIGNATURE2 = "'" + NAME + "(subject, pattern, index)'\n";

    RegexpExtractSqlFunction()
    {
      super(
          NAME,
          SqlKind.OTHER_FUNCTION,
          ReturnTypes.explicit(SqlTypeName.VARCHAR),
          null,
          OperandTypes.or(
              OperandTypes.and(
                  OperandTypes.sequence(SIGNATURE1, OperandTypes.CHARACTER, OperandTypes.LITERAL),
                  OperandTypes.family(SqlTypeFamily.CHARACTER, SqlTypeFamily.CHARACTER)
              ),
              OperandTypes.and(
                  OperandTypes.sequence(SIGNATURE2, OperandTypes.CHARACTER, OperandTypes.LITERAL, OperandTypes.LITERAL),
                  OperandTypes.family(SqlTypeFamily.CHARACTER, SqlTypeFamily.CHARACTER, SqlTypeFamily.INTEGER)
              )
          ),
          SqlFunctionCategory.STRING
      );
    }
  }
}