Examples with Column org.apache.spark.sql.Column used on opensource projects

Example 6 with Column

use of org.apache.spark.sql.Column in project kylo by Teradata.

the class AbstractJdbcDataSetProviderTest method updateHighWaterMarkWithDate.

/**
 * Verify updating a high water mark for a date column.
 */
@Test
public void updateHighWaterMarkWithDate() {
    // Mock data set
    final DataFrame dataSet = Mockito.mock(DataFrame.class);
    Mockito.when(dataSet.col("mockField")).thenReturn(new Column("mockField"));
    final StructField field = DataTypes.createStructField("mockField", DataTypes.DateType, true);
    Mockito.when(dataSet.schema()).thenReturn(DataTypes.createStructType(Collections.singletonList(field)));
    final DataFrame mapDataSet = Mockito.mock(DataFrame.class);
    Mockito.when(dataSet.withColumn(Mockito.eq("mockField"), Mockito.any(Column.class))).thenReturn(mapDataSet);
    // Test updating high water mark
    final KyloCatalogClient client = Mockito.mock(KyloCatalogClient.class);
    final JdbcHighWaterMark highWaterMark = new JdbcHighWaterMark("mockWaterMark", client);
    final MockJdbcDataSetProvider provider = new MockJdbcDataSetProvider();
    final DataFrame newDataSet = provider.updateHighWaterMark(dataSet, "mockField", highWaterMark, client);
    Assert.assertEquals(mapDataSet, newDataSet);
    // Test replaced column
    final ArgumentCaptor<Column> newColumn = ArgumentCaptor.forClass(Column.class);
    Mockito.verify(dataSet).withColumn(Mockito.eq("mockField"), newColumn.capture());
    Assert.assertTrue("Expected new column to be a UDF", newColumn.getValue().expr() instanceof ScalaUDF);
}

Example 7 with Column

use of org.apache.spark.sql.Column in project kylo by Teradata.

the class AbstractJdbcDataSetProviderTest method filterByDateTime.

/**
 * Verify filtering for new rows.
 */
@Test
public void filterByDateTime() {
    DateTimeUtils.setCurrentMillisFixed(1524960000000L);
    // Mock data set
    final DataFrame dataSet = Mockito.mock(DataFrame.class);
    final DataFrame filterDataSet = Mockito.mock(DataFrame.class);
    Mockito.when(dataSet.filter(Mockito.any(Column.class))).thenReturn(filterDataSet);
    // Test filtering by date time
    final MockJdbcDataSetProvider provider = new MockJdbcDataSetProvider();
    final DataFrame newDataSet = provider.filterByDateTime(dataSet, "mockField", null, null);
    Assert.assertEquals(filterDataSet, newDataSet);
    // Test condition
    final ArgumentCaptor<Column> conditionCaptor = ArgumentCaptor.forClass(Column.class);
    Mockito.verify(dataSet).filter(conditionCaptor.capture());
    Assert.assertEquals("(mockField < 1524960000000000)", conditionCaptor.getValue().toString());
}

Example 8 with Column

use of org.apache.spark.sql.Column in project kylo by Teradata.

the class DataSetProviderUtil method map.

/**
 * Applies the specified function to the specified field of the data set.
 */
@Nonnull
@SuppressWarnings("unchecked")
static DataFrame map(@Nonnull final DataFrame dataSet, @Nonnull final String fieldName, @Nonnull final Function1 function, @Nonnull final DataType returnType) {
    final Seq<Column> inputs = Seq$.MODULE$.<Column>newBuilder().$plus$eq(dataSet.col(fieldName)).result();
    final UserDefinedFunction udf = new UserDefinedFunction(function, returnType, (Seq<DataType>) Seq$.MODULE$.<DataType>empty());
    return dataSet.withColumn(fieldName, udf.apply(inputs));
}

Example 9 with Column

use of org.apache.spark.sql.Column in project kylo by Teradata.

the class DataSetProviderUtilV2 method map.

/**
 * Applies the specified function to the specified field of the data set.
 */
@Nonnull
static Dataset<Row> map(@Nonnull final Dataset<Row> dataSet, @Nonnull final String fieldName, @Nonnull final Function1 function, @Nonnull final DataType returnType) {
    final Seq<Column> inputs = Seq$.MODULE$.<Column>newBuilder().$plus$eq(dataSet.col(fieldName)).result();
    final UserDefinedFunction udf = new UserDefinedFunction(function, returnType, Option$.MODULE$.<Seq<DataType>>empty());
    return dataSet.withColumn(fieldName, udf.apply(inputs));
}

Example 10 with Column

use of org.apache.spark.sql.Column in project kylo by Teradata.

the class Profiler method toSelectColumns.

private Column[] toSelectColumns(ProfilerArguments args) {
    List<String> profiledCols = args.getProfiledColumns();
    if (args.getInputAndOutputTablePartitionKey() != null && !"ALL".equalsIgnoreCase(args.getInputAndOutputTablePartitionKey())) {
        profiledCols.add(HiveUtils.quoteIdentifier(profilerConfiguration.getInputTablePartitionColumnName()));
    }
    Column[] columns = new Column[profiledCols.size()];
    for (int idx = 0; idx < profiledCols.size(); idx++) {
        Column column = new Column(profiledCols.get(idx));
        columns[idx] = column;
    }
    return columns;
}