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.