NAME

Search::Elasticsearch::Client::7_0::Direct::SQL - Plugin providing SQL for Search::Elasticsearch 7.x

VERSION

version 8.12

SYNOPSIS

    my $response = $es->sql->query( body => {...} )

DESCRIPTION

This class extends the Search::Elasticsearch client with an sql namespace, to support the SQL APIs.

The full documentation for the SQL feature is available here: https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html

GENERAL METHODS

query()

    $response = $es->sql->query(
        body    => {...} # required
    )

The query() method executes an SQL query and returns the results.

Query string parameters: error_trace, filter_path, format, human

See the query docs for more information.

translate()

    $response = $es->sql->translate(
        body    => {...} # required
    )

The translate() method takes an SQL query and returns the query DSL which would be executed.

Query string parameters: error_trace, filter_path, human

See the translate docs for more information.

clear_cursor()

    $response = $es->sql->clear_cursor(
        body    => {...} # required
    )

The clear_cursor() method cleans up an ongoing scroll request.

Query string parameters: error_trace, filter_path, human

See the query docs for more information.

AUTHOR

Enrico Zimuel <enrico.zimuel@elastic.co>

COPYRIGHT AND LICENSE

This software is Copyright (c) 2024 by Elasticsearch BV.

This is free software, licensed under:

  The Apache License, Version 2.0, January 2004

cpanm Search::Elasticsearch::Client::7_0

perl -MCPAN -e shell
install Search::Elasticsearch::Client::7_0