/** * 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.util.Arrays; import java.sql.Date; public class VectorUDFDateAddColCol extends VectorExpression { private static final long serialVersionUID = 1L; private int colNum1; private int colNum2; private int outputColumn; protected boolean isPositive = true; private transient final Text text = new Text(); private transient final Date date = new Date(0); private transient final DateParser dateParser = new DateParser(); public VectorUDFDateAddColCol(int colNum1, int colNum2, int outputColumn) { this(); this.colNum1 = colNum1; this.colNum2 = colNum2; this.outputColumn = outputColumn; } public VectorUDFDateAddColCol() { super(); } @Override public void evaluate(VectorizedRowBatch batch) { if (childExpressions != null) { super.evaluateChildren(batch); } ColumnVector inputColVector1 = batch.cols[colNum1]; LongColumnVector inputColVector2 = (LongColumnVector) batch.cols[colNum2]; int[] sel = batch.selected; int n = batch.size; long[] vector2 = inputColVector2.vector; LongColumnVector outV = (LongColumnVector) batch.cols[outputColumn]; long[] outputVector = outV.vector; if (n <= 0) { // Nothing to do return; } // Handle null NullUtil.propagateNullsColCol(inputColVector1, inputColVector2, outV, batch.selected, batch.size, batch.selectedInUse); switch (inputTypes[0]) { case DATE: // Now disregard null in second pass. if ((inputColVector1.isRepeating) && (inputColVector2.isRepeating)) { // All must be selected otherwise size would be zero // Repeating property will not change. outV.isRepeating = true; outputVector[0] = evaluateDate(inputColVector1, 0, vector2[0]); } else if (batch.selectedInUse) { for (int j = 0; j != n; j++) { int i = sel[j]; outputVector[i] = evaluateDate(inputColVector1, i, vector2[i]); } } else { for (int i = 0; i != n; i++) { outputVector[i] = evaluateDate(inputColVector1, i, vector2[i]); } } break; case TIMESTAMP: // Now disregard null in second pass. if ((inputColVector1.isRepeating) && (inputColVector2.isRepeating)) { // All must be selected otherwise size would be zero // Repeating property will not change. outV.isRepeating = true; outputVector[0] = evaluateTimestamp(inputColVector1, 0, vector2[0]); } else if (batch.selectedInUse) { for (int j = 0; j != n; j++) { int i = sel[j]; outputVector[i] = evaluateTimestamp(inputColVector1, i, vector2[i]); } } else { for (int i = 0; i != n; i++) { outputVector[i] = evaluateTimestamp(inputColVector1, i, vector2[i]); } } break; case STRING: case CHAR: case VARCHAR: // Now disregard null in second pass. if ((inputColVector1.isRepeating) && (inputColVector2.isRepeating)) { // All must be selected otherwise size would be zero // Repeating property will not change. outV.isRepeating = true; evaluateString((BytesColumnVector) inputColVector1, outV, 0, vector2[0]); } else if (batch.selectedInUse) { for (int j = 0; j != n; j++) { int i = sel[j]; evaluateString((BytesColumnVector) inputColVector1, outV, i, vector2[i]); } } else { for (int i = 0; i != n; i++) { evaluateString((BytesColumnVector) inputColVector1, outV, i, vector2[i]); } } break; default: throw new Error("Unsupported input type " + inputTypes[0].name()); } } protected long evaluateDate(ColumnVector columnVector, int index, long numDays) { LongColumnVector lcv = (LongColumnVector) columnVector; long days = lcv.vector[index]; if (isPositive) { days += numDays; } else { days -= numDays; } return days; } protected long evaluateTimestamp(ColumnVector columnVector, int index, long numDays) { 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 void evaluateString(BytesColumnVector inputColumnVector1, LongColumnVector outputVector, int index, long numDays) { if (inputColumnVector1.isNull[index]) { outputVector.noNulls = false; outputVector.isNull[index] = true; } else { text.set(inputColumnVector1.vector[index], inputColumnVector1.start[index], inputColumnVector1.length[index]); boolean parsed = dateParser.parseDate(text.toString(), date); if (!parsed) { outputVector.noNulls = false; outputVector.isNull[index] = true; return; } long days = DateWritable.millisToDays(date.getTime()); if (isPositive) { days += numDays; } else { days -= numDays; } outputVector.vector[index] = days; } } @Override public int getOutputColumn() { return this.outputColumn; } @Override public String getOutputType() { return "date"; } public int getColNum1() { return colNum1; } public void setColNum1(int colNum1) { this.colNum1 = colNum1; } public int getColNum2() { return colNum2; } public void setColNum2(int colNum2) { this.colNum2 = colNum2; } public void setOutputColumn(int outputColumn) { this.outputColumn = outputColumn; } @Override public String vectorExpressionParameters() { return "col " + colNum1 + ", col " + colNum2; } @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.COLUMN); return b.build(); } }