SqlLine
=======
https://github.com/julianhyde/sqlline

Execute SQL from command line. Sqlline manual is available at https://julianhyde.github.io/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)