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.