umeshPathak opened a new issue, #35286:
URL: https://github.com/apache/beam/issues/35286
I want to read Customer table from MySQL and store the records in CSV file.
Very simple and straightforward. Want to read 4 million records in partition.
I am using
```
<java.version>21</java.version>
<beam.version>2.65.0</beam.version>
```
This is the code -
```
PipelineOptions options = PipelineOptionsFactory.create();
Pipeline pipeline = Pipeline.create(options);
JdbcIO.ReadWithPartitions<Customer1,Long> readTransform =
JdbcIO.<Customer1>readWithPartitions()
.withDataSourceConfiguration(JdbcIO.DataSourceConfiguration.create(
"com.mysql.cj.jdbc.Driver",
"jdbc:mysql://localhost:3306/customerdb")
.withUsername("")
.withPassword(""))
.withTable("Customer1")
.withPartitionColumn("customerId")
.withLowerBound(0L)
.withUpperBound(1000L)
.withNumPartitions(5)
.withRowMapper(
new JdbcIO.RowMapper<Customer1>()
{
private static final long
serialVersionUID = 1L;
public Customer1
mapRow(ResultSet rs) throws SQLException
{
Customer1 cust = new Customer1();
cust.setCustomerId(
rs.getInt("customerId"));
cust.setName(rs.getString("name"));
cust.setEmail(rs.getString("email"));
cust.setAddress(rs.getString("address"));
return cust ;
}
})
.withCoder(SerializableCoder.of(Customer1.class));
pipeline.apply("ReadFromMySQL", readTransform)
.apply("ToCSV", MapElements.via(new CustomerToCSV()))
.apply("WriteCSV", TextIO.write()
.to("output/customers")
.withHeader("customerId,name,email,address")
.withSuffix(".csv")
.withNumShards(1));
pipeline.run().waitUntilFinish();
```
Getting below exception ```
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder$PopulateDisplayDataException:
Error while populating display data for component
'org.apache.beam.sdk.io.jdbc.JdbcIO$ReadWithPartitions': Input display value
cannot be null
at
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder.include(DisplayData.java:789)
at
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder.access$100(DisplayData.java:703)
at
org.apache.beam.sdk.transforms.display.DisplayData.from(DisplayData.java:81)
at
org.apache.beam.runners.direct.DisplayDataValidator.evaluateDisplayData(DisplayDataValidator.java:50)
at
org.apache.beam.runners.direct.DisplayDataValidator.access$100(DisplayDataValidator.java:33)
at
org.apache.beam.runners.direct.DisplayDataValidator$Visitor.enterCompositeTransform(DisplayDataValidator.java:59)
at
org.apache.beam.sdk.runners.TransformHierarchy$Node.visit(TransformHierarchy.java:581)
at
org.apache.beam.sdk.runners.TransformHierarchy$Node.visit(TransformHierarchy.java:585)
at
org.apache.beam.sdk.runners.TransformHierarchy$Node.access$500(TransformHierarchy.java:240)
at
org.apache.beam.sdk.runners.TransformHierarchy.visit(TransformHierarchy.java:214)
at org.apache.beam.sdk.Pipeline.traverseTopologically(Pipeline.java:477)
at
org.apache.beam.runners.direct.DisplayDataValidator.validateTransforms(DisplayDataValidator.java:46)
at
org.apache.beam.runners.direct.DisplayDataValidator.validatePipeline(DisplayDataValidator.java:38)
at
org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:185)
at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:67)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:325)
at org.apache.beam.sdk.Pipeline.run(Pipeline.java:310)
at
com.example.apachebeamwiththjoine.ApacheBeamWithJoinApplication.main(ApacheBeamWithJoinApplication.java:79)
Caused by: java.lang.NullPointerException: Input display value cannot be null
at
org.apache.beam.vendor.guava.v32_1_2_jre.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:921)
at
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder.addItemIf(DisplayData.java:830)
at
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder.add(DisplayData.java:808)
at
org.apache.beam.sdk.io.jdbc.JdbcIO$ReadWithPartitions.populateDisplayData(JdbcIO.java:1617)
at
org.apache.beam.sdk.transforms.display.DisplayData$InternalBuilder.include(DisplayData.java:780)
... 17 more
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
