Examples of org.apache.phoenix.expression.function.SubstrFunction

Package org.apache.phoenix.expression.function

Examples of org.apache.phoenix.expression.function.SubstrFunction

org.apache.phoenix.expression.function.SubstrFunction
Implementation of the SUBSTR(,[,]) built-in function where is the offset from the start of . A positive offset is treated as 1-based, a zero offset is treated as 0-based, and a negative offset starts from the end of the string working backwards. The optional argument is the number of characters to return. In the absence of the argument, the rest of the string starting from is returned. If is less than 1, null is returned. @since 0.1

        assertEquals(
            singleKVFilter( // single b/c one column is a row key column
            or(
                constantComparison(
                    CompareOp.EQUAL,
                    new SubstrFunction(Arrays.<Expression> asList(
                        new RowKeyColumnExpression(
                            ENTITY_ID,
                            new RowKeyValueAccessor(ATABLE.getPKColumns(), 1)),
                        LiteralExpression.newConstant(1),
                        LiteralExpression.newConstant(3))),

View Full Code Here

public class SortOrderExpressionTest {
    
    @Test
    public void substr() throws Exception {
        List<Expression> args = Lists.newArrayList(getInvertedLiteral("blah", PDataType.CHAR), getLiteral(3), getLiteral(2));
        evaluateAndAssertResult(new SubstrFunction(args), "ah");
    }

View Full Code Here

    @Test
    public void substrLtrim() throws Exception {
        List<Expression> ltrimArgs = Lists.newArrayList(getInvertedLiteral("   blah", PDataType.CHAR));
        Expression ltrim = new LTrimFunction(ltrimArgs);
        List<Expression> substrArgs = Lists.newArrayList(ltrim, getLiteral(3), getLiteral(2));
        evaluateAndAssertResult(new SubstrFunction(substrArgs), "ah");
    }

View Full Code Here

    public static Expression like(Expression e, Object o) {
        return  new LikeExpression(Arrays.asList(e, LiteralExpression.newConstant(o)));
    }


    public static Expression substr(Expression e, Object offset, Object length) {
        return  new SubstrFunction(Arrays.asList(e, LiteralExpression.newConstant(offset), LiteralExpression.newConstant(length)));
    }

View Full Code Here

0 1

TOP

Related Classes of org.apache.phoenix.expression.function.SubstrFunction

org.apache.phoenix.compile.WhereClauseFilterTest

org.apache.phoenix.compile.WhereCompilerTest

org.apache.phoenix.expression.Expression

org.apache.phoenix.expression.LiteralExpression

org.apache.phoenix.expression.SortOrderExpressionTest

org.apache.phoenix.schema.ColumnModifier

org.apache.phoenix.schema.PDataType

org.apache.phoenix.schema.SortOrder

org.apache.phoenix.util.TestUtil

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.