Image Description
abetomo/Convert-Athena-QueryResults-to-Array
  • 4 Stars
  • 5 years ago

Convert-Athena-QueryResults-to-Array

Latest Stable Version Test

Convert AWS Athena QueryResults to Array. Since the response of GetQueryResults is complicated, it converts it to a simple array.

Installation

% composer require abetomo/convert-athena-query-results-to-array

Usage

Convert the response of GetQueryResults into an array.

<?php
// ... startQueryExecution, etc.

$getQueryResultsResponse = $athenaClient->getQueryResults([
    'QueryExecutionId' => $queryExecutionId
]);
use Abetomo\ConvertAthenaQueryResultstoArray\ConvertAthenaQueryResultstoArray;
print "/// Original value\n";
print_r($getQueryResultsResponse->get('ResultSet'));
print "\n/// Convert to array \n";
print_r(ConvertAthenaQueryResultstoArray::convert(
    $getQueryResultsResponse->get('ResultSet'),
    true // $isSkipHeader
));

Example of results

Convert to array

Array
(
    [0] => Array
        (
            [account_id] => id1
            [count] => 49
        )

    [1] => Array
        (
            [account_id] => id2
            [count] => 68
        )

)

Original value

Array
(
    [Rows] => Array
        (
            [0] => Array
                (
                    [Data] => Array
                        (
                            [0] => Array
                                (
                                    [VarCharValue] => account_id
                                )

                            [1] => Array
                                (
                                    [VarCharValue] => count
                                )

                        )

                )

            [1] => Array
                (
                    [Data] => Array
                        (
                            [0] => Array
                                (
                                    [VarCharValue] => id1
                                )

                            [1] => Array
                                (
                                    [VarCharValue] => 49
                                )

                        )

                )

            [2] => Array
                (
                    [Data] => Array
                        (
                            [0] => Array
                                (
                                    [VarCharValue] => id2
                                )

                            [1] => Array
                                (
                                    [VarCharValue] => 68
                                )

                        )

                )

        )

    [ResultSetMetadata] => Array
        (
            [ColumnInfo] => Array
                (
                    [0] => Array
                        (
                            [CatalogName] => hive
                            [SchemaName] =>
                            [TableName] =>
                            [Name] => account_id
                            [Label] => account_id
                            [Type] => varchar
                            [Precision] => 2147483647
                            [Scale] => 0
                            [Nullable] => UNKNOWN
                            [CaseSensitive] => 1
                        )

                    [1] => Array
                        (
                            [CatalogName] => hive
                            [SchemaName] =>
                            [TableName] =>
                            [Name] => count
                            [Label] => count
                            [Type] => integer
                            [Precision] => 10
                            [Scale] => 0
                            [Nullable] => UNKNOWN
                            [CaseSensitive] =>
                        )

                )

        )

)