jp.co.yahoo.yosegi.hive.pushdown.CompareHiveExpr Maven / Gradle / Ivy
/**
* 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 jp.co.yahoo.yosegi.hive.pushdown;
import jp.co.yahoo.yosegi.message.objects.ByteObj;
import jp.co.yahoo.yosegi.message.objects.DoubleObj;
import jp.co.yahoo.yosegi.message.objects.FloatObj;
import jp.co.yahoo.yosegi.message.objects.IntegerObj;
import jp.co.yahoo.yosegi.message.objects.LongObj;
import jp.co.yahoo.yosegi.message.objects.ShortObj;
import jp.co.yahoo.yosegi.spread.column.filter.GeStringCompareFilter;
import jp.co.yahoo.yosegi.spread.column.filter.GtStringCompareFilter;
import jp.co.yahoo.yosegi.spread.column.filter.IFilter;
import jp.co.yahoo.yosegi.spread.column.filter.LeStringCompareFilter;
import jp.co.yahoo.yosegi.spread.column.filter.LtStringCompareFilter;
import jp.co.yahoo.yosegi.spread.column.filter.NumberFilter;
import jp.co.yahoo.yosegi.spread.column.filter.NumberFilterType;
import jp.co.yahoo.yosegi.spread.column.filter.StringCompareFilterType;
import jp.co.yahoo.yosegi.spread.expression.ExecuterNode;
import jp.co.yahoo.yosegi.spread.expression.IExpressionNode;
import jp.co.yahoo.yosegi.spread.expression.IExtractNode;
import org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc;
import org.apache.hadoop.hive.ql.plan.ExprNodeDesc;
import org.apache.hadoop.hive.ql.plan.ExprNodeGenericFuncDesc;
import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.PrimitiveObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantBooleanObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantByteObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantDoubleObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantFloatObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantIntObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantLongObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantShortObjectInspector;
import org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableConstantStringObjectInspector;
import java.util.List;
public class CompareHiveExpr implements IHiveExprNode {
private final StringCompareFilterType stringCompareType;
private final NumberFilterType numberCompareType;
private final List nodeDescList;
/**
* Initialize.
*/
public CompareHiveExpr(
final List nodeDescList ,
final StringCompareFilterType stringCompareType ,
final NumberFilterType numberCompareType ) {
this.nodeDescList = nodeDescList;
this.stringCompareType = stringCompareType;
this.numberCompareType = numberCompareType;
}
/**
* Create comparison condition.
*/
public static IExpressionNode getCompareExecuter(
final ExprNodeConstantDesc constDesc ,
final IExtractNode targetColumn ,
final StringCompareFilterType stringCompareType ,
final NumberFilterType numberCompareType ) {
ObjectInspector objectInspector = constDesc.getWritableObjectInspector();
if ( objectInspector.getCategory() != ObjectInspector.Category.PRIMITIVE ) {
return null;
}
PrimitiveObjectInspector primitiveObjectInspector = (PrimitiveObjectInspector)objectInspector;
IFilter filter = null;
switch ( primitiveObjectInspector.getPrimitiveCategory() ) {
case STRING:
switch ( stringCompareType ) {
case LT:
filter = new LtStringCompareFilter(
( (WritableConstantStringObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().toString() );
break;
case LE:
filter = new LeStringCompareFilter(
( (WritableConstantStringObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().toString() );
break;
case GT:
filter = new GtStringCompareFilter(
( (WritableConstantStringObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().toString() );
break;
case GE:
filter = new GeStringCompareFilter(
( (WritableConstantStringObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().toString() );
break;
default:
filter = null;
break;
}
break;
case BYTE:
byte byteObj = (
(WritableConstantByteObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new ByteObj( byteObj ) );
break;
case SHORT:
short shortObj = (
(WritableConstantShortObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new ShortObj( shortObj ) );
break;
case INT:
int intObj = (
(WritableConstantIntObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new IntegerObj( intObj ) );
break;
case LONG:
long longObj = (
(WritableConstantLongObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new LongObj( longObj ) );
break;
case FLOAT:
float floatObj = (
(WritableConstantFloatObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new FloatObj( floatObj ) );
break;
case DOUBLE:
double doubleObj = (
(WritableConstantDoubleObjectInspector)primitiveObjectInspector )
.getWritableConstantValue().get();
filter = new NumberFilter( numberCompareType , new DoubleObj( doubleObj ) );
break;
case DATE:
case DECIMAL:
case TIMESTAMP:
filter = null;
break;
default:
filter = null;
break;
}
if ( filter == null ) {
return null;
}
return new ExecuterNode( targetColumn , filter );
}
/**
* Inverted comparison condition.
*/
public static StringCompareFilterType getReverseStringType( final StringCompareFilterType type ) {
switch ( type ) {
case LT:
return StringCompareFilterType.GT;
case LE:
return StringCompareFilterType.GE;
case GT:
return StringCompareFilterType.LT;
case GE:
return StringCompareFilterType.LE;
default:
throw new RuntimeException( "Unknown string compare type." );
}
}
/**
* Inverted comparison condition.
*/
public static NumberFilterType getReverseNumberType( final NumberFilterType type ) {
switch ( type ) {
case LT:
return NumberFilterType.GT;
case LE:
return NumberFilterType.GE;
case GT:
return NumberFilterType.LT;
case GE:
return NumberFilterType.LE;
default:
throw new RuntimeException( "Unknown number compare type." );
}
}
@Override
public void addChildNode( final ExprNodeGenericFuncDesc exprNodeDesc ) {
throw new UnsupportedOperationException( "IHiveExprNode node can not have child node." );
}
@Override
public IExpressionNode getPushDownFilterNode() {
if ( nodeDescList.size() != 2 ) {
return null;
}
ExprNodeDesc exprNode1 = nodeDescList.get( 0 );
ExprNodeDesc exprNode2 = nodeDescList.get( 1 );
ExprNodeDesc columnDesc;
ExprNodeConstantDesc constantDesc;
StringCompareFilterType strType;
NumberFilterType numberType;
if ( exprNode1 instanceof ExprNodeConstantDesc ) {
columnDesc = exprNode2;
constantDesc = (ExprNodeConstantDesc)exprNode1;
strType = getReverseStringType( stringCompareType );
numberType = getReverseNumberType( numberCompareType );
} else if ( exprNode2 instanceof ExprNodeConstantDesc ) {
columnDesc = exprNode1;
constantDesc = (ExprNodeConstantDesc)exprNode2;
strType = stringCompareType;
numberType = numberCompareType;
} else {
return null;
}
IExtractNode extractNode = CreateExtractNodeUtil.getExtractNode( columnDesc );
if ( extractNode == null ) {
return null;
}
return getCompareExecuter( constantDesc , extractNode , strType , numberType );
}
}