tFileOutputParquet - java.lang.NullPointerException: name should not be null

TalendSolutionExpert — Fri, 09 Feb 2024 19:06:24 GMT

[Background]
-Talend Studio 7.3.1 or Talend Studio 8.0.1

[Problem]
-We have a workflow to convert Excel files to parquet,tFileInputExcel with dynamic

-Run the job, and it gives us: name should not be null

[Reason]
-There are some empty columns in the source Excel file:

[Workaround]

-For the tFileInputExcel dynamic, It needs the first line to guess the schema.

-The example job source Excel didn't set a real header. Please Add tJavaFlex to transform Dynamic metadata with:

To the start code:

boolean isFirst = true;

To the main code:

if(isFirst) {
  isFirst = false;
  Dynamic newDyn = row1.newColumn.clone(false);
  for(DynamicMetadata meta : newDyn.metadatas) {
            // reset column name,
            String newColumnName = "field"+meta.getColumnPosition();
            meta.setName(newColumnName);
            meta.setDbName(newColumnName);            
            System.out.println("New  dynamic field name: '"+ meta.getDbName()+"' ");
  }
  row2.newColumn = newDyn;
}

After that, the job works.

article tFileOutputParquet - java.lang.NullPointerException: name should not be null in Official Support Articles

tFileOutputParquet - java.lang.NullPointerException: name should not be null