// See PIG-1434
@Test
public void testScalarAliasesJoinClause() throws Exception {
String[] inputA = {"1\t5", "2\t10", "3\t20"};
String[] inputB = {"Total3\tthree", "Total2\ttwo", "Total1\tone"};
// Test the use of scalars in expressions
String inputPathA = BUILD_TEST_TMP + "table_testScalarAliasesJoinClauseA";
TestScalarAliases.createLocalInputFile(inputPathA, inputA);
String inputPathB = BUILD_TEST_TMP + "table_testScalarAliasesJoinClauseB";
TestScalarAliases.createLocalInputFile(inputPathB, inputB);
// Test in script mode
pigServer.registerQuery("A = LOAD '" + inputPathA + "' as (a0, a1);");
pigServer.registerQuery("G = group A all;");
pigServer.registerQuery("C = foreach G generate COUNT(A) as count;");
pigServer.registerQuery("B = LOAD '" + inputPathB + "' as (b0:chararray, b1:chararray);");
pigServer.registerQuery("Y = join A by CONCAT('Total', (chararray)C.count), B by $0;");
Iterator<Tuple> iter = pigServer.openIterator("Y");
String[] expected =
new String[] {"(1,5,Total3,three)", "(2,10,Total3,three)", "(3,20,Total3,three)"};
Util.checkQueryOutputsAfterSortRecursive(
iter,
expected,
org.apache.pig.newplan.logical.Util.translateSchema(pigServer.dumpSchema("Y")));
}
@Test
public void readWithoutSchemaTestSchema() throws IOException {
registerLoadQuery(IntWritableConverter.class, TextConverter.class, null);
Schema schema = pigServer.dumpSchema("A");
Assert.assertNotNull(schema);
Assert.assertEquals("key", schema.getField(0).alias);
Assert.assertEquals(DataType.INTEGER, schema.getField(0).type);
Assert.assertEquals("value", schema.getField(1).alias);
Assert.assertEquals(DataType.CHARARRAY, schema.getField(1).type);
}
@Test(expected = Exception.class)
public void writableConverterArguments05() throws IOException {
registerLoadQuery(VarArgsConstructorIntWritableConverter.class, "");
pigServer.dumpSchema("A");
}
@Test
public void writableConverterArguments07() throws IOException {
registerLoadQuery(VarArgsConstructorIntWritableConverter.class, "1 2 3 4 5");
pigServer.dumpSchema("A");
}
@Test
public void writableConverterArguments04() throws IOException {
registerLoadQuery(FixedArgsConstructorIntWritableConverter.class, "-- -123 -456");
pigServer.dumpSchema("A");
}