/ 
Search-Elasticsearch-Client-7_0-8.00
River stage one • 2 direct dependents • 3 total dependents
++
/ Search::Elasticsearch::Client::7_0::Direct::SQL

NAME

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

VERSION

version 8.00

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) 2022 by Elasticsearch BV.

This is free software, licensed under:

  The Apache License, Version 2.0, January 2004