Enabling L7FlowExporter in Antrea FlowAggregator fails with missing columns in table

[andreasm80]

Not sure if it is something I am missing from my side, but when I try to enable the new feature L7FlowExporter in Antrea the FlowAggregator fails with the following error message:

"error when creating ClickHouse export process: error when preparing insert statement, code: 16, message: No such column appProtocolName in table default.flows"

After checking the clickhouse db the following columns is indeed missing in tables default.flows and default.flows_local:

• appProtocolName
• httpVals
• egressNodeName

After adding these columns in both tables FlowAggregator is happy again and can start normal and flows are being collected in the clickhouse DB.

I reckon Theia has not yet been updated to handle this new L7FlowExporter flow information yet. Its just that nothing about this new feature is mentioned to not work with Theia here https://github.com/antrea-io/antrea/blob/main/docs/network-flow-visibility.md#grafana-flow-collector-migrated

[elton-furtado]

@yuntanghsu can you update the Antrea document, with support for Theia still not implemented yet.