P19 23.07 online-configP19

1 files changed, 50 insertions, 0 deletions

diff --git a/TWA-PIC/phoenix-hbase/bin/readme.txt b/TWA-PIC/phoenix-hbase/bin/readme.txt
new file mode 100644
index 0000000..e9c5243
--- /dev/null
+++ b/TWA-PIC/phoenix-hbase/bin/readme.txt
@@ -0,0 +1,50 @@
+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)
+