/** * 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.hadoop.hive.ql.exec.vector.expressions; import org.apache.hadoop.hive.ql.exec.vector.BytesColumnVector; import org.apache.hadoop.hive.ql.exec.vector.ColumnVector; import org.apache.hadoop.hive.ql.exec.vector.LongColumnVector; import org.apache.hadoop.hive.ql.exec.vector.TimestampColumnVector; import org.apache.hadoop.hive.ql.exec.vector.VectorExpressionDescriptor; import org.apache.hadoop.hive.ql.exec.vector.VectorizedRowBatch; import org.apache.hadoop.hive.serde2.io.DateWritable; import org.apache.hadoop.io.Text; import org.apache.hive.common.util.DateParser; import java.sql.Date; public class VectorUDFDateAddColScalar extends VectorExpression { private static final long serialVersionUID = 1L; private int colNum; private int outputColumn; private int numDays; protected boolean isPositive = true; private transient final Text text = new Text(); private transient final DateParser dateParser = new DateParser(); private transient final Date date = new Date(0); public VectorUDFDateAddColScalar(int colNum, long numDays, int outputColumn) { super(); this.colNum = colNum; this.numDays = (int) numDays; this.outputColumn = outputColumn; } public VectorUDFDateAddColScalar() { super(); } @Override public void evaluate(VectorizedRowBatch batch) { if (childExpressions != null) { super.evaluateChildren(batch); } LongColumnVector outV = (LongColumnVector) batch.cols[outputColumn]; ColumnVector inputCol = batch.cols[this.colNum]; /* every line below this is identical for evaluateLong & evaluateString */ final int n = inputCol.isRepeating ? 1 : batch.size; int[] sel = batch.selected; final boolean selectedInUse = (inputCol.isRepeating == false) && batch.selectedInUse; if(batch.size == 0) { /* n != batch.size when isRepeating */ return; } /* true for all algebraic UDFs with no state */ outV.isRepeating = inputCol.isRepeating; switch (inputTypes[0]) { case DATE: if (inputCol.noNulls) { outV.noNulls = true; if (selectedInUse) { for(int j=0; j < n; j++) { int i = sel[j]; outV.vector[i] = evaluateDate(inputCol, i); } } else { for(int i = 0; i < n; i++) { outV.vector[i] = evaluateDate(inputCol, i); } } } else { // Handle case with nulls. Don't do function if the value is null, to save time, // because calling the function can be expensive. outV.noNulls = false; if (selectedInUse) { for(int j = 0; j < n; j++) { int i = sel[j]; outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { outV.vector[i] = evaluateDate(inputCol, i); } } } else { for(int i = 0; i < n; i++) { outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { outV.vector[i] = evaluateDate(inputCol, i); } } } } break; case TIMESTAMP: if (inputCol.noNulls) { outV.noNulls = true; if (batch.selectedInUse) { for(int j=0; j < n; j++) { int i = sel[j]; outV.vector[i] = evaluateTimestamp(inputCol, i); } } else { for(int i = 0; i < n; i++) { outV.vector[i] = evaluateTimestamp(inputCol, i); } } } else { // Handle case with nulls. Don't do function if the value is null, to save time, // because calling the function can be expensive. outV.noNulls = false; if (batch.selectedInUse) { for(int j = 0; j < n; j++) { int i = sel[j]; outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { outV.vector[i] = evaluateTimestamp(inputCol, i); } } } else { for(int i = 0; i < n; i++) { outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { outV.vector[i] = evaluateTimestamp(inputCol, i); } } } } break; case STRING: case CHAR: case VARCHAR: if (inputCol.noNulls) { outV.noNulls = true; if (batch.selectedInUse) { for(int j=0; j < n; j++) { int i = sel[j]; evaluateString(inputCol, outV, i); } } else { for(int i = 0; i < n; i++) { evaluateString(inputCol, outV, i); } } } else { // Handle case with nulls. Don't do function if the value is null, to save time, // because calling the function can be expensive. outV.noNulls = false; if (batch.selectedInUse) { for(int j = 0; j < n; j++) { int i = sel[j]; outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { evaluateString(inputCol, outV, i); } } } else { for(int i = 0; i < n; i++) { outV.isNull[i] = inputCol.isNull[i]; if (!inputCol.isNull[i]) { evaluateString(inputCol, outV, i); } } } } break; default: throw new Error("Unsupported input type " + inputTypes[0].name()); } } protected long evaluateTimestamp(ColumnVector columnVector, int index) { TimestampColumnVector tcv = (TimestampColumnVector) columnVector; // Convert to date value (in days) long days = DateWritable.millisToDays(tcv.getTime(index)); if (isPositive) { days += numDays; } else { days -= numDays; } return days; } protected long evaluateDate(ColumnVector columnVector, int index) { LongColumnVector lcv = (LongColumnVector) columnVector; long days = lcv.vector[index]; if (isPositive) { days += numDays; } else { days -= numDays; } return days; } protected void evaluateString(ColumnVector columnVector, LongColumnVector outputVector, int i) { BytesColumnVector bcv = (BytesColumnVector) columnVector; text.set(bcv.vector[i], bcv.start[i], bcv.length[i]); boolean parsed = dateParser.parseDate(text.toString(), date); if (!parsed) { outputVector.noNulls = false; outputVector.isNull[i] = true; return; } long days = DateWritable.millisToDays(date.getTime()); if (isPositive) { days += numDays; } else { days -= numDays; } outputVector.vector[i] = days; } @Override public int getOutputColumn() { return this.outputColumn; } @Override public String getOutputType() { return "date"; } public int getColNum() { return colNum; } public void setColNum(int colNum) { this.colNum = colNum; } public void setOutputColumn(int outputColumn) { this.outputColumn = outputColumn; } public int getNumDays() { return numDays; } public void setNumDay(int numDays) { this.numDays = numDays; } @Override public String vectorExpressionParameters() { return "col " + colNum + ", val " + numDays; } @Override public VectorExpressionDescriptor.Descriptor getDescriptor() { VectorExpressionDescriptor.Builder b = new VectorExpressionDescriptor.Builder(); b.setMode(VectorExpressionDescriptor.Mode.PROJECTION) .setNumArguments(2) .setArgumentTypes( VectorExpressionDescriptor.ArgumentType.STRING_DATETIME_FAMILY, VectorExpressionDescriptor.ArgumentType.INT_FAMILY) .setInputExpressionTypes( VectorExpressionDescriptor.InputExpressionType.COLUMN, VectorExpressionDescriptor.InputExpressionType.SCALAR); return b.build(); } }