Join us on Tuesday, December 5th, at the Elastic Arlington office for a special Washington, D.C. Elastic User Group holiday meetup. We will have presentations, followed by networking and festive holiday treats and refreshments.

Please RSVP if you plan on attending. Registration closes on Monday, December 4th so we can provide a list of names to building security.

⚡️ We are still looking for lightning talks: 5 to 10-minute presentations. ⚡️ Have you ever considered presenting, but think 30 or 45 minutes is too long to start with? This is a great opportunity to try it out. Interested? Please send us an email at: meetups@elastic.co.

Date and Time:

Tuesday, December 5th from 5:30-7:30 pm EST

Location:

Elastic Arlington Office - 4100 Fairfax Drive, Ste 500, Arlington, VA 22203

Parking:

• The building’s parking garage is operated by Colonial Parking and is located off N. Randolph Street
• Book a spot on SpotHero
• A Metro Station is located across the street

Agenda:

• 5:30 pm: Doors open; say hi, grab a seat, and eat some food.
• 5:45 pm: Developer Relations @ Elastic: Who we are, what we do, and how to get involved - with Ully Sampaio (DevRel Program Manager @ Elastic)
• 6:00 pm: Lightening Talk: Aggregations, the Elasticsearch Group By - with John Sobanski (Sr. Director - Analytics Practice @ Pyramid Systems, Inc.)
• 6:15 pm: Talk # 3 - Details coming soon!
• 6:45-7:30 pm: Networking & refreshments

Talk Abstracts:

Aggregations, the Elasticsearch Group By - John Sobanski, Sr. Director - Analytics Practice @ Pyramid Systems, Inc.

Elastic Architects designed the distributed Elasticsearch platform to follow NoSql principles. In the traditional Relational Database Management System (RDBMS) world, SQL databases use GROUP BY syntax to group rows with similar values into summary rows. While Elasticsearch does not use the row construct to identify a unit of data (Elastic calls their rows Documents), we can still perform GROUP BY queries in Elasticsearch. Elasticsearch names their GROUP BY queries Aggregations. The Elasticsearch API provides an expressive REST API to execute Aggregations. Kibana also provides a Graphical User Interface (GUI) to execute Aggregations. John demonstrates both methods in his lightning talk.