/** * 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.tajo.engine.function.string; import org.apache.tajo.catalog.Column; import org.apache.tajo.common.TajoDataTypes; import org.apache.tajo.datum.Datum; import org.apache.tajo.datum.DatumFactory; import org.apache.tajo.datum.NullDatum; import org.apache.tajo.engine.function.GeneralFunction; import org.apache.tajo.engine.function.annotation.Description; import org.apache.tajo.engine.function.annotation.ParamTypes; import org.apache.tajo.storage.Tuple; /** * Function definition * * int strpos(string text, substring text)) */ @Description( functionName = "strpos", description = "Location of specified substring.", example = "> SELECT strpos('tajo', 'aj');\n" + "2", returnType = TajoDataTypes.Type.INT4, paramTypes = {@ParamTypes(paramTypes = {TajoDataTypes.Type.TEXT, TajoDataTypes.Type.TEXT})} ) public class StrPos extends GeneralFunction { public StrPos() { super(new Column[] { new Column("string", TajoDataTypes.Type.TEXT), new Column("substring", TajoDataTypes.Type.TEXT) }); } @Override public Datum eval(Tuple params) { Datum valueDatum = params.get(0); if(valueDatum instanceof NullDatum) { return NullDatum.get(); } Datum substringDatum = params.get(1); if(substringDatum instanceof NullDatum) { return NullDatum.get(); } String value = valueDatum.asChars(); String substring = substringDatum.asChars(); if(substring.length() == 0) { return DatumFactory.createInt4(1); } return DatumFactory.createInt4(value.indexOf(substring) + 1); } }