Hi, I am new to elasticsearch and have spent the last two weeks trying to learn everything i can to the best of my ability but as one can imagine it is somewhat overwhelming from a new-coming standpoint.
I am trying to import MySQL data as suggestions, This currently works fine however the problem comes when i attempt to add payload data such as a userId field, My initial thoughts was to perform the following query.
SELECT user_id as 'suggestion.payloads.userId' FROM MyTable WHERE MyColumn = MyValue;
After doing some digging through the logs to see what the issue was, I get the following error message:
MapperParsingException[Field name [suggestion.payloads.userId] cannot contain '.']
Would anyone be able to lend a helping hand to overcome this issue, Any help or advice would be hugely appreciated, I have been trying all day / night to resolve this but it seems im missing something and due to my lack of knowledge.