SQL Query with Different mappings

Plugins SQL
1

When performing a SQL select query such as SELECT callId FROM txn-* LIMIT 50 the following “Invalid SQL Query” is received: “Different mappings are not allowed for the same field[msg]…”.

My question is, shouldn’t only the selected fields mappings be compared?

When the above query is executed, I would expect the mapping for “callId” across all indices matching “txn-" to be compared; however, it appears that all field mappings are being compared that match "txn-”.

Would it be possible to only compare mapping types for the selected field/s?

Thanks for your time.

2

Hi @Kenton, thanks for reporting the issue! What you said makes sense. Unfortunately we do check all fields in the index mapping matched the pattern. Please open an issue for tracking and improving later.