@Test
public void testFilter34() throws Exception {
System.out.println("testFilter34");
PigServer pigServer = new PigServer(pigContext);
pigServer.registerQuery(
"G1 = load "
+ GalaxyPair3
+ " using PigStorage() as (objID1 : long, ra : float, dec : float, modelMag_u1 : float, modelMag_g1 : float, modelMag_r1 : float, modelMag_i1 : float, modelMag_z1 : float, petroR50_r1 : float, petrorad_u1 : float, petrorad_g1 : float, petrorad_r1 : float, petrorad_i1 : float, petrorad_z1 : float, petroRadErr_g1 : float, petroMag_g1 : float);");
pigServer.registerQuery(
"AG1 = filter G1 by modelMag_g1 > -9999.0;"); // petrorad_u1 > 0.0 and petrorad_g1 > 0.0 and
// petrorad_r1 > 0.0 and petrorad_i1 > 0.0 and
// petrorad_z1 > 0.0 and petroRadErr_g1 > 0.0
// and petroMag_g1 >= 16.0 and petroMag_g1 <=
// 21.0 and modelMag_u1 > -9999.0 and
// modelMag_g1 > -9999.0 and modelMag_r1 >
// -9999.0 and modelMag_i1 > -9999.0 and
// modelMag_z1 > -9999.0
pigServer.registerQuery(
"G2 = load "
+ GalaxyPair4
+ " using PigStorage() as (objID2 : long, ra : float, dec : float, modelMag_u2 : float, modelMag_g2 : float, modelMag_r2 : float, modelMag_i2 : float, modelMag_z2 : float, petroR50_r2 : float, petrorad_u2 : float, petrorad_g2 : float, petrorad_r2 : float, petrorad_i2 : float, petrorad_z2 : float, petroRadErr_g2: float, petroMag_g2 : float);");
pigServer.registerQuery(
"AG2 = filter G2 by modelMag_g2 > -9999.0;"); // and petrorad_u2 > 0.0 and petrorad_g2 > 0.0
// and petrorad_r2 > 0.0 and petrorad_i2 > 0.0
// and petrorad_z2 > 0.0 and petroRadErr_g2
// > 0.0 and petroMag_g2 >= 16.0 and
// petroMag_g2 <= 21.0 and modelMag_u2 >
// -9999.0 and modelMag_r2 > -9999.0 and
// modelMag_i2 > -9999.0 and modelMag_z2 >
// -9999.0
pigServer.registerQuery(
"N = load "
+ neighbors
+ " using PigStorage() as (objID3 : long, NeighborObjID : long, neighborType : int, distance : float);");
pigServer.registerQuery("AN = filter N by neighborType == 3;");
pigServer.registerQuery("D = join AN by objID3, AG1 by objID1;");
pigServer.registerQuery("E = join D by NeighborObjID, AG2 by objID2;");
pigServer.registerQuery("F = filter E by objID1 < objID2;"); //
pigServer.registerQuery(
"H = filter F by modelMag_g1 - modelMag_g2 > 3.0 or modelMag_g1 - modelMag_g2 < -3.0;");
pigServer.registerQuery(
"I = filter H by petroR50_r1 >= 0.25*petroR50_r2 and petroR50_r1 <= 4.0*petroR50_r2 and petroR50_r2 >= 0.25*petroR50_r1;");
Map<Operator, DataBag> derivedData = pigServer.getExamples("I");
assertTrue(derivedData != null);
} //
