Export/import statistics on flex table is not working
You can analyse statistics on flex table, but export_statistics on flex table return empty schema
select export_statistics('', 'myschema.mytable'); <?xml version="1.0" encoding="utf-8"?> <schema> <tables> </tables> </schema>
That is despite of several materialised column in flex table.
One more thing - materialized columns in flex table can have dots in column name, for nested fields. Export_statistics reject attempt to export statistics for column with dot in name
select export_statistics('', 'myschema.mytable.c1.f1.d1');
[Code: 2065, SQL State: 42501] [Vertica]VJDBC ERROR: export_statistics: Invalid table/projection/column myschema.mytable.c1.f1.d1
Looks like export/import statistics on flex table is not properly supported. Can you file a request to engineering to start supporting it.