PHP Classes

File: examples/SearchQuery.php

Recommend this page to a friend!
  Classes of T. H.   Druid PHP Client   examples/SearchQuery.php   Download  
File: examples/SearchQuery.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Druid PHP Client
Send queries to a Apache Druid service
Author: By
Last change:
Date: 4 years ago
Size: 1,323 bytes
 

Contents

Class file image Download
<?php
declare(strict_types=1);

error_reporting(E_ALL);
ini_set('display_errors', 'On');

include
__DIR__ . '/../vendor/autoload.php';
include
__DIR__ . '/helpers/ConsoleLogger.php';
include
__DIR__ . '/helpers/ConsoleTable.php';

use
Level23\Druid\DruidClient;
use
Level23\Druid\Types\SortingOrder;
use
Level23\Druid\Context\QueryContext;

try {
   
$client = new DruidClient(['router_url' => 'http://127.0.0.1:8888']);

   
// Enable this to see some more data
    //$client->setLogger(new ConsoleLogger());

    // Build a search query
   
$builder = $client->query('wikipedia')
        ->
interval('2015-09-12 00:00:00', '2015-09-13 00:00:00')
        ->
dimensions(['namespace']) // If left out, all dimensions are searched
       
->searchContains('wikipedia')
        ->
limit(150);

   
// Example of setting query context. It can also be supplied as an array in the search() method call.
   
$context = new QueryContext();
   
$context->setPriority(100);

   
// Execute the query.
   
$response = $builder->search($context, SortingOrder::STRLEN);

   
// Display the result as a console table.
   
new ConsoleTable($response->data());
} catch (
Exception $exception) {
    echo
"Something went wrong during retrieving druid data\n";
    echo
$exception->getMessage() . "\n";
    echo
$exception->getTraceAsString();
}