Search by 
david50407 / convert-athena-query-results-to-array
Convert AWS Athena QueryResults to Array.
v1.0.2
2018-11-16 06:28 UTC
Requires
- php: >=7.1
Requires (Dev)
- phpunit/phpunit: ^7.3
This package is auto-updated.
Last update: 2025-05-16 20:38:20 UTC
README
Convert AWS Athena QueryResults to Array. Since the response of GetQueryResults is complicated, it converts it to a simple array.
Installation
% composer require david50407/convert-athena-query-results-to-array
Usage
Convert the response of GetQueryResults into an array.
<?php // ... startQueryExecution, etc. $getQueryResultsResponse = $athenaClient->getQueryResults([ 'QueryExecutionId' => $queryExecutionId ]); use david50407\ConvertAthenaQueryResultstoArray\ConvertAthenaQueryResultstoArray; print "/// Original value\n"; print_r($getQueryResultsResponse->get('ResultSet')); print "\n/// Convert to array \n"; print_r(ConvertAthenaQueryResultstoArray::convert($getQueryResultsResponse->get('ResultSet')));
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] =>
)
)
)
)