ElasticSearch bool query - hundred of OR terms












0















I need to verify and find the respective entries, that matches to a huge list of (in my case) verbs.
For example: I have 200 statements in a csv and need to find the matching items in my index.
I can only find bool and query-string examples, but it would get REALLY ugly to write down 200 seperate statements and connect them with OR (or should).



Is there a smart way to do that? Maybe with some bash magic?



Many thanks and thanks for the input, cheers
Jonas










share|improve this question


















  • 1





    did you check the terms keyword of Elasticsearch?

    – Always Sunny
    Jan 2 at 16:14






  • 1





    elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

    – xeraa
    Jan 2 at 17:33











  • wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

    – Jnsness
    Jan 3 at 10:10
















0















I need to verify and find the respective entries, that matches to a huge list of (in my case) verbs.
For example: I have 200 statements in a csv and need to find the matching items in my index.
I can only find bool and query-string examples, but it would get REALLY ugly to write down 200 seperate statements and connect them with OR (or should).



Is there a smart way to do that? Maybe with some bash magic?



Many thanks and thanks for the input, cheers
Jonas










share|improve this question


















  • 1





    did you check the terms keyword of Elasticsearch?

    – Always Sunny
    Jan 2 at 16:14






  • 1





    elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

    – xeraa
    Jan 2 at 17:33











  • wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

    – Jnsness
    Jan 3 at 10:10














0












0








0








I need to verify and find the respective entries, that matches to a huge list of (in my case) verbs.
For example: I have 200 statements in a csv and need to find the matching items in my index.
I can only find bool and query-string examples, but it would get REALLY ugly to write down 200 seperate statements and connect them with OR (or should).



Is there a smart way to do that? Maybe with some bash magic?



Many thanks and thanks for the input, cheers
Jonas










share|improve this question














I need to verify and find the respective entries, that matches to a huge list of (in my case) verbs.
For example: I have 200 statements in a csv and need to find the matching items in my index.
I can only find bool and query-string examples, but it would get REALLY ugly to write down 200 seperate statements and connect them with OR (or should).



Is there a smart way to do that? Maybe with some bash magic?



Many thanks and thanks for the input, cheers
Jonas







csv elasticsearch query-string






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jan 2 at 16:09









JnsnessJnsness

13




13








  • 1





    did you check the terms keyword of Elasticsearch?

    – Always Sunny
    Jan 2 at 16:14






  • 1





    elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

    – xeraa
    Jan 2 at 17:33











  • wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

    – Jnsness
    Jan 3 at 10:10














  • 1





    did you check the terms keyword of Elasticsearch?

    – Always Sunny
    Jan 2 at 16:14






  • 1





    elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

    – xeraa
    Jan 2 at 17:33











  • wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

    – Jnsness
    Jan 3 at 10:10








1




1





did you check the terms keyword of Elasticsearch?

– Always Sunny
Jan 2 at 16:14





did you check the terms keyword of Elasticsearch?

– Always Sunny
Jan 2 at 16:14




1




1





elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

– xeraa
Jan 2 at 17:33





elastic.co/guide/en/elasticsearch/reference/current/… to be exact though this will only work for not analyzed terms.

– xeraa
Jan 2 at 17:33













wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

– Jnsness
Jan 3 at 10:10





wow this looks really promising - so I basically just build a new index with my search-terms and check against this index? Will try that and give a review later :-)

– Jnsness
Jan 3 at 10:10












1 Answer
1






active

oldest

votes


















0














terms was the right approach. I simply create a second index with an Array of X-verbs and combine it in the terms-query
thanks a lot!






share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54009543%2felasticsearch-bool-query-hundred-of-or-terms%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    terms was the right approach. I simply create a second index with an Array of X-verbs and combine it in the terms-query
    thanks a lot!






    share|improve this answer




























      0














      terms was the right approach. I simply create a second index with an Array of X-verbs and combine it in the terms-query
      thanks a lot!






      share|improve this answer


























        0












        0








        0







        terms was the right approach. I simply create a second index with an Array of X-verbs and combine it in the terms-query
        thanks a lot!






        share|improve this answer













        terms was the right approach. I simply create a second index with an Array of X-verbs and combine it in the terms-query
        thanks a lot!







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 3 at 11:07









        JnsnessJnsness

        13




        13
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54009543%2felasticsearch-bool-query-hundred-of-or-terms%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

            SQL update select statement

            WPF add header to Image with URL pettitions [duplicate]