Skip to content

Latest commit

 

History

History
executable file
·
95 lines (77 loc) · 2.68 KB

README.tools.md

File metadata and controls

executable file
·
95 lines (77 loc) · 2.68 KB

The tools

Create/Drop a database
See usage or

php database.php -h/--help

Execute a single query
select | create table [as] | create view | create database | delete table ...

See usage or

php query.php -h/--help

Execute queries for each day in the given date range within the max rate limit
select | create table [as] | create view | create database | delete table ...

Examples: query-daily.sql

See usage or

php query-daily.php -h/--help

Execute queries for each month in the given date range within the max rate limit
select | create table [as] | create view | create database | delete table ...

Examples: create-table.sql, create-table-partitioned.sql, create-table-partitioned-hive.sql, drop-table.sql, query-monthly.sql

See usage or

php query-monthly.php -h/--help

Create day partitions on a table (non-Hive formatted data)
See usage or

php partitions-daily.php -h/--help

Create day partitions on a table (Hive formatted data)
See usage or

php partitions-daily-hive.php -h/--help

Get the execution state of a query (running, failed, succeeded, ...)
See usage or

php state.php -h/--help

Get the execution state of queries listed in a file (running, failed, succeeded, ...)
Example: query-ids-list.txt

See usage or

php state-from-list.php -h/--help

Stop a running query
See usage or

php stop.php -h/--help

Create or delete a named query
See usage or

php named-query.php -h/--help

Detail one or all named queries and output to json format
See usage or

php list-named-queries.php -h/--help

Detail one or all databases and output to json format
See usage or

php list-databases.php -h/--help

Detail one or all tables of a database and output to json format
See usage or

php list-tables.php -h/--help