QuestionQ55Verified/CQL Querying and Data AnalysisCopy linkReport a problemAsk AstroTutorSave questionWhich of the following CQL statements correctly places the AND statements and the pipe symbol?A#sourcefile="jobfilename" AND stdout=/[[+]]/ | groupBy([hostname], function=collect([hostname,stdout])) AND stdout != "" AND stdout != "* No artifacts *" | select([hostname,stdout])B#sourcefile="jobfilename" | stdout=/[[+]]/ | groupBy([hostname], function=collect([hostname,stdout])) | stdout != "" AND stdout != "* No artifacts *" AND select([hostname,stdout])C#sourcefile="jobfilename" AND stdout=/[[+]]/ | groupBy([hostname], function=collect([hostname,stdout])) | stdout != "" AND stdout != "* No artifacts *" | select([hostname,stdout])D#sourcefile="jobfilename" | stdout=/[[+]]/ AND groupBy([hostname], function=collect([hostname,stdout])) AND stdout ! = "" | stdout != "* No artifacts *" | select([hostname,stdout])Show AnswerAnswerExplanationCQL uses AND to combine predicates in the same filter expression and | to pass results into the next pipeline stage. The valid sequence combines the initial source-file and stdout predicates, then pipes to groupBy, applies the subsequent stdout predicates together, and finally pipes to select.Show comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion