phoenix-5.0.0.3.1.4.0-315.tar.gz

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)