traces_ddl need update for doris 2.1.10 or 3.0.6

[pioneerlfn]

Component(s)

exporter/doris

Is your feature request related to a problem? Please describe.

1. As of doris 2.1.10 and 3.0.6, time series compaction policy is not supported for unique key model table, so the creation sql for table traces_graph_ddl need to remove the '"compaction_policy" = "time_series"' property;
2. As of doris 2.1.10, VARIANT is not supported in inverted index format V1, property "inverted_index_storage_format" should be set to "v2"

Describe the solution you'd like

the property for traces_ddl shoud include "inverted_index_storage_format"= "v2";
the property for traces_graph_ddl shoud include remove the "compaction_policy" = "time_series"

Or, may be the best way is not to embend the ddl sql into otelcol-contirb binary, insteand, should be a config file outside the binary

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

Pinging code owners:

• exporter/doris: @atoulme @joker-star-l

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[joker-star-l]

/label bug

[joker-star-l]

@pioneerlfn Thanks for your report! DDL will be fixed. Currently, you can set create_schema to false and create tables in doris manually.