ES Aggregations in Spark

kucera.jan.cz · March 28, 2016, 1:18pm

Hello everyone,

based on discussion about ES use cases I was wondering whether there is any way how Spark could benefit from ES aggregations and convert them to Dataframe. F.e something like:
val esConf = ... val esQuery = """{"agg" : {"my_agg" : {"terms" : {"field": "field_A"} } } }""" val jsonResult = client.search(esQuery, esConf) val transformer = ... val df = jsonResult.toDF(transformer) val result = df.filter(...).join(otherDf) ....

A) Is there any plan to support something similar in ES roadmap?
B) As I understood correctly how spark-es/hadoop-es works library based on scroll's json results "detects" dataframe's schema. Can you direct me to classes which is responsible for this detection? I was wondering whether these components could be used for building 'transformer' I had in my example.

Thanks advance for your suggestions
-Jan

costin · April 5, 2016, 2:47pm

A) Aggregations are not currently supported by ES-Hadoop; it's the next major item on the roadmap.
B) All the spark SQL classes reside under their dedicated package:

github.com

elastic/elasticsearch-hadoop/blob/master/spark/sql-13/src/main/scala/org/elasticsearch/spark/sql/DefaultSource.scala

/*
 * Licensed to Elasticsearch under one or more contributor
 * license agreements. See the NOTICE file distributed with
 * this work for additional information regarding copyright
 * ownership. Elasticsearch licenses this file to you under
 * the Apache License, Version 2.0 (the "License"); you may
 * not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *    http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
package org.elasticsearch.spark.sql

This file has been truncated. show original

Topic		Replies	Views
Support for Aggregations in Spark Elasticsearch es-hadoop	2	1181	June 24, 2019
ElasticSearch and JSON SparkSQL Elasticsearch es-hadoop	2	1075	July 6, 2017
Use Spark to index data in HDFS Elasticsearch es-hadoop	2	1620	July 6, 2017
Add Es Spark Accumulators Elasticsearch es-hadoop	3	277	December 19, 2023
Databricks Spark SQL and Elasticsearch Elasticsearch es-hadoop	5	504	April 19, 2023

ES Aggregations in Spark

Related topics