package com.esri.hadoop.hive;
import java.util.ArrayList;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.hadoop.hive.ql.exec.Description;
import org.apache.hadoop.hive.ql.exec.UDFArgumentException;
import org.apache.hadoop.hive.serde2.io.DoubleWritable;
import org.apache.hadoop.io.BytesWritable;
import org.apache.hadoop.io.Text;
import com.esri.core.geometry.Point;
import com.esri.core.geometry.Polyline;
import com.esri.core.geometry.ogc.OGCGeometry;
@Description(
name = "ST_LineString",
value = "_FUNC_(x, y, [x, y]*) - constructor for 2D line string\n" +
"_FUNC_(array(x+), array(y+)) - constructor for 2D line string\n" +
"_FUNC_(array(ST_Point(x,y)+)) - constructor for 2D line string\n" +
"_FUNC_('linestring( ... )') - constructor for 2D line string",
extended = "Example:\n" +
" SELECT _FUNC_(1, 1, 2, 2, 3, 3) from src LIMIT 1;\n" +
" SELECT _FUNC_('linestring(1 1, 2 2, 3 3)') from src LIMIT 1;")
//@HivePdkUnitTests(
// cases = {
// @HivePdkUnitTest(
// query = "select ST_GeometryType(ST_Linestring('linestring (10 10, 20 20)')) from onerow",
// result = "ST_LINESTRING"
// ),
// @HivePdkUnitTest(
// query = "select ST_Equals(ST_Linestring('linestring (10 10, 20 20)'), ST_GeomFromText('linestring (10 10, 20 20)')) from onerow",
// result = "true"
// )
// }
// )
public class ST_LineString extends ST_Geometry {
static final Log LOG = LogFactory.getLog(ST_LineString.class.getName());
// Number-pairs constructor
public BytesWritable evaluate(DoubleWritable ... xyPairs) throws UDFArgumentException{
if (xyPairs == null || xyPairs.length == 0 || xyPairs.length%2 != 0) {
return null;
}
try {
Polyline linestring = new Polyline();
linestring.startPath(xyPairs[0].get(), xyPairs[1].get());
for (int i=2; i<xyPairs.length; i+=2) {
linestring.lineTo(xyPairs[i].get(), xyPairs[i+1].get());
}
return GeometryUtils.geometryToEsriShapeBytesWritable(OGCGeometry.createFromEsriGeometry(linestring, null));
} catch (Exception e) {
LogUtils.Log_InternalError(LOG, "ST_LineString: " + e);
return null;
}
}
// constructor from arrays of X and Y coordinates
public BytesWritable evaluate(ArrayList<DoubleWritable> xs, ArrayList<DoubleWritable> ys) throws UDFArgumentException {
if (null == xs || null == ys || xs.size() == 0 || ys.size() == 0 || xs.size() != ys.size()) {
return null;
}
try {
Polyline linestring = new Polyline();
for (int ix=0; ix < xs.size(); ++ix) {
DoubleWritable xdw = xs.get(ix), ydw = ys.get(ix);
if (xdw == null || ydw == null) {
LogUtils.Log_ArgumentsNull(LOG);
}
if (ix == 0) {
linestring.startPath(xdw.get(), ydw.get());
} else {
linestring.lineTo(xdw.get(), ydw.get());
}
}
return GeometryUtils.geometryToEsriShapeBytesWritable(OGCGeometry.createFromEsriGeometry(linestring, null));
} catch (Exception e) {
LogUtils.Log_InternalError(LOG, "ST_LineString: " + e);
return null;
}
}
// constructor from array of points
public BytesWritable evaluate(ArrayList<BytesWritable> points) throws UDFArgumentException {
if (null == points || points.size() == 0) {
return null;
}
try {
Polyline linestring = new Polyline();
for (int ix = 0; ix < points.size(); ++ix) {
BytesWritable geomref = points.get(ix);
OGCGeometry gcur = GeometryUtils.geometryFromEsriShape(geomref);
if (gcur == null || GeometryUtils.getType(geomref) != GeometryUtils.OGCType.ST_POINT) {
if (gcur == null)
LogUtils.Log_ArgumentsNull(LOG);
else
LogUtils.Log_InvalidType(LOG, GeometryUtils.OGCType.ST_POINT, GeometryUtils.getType(geomref));
return null;
}
if (ix == 0) {
linestring.startPath((Point)gcur.getEsriGeometry());
} else {
linestring.lineTo((Point)gcur.getEsriGeometry());
}
}
return GeometryUtils.geometryToEsriShapeBytesWritable(OGCGeometry.createFromEsriGeometry(linestring, null));
} catch (Exception e) {
LogUtils.Log_InternalError(LOG, "ST_LineString: " + e);
return null;
}
}
// WKT constructor - can use SetSRID on constructed multi-point
public BytesWritable evaluate(Text wkwrap) throws UDFArgumentException {
String wkt = wkwrap.toString();
try {
OGCGeometry ogcObj = OGCGeometry.fromText(wkt);
ogcObj.setSpatialReference(null);
if (ogcObj.geometryType().equals("LineString")) {
return GeometryUtils.geometryToEsriShapeBytesWritable(ogcObj);
} else {
LogUtils.Log_InvalidType(LOG, GeometryUtils.OGCType.ST_LINESTRING, GeometryUtils.OGCType.UNKNOWN);
return null;
}
} catch (Exception e) { // IllegalArgumentException, GeometryException
LogUtils.Log_InvalidText(LOG, wkt);
return null;
}
}
}