any update? On Thursday, December 11, 2014 at 3:07:59 PM UTC+2, PMOPMO wrote: > > Hello all, > I want to run a simple *sql group by query* in kibana 4 "Discover" page. > Each record in my elastic search index represent a log and has 3 columns: > process_id (not unique value), log_time, log_message. > > example: > > process_id log_time log_message > ---------------- -------------------- -------------------- > > 1 2014/12/11 01:00 msg1 > 1 2014/12/11 01:10 msg2 > 1 2014/12/11 01:20 msg3 > 2 2014/12/11 11:00 msg4 > 2 2014/12/11 11:10 msg5 > > > I want to generate a table in kibana that looks like: > > > process_id first log_time last log_time > ---------------- ------------------------ > -------------------- > 1 2014/12/11 01:00 2014/12/11 01:20 > 2 2014/12/11 11:00 2014/12/11 01:10 > > > In sql the query is simple: > select process_id, max(log_time), min(log_time) > from logs_table > group by process_id > > How can I run this query in Kibana? Is it possible to run the query in > "Discover" page or should I create a panel (Visualize page)? > > thanks. >
-- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bf13be11-d003-4038-925a-37331d55f9ae%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
