QuesmaOrg / quesma

Programmable database gateway
https://quesma.com
Other
106 stars 6 forks source link

Too many fields end up in attributes for kibana_sample_data_ecommerce index #966

Open avelanarius opened 6 days ago

avelanarius commented 6 days ago

When running the latest main (410069deee24965127f50ef811f5fb3e59d641cc) and the configuration from the kibana-sample-data example, too many fields end up in the attributes, instead of a separate column. With the current version of Quesma it makes it impossible to query the data for those fields.

Zrzut ekranu 2024-11-8 o 11 56 26

Some initial investigation why order_id ends up in attributes: we incorrectly create Nullable(String) column for it, but the data is of type Int64 . And the reason why we create Nullable(String) is because we receive a "PUT /:index/_mapping" that tells us that order_id should be a keyword (so a String).

pdelewski commented 20 hours ago

Problems discovered for ecommerce: