Command for creating and loading data
export PHOENIX_HOME=/home/hadoop/git/phoenix/ export PROJECT_HOME=/home/hadoop/git/schema_design/ export DATA_DIR=/home/hadoop/git/TPC-H-Hive/dbgen/
$PHOENIX_HOME/bin/psql.sh localhost $PROJECT_HOME/bin/create_tables.sql
$PROJECT_HOME/bin/load_tables.sh $DATA_DIR
Command for dropping tables
$PHOENIX_HOME/bin/psql.sh localhost $PROJECT_HOME/drop_tables.sql
Command for generating training data
java -cp $PROJECT_HOME/lib/TrainingDataGeneratorForTPCH.jar:$PROJECT_HOME/lib/phoenix-3.0.0-SNAPSHOT-client.jar duke.hbase.sd.tdg.TrainingDataGeneratorForTPCH all
Thanks Eric for providing the cost model package cm-1.2.tar.gz. Cost model is implemented in c++.
compilation steps for cost model
installing dependencies:
sudo apt-get install libgsl0-dev
sudo apt-get install libatlas-dev
sudo apt-get install libgflags-dev
compiling cost model:
cd cm-1.2/
make
Command for running schema design
java -cp $PROJECT_HOME/lib/SchemaDesignImpl.jar:$PROJECT_HOME/lib/phoenix-3.0.0-SNAPSHOT-client.jar duke.hbase.sd.SchemaDesignImpl