blob: f1d1f0df49c569bfedb889b89b432dd4b4773387 [file] [log] [blame]
SqlLine
=======
https://github.com/julianhyde/sqlline
Execute SQL from command line. Sqlline manual is available at http://www.hydromatic.net/sqlline/manual.html
Usage:
$ sqlline.py <zookeeper> <optional_sql_file>
Example:
$ sqlline.py localhost
$ sqlline.py localhost <examples dir>/STOCK_SYMBOL.sql
psql.py
=======
Usage: psql [-t table-name] [-h comma-separated-column-names | in-line] <zookeeper> <path-to-sql-or-csv-file>...
Example 1. Create table, upsert row and run query using single .sql file
./psql.py localhost <examples dir>/STOCK_SYMBOL.sql
Example 2. Create table, load CSV data and run queries using .csv and .sql files:
./psql.py localhost <examples dir>/WEB_STAT.sql <examples dir>/WEB_STAT.csv <examples dir>/WEB_STAT_QUERIES.sql
Note: Please see comments in WEB_STAT_QUERIES.sql for the sample queries being executed
performance.py
==============
Usage: performance <zookeeper> <row count>
Example: Generates and upserts 1000000 rows and time basic queries on this data
./performance.py localhost 1000000
CSV MapReduce Loader
====================
Usage: hadoop jar phoneix-[version]-mapreduce.jar <parameters>
-a,--array-delimiter <arg> Array element delimiter (optional)
-c,--import-columns <arg> Comma-separated list of columns to be
imported
-d,--delimiter <arg> Input delimiter, defaults to comma
-g,--ignore-errors Ignore input errors
-h,--help Show this help and quit
-i,--input <arg> Input CSV path (mandatory)
-o,--output <arg> Output path for temporary HFiles (optional)
-s,--schema <arg> Phoenix schema name (optional)
-t,--table <arg> Phoenix table name (mandatory)
-z,--zookeeper <arg> Zookeeper quorum to connect to (optional)