Switch branches/tags
v5.0.0-alpha-HBase-2.0 v5.0.0-alpha-HBase-2.0-rc1 v5.0.0-alpha-HBase-2.0-rc0 v5.0.0-HBase-2.0 v5.0.0-HBase-2.0-rc1 v5.0.0-HBase-2.0-rc0 v4.14.1-HBase-1.4-rc0 v4.14.1-HBase-1.3-rc0 v4.14.1-HBase-1.2-rc0 v4.14.1-HBase-1.1-rc0 v4.14.1-HBase-0.98-rc0 v4.14.0-cdh5.14.2 v4.14.0-cdh5.14.2-rc3 v4.14.0-cdh5.14.2-rc2 v4.14.0-cdh5.14.2-rc1 v4.14.0-cdh5.14.2-rc0 v4.14.0-cdh5.13.2 v4.14.0-cdh5.13.2-rc3 v4.14.0-cdh5.13.2-rc2 v4.14.0-cdh5.13.2-rc1 v4.14.0-cdh5.13.2-rc0 v4.14.0-cdh5.12.2 v4.14.0-cdh5.12.2-rc3 v4.14.0-cdh5.12.2-rc2 v4.14.0-cdh5.12.2-rc1 v4.14.0-cdh5.12.2-rc0 v4.14.0-cdh5.11.2 v4.14.0-cdh5.11.2-rc3 v4.14.0-cdh5.11.2-rc2 v4.14.0-cdh5.11.2-rc1 v4.14.0-cdh5.11.2-rc0 v4.14.0-HBase-1.4 v4.14.0-HBase-1.4-rc3 v4.14.0-HBase-1.4-rc1 v4.14.0-HBase-1.3 v4.14.0-HBase-1.3-rc3 v4.14.0-HBase-1.3-rc1 v4.14.0-HBase-1.3-rc0 v4.14.0-HBase-1.2 v4.14.0-HBase-1.2-rc3 v4.14.0-HBase-1.2-rc1 v4.14.0-HBase-1.2-rc0 v4.14.0-HBase-1.1 v4.14.0-HBase-1.1-rc3 v4.14.0-HBase-1.1-rc1 v4.14.0-HBase-1.1-rc0 v4.14.0-HBase-0.98 v4.14.0-HBase-0.98-rc3 v4.14.0-HBase-0.98-rc1 v4.14.0-HBase-0.98-rc0 v4.13.2-cdh5.11.2 v4.13.2-cdh5.11.2-rc0 v4.13.1-HBase-1.3-rc0 v4.13.1-HBase-1.2-rc0 v4.13.1-HBase-1.1-rc0 v4.13.1-HBase-0.98-rc0 v4.13.0-HBase-1.3 v4.13.0-HBase-1.3-rc1 v4.13.0-HBase-1.3-rc0 v4.13.0-HBase-0.98 v4.13.0-HBase-0.98-rc1 v4.13.0-HBase-0.98-rc0 v4.12.0-HBase-1.3 v4.12.0-HBase-1.2 v4.12.0-HBase-1.2-rc0 v4.12.0-HBase-1.1 v4.12.0-HBase-1.1-rc0 v4.12.0-HBase-0.98 v4.11.0-HBase-1.3 v4.11.0-HBase-1.3-rc1 v4.11.0-HBase-1.3-rc0 v4.11.0-HBase-1.2 v4.11.0-HBase-1.2-rc1 v4.11.0-HBase-1.2-rc0 v4.11.0-HBase-1.1 v4.11.0-HBase-1.1-rc1 v4.11.0-HBase-1.1-rc0 v4.11.0-HBase-0.98 v4.11.0-HBase-0.98-rc1 v4.11.0-HBase-0.98-rc0 v4.10.0-HBase-1.2 v4.10.0-HBase-1.2-rc1 v4.10.0-HBase-1.2-rc0 v4.10.0-HBase-1.1 v4.10.0-HBase-1.1-rc1 v4.10.0-HBase-1.1-rc0 v4.10.0-HBase-0.98 v4.10.0-HBase-0.98-rc1 v4.10.0-HBase-0.98-rc0 v4.9.0-HBase-1.2 v4.9.0-HBase-1.2-rc5 v4.9.0-HBase-1.2-rc4 v4.9.0-HBase-1.2-rc3 v4.9.0-HBase-1.2-rc2 v4.9.0-HBase-1.2-rc1 v4.9.0-HBase-1.2-rc0 v4.9.0-HBase-1.1 v4.9.0-HBase-1.1-rc5 v4.9.0-HBase-1.1-rc4 v4.9.0-HBase-1.1-rc3
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
argparse-1.4.0
daemon.py PHOENIX-4456 queryserver script doesn't perform as expected. Dec 13, 2017
end2endTest.py PHOENIX-1904 bin scripts use incorrect variable for locating hbase conf Apr 23, 2015
hadoop-metrics2-hbase.properties
hadoop-metrics2-phoenix.properties
hbase-site.xml PHOENIX-3085 Remove Copyright ASF from license headers Jul 20, 2016
log4j.properties
performance.py PHOENIX-4509 Fix performance.py usage text (Artem Ervits) Jan 3, 2018
pherf-cluster.py PHOENIX-2365 Remove Pherf uber jar and create python scripts to execu… Nov 16, 2015
pherf-standalone.py PHOENIX-2365 Remove Pherf uber jar and create python scripts to execu… Nov 16, 2015
phoenix_sandbox.py PHOENIX-2610 Allow passing PHOENIX_OPTS to command line utils Jan 20, 2016
phoenix_utils.py
psql.py
queryserver.py PHOENIX-4892 Unable to start load balancer with queryserver Sep 18, 2018
readme.txt PHOENIX-890 - Script for binary and source RC generation Apr 23, 2014
sandbox-log4j.properties
sqlline-thin.py
sqlline.py
tephra
tephra-env.sh PHOENIX-1674 Snapshot isolation transaction support through Tephra (J… Nov 24, 2015
traceserver.py PHOENIX-4817 Fixed Phoenix Tracing Web Application (fixed check null,… Jul 25, 2018

readme.txt

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)