All supporting files are at SupportingFiles/Introduction/Transwarp-ArgoDB

1. Introduction

Transwarp ArgoDB is the DBMS used in this test, which is a distributed flash database product issued by Transwarp. For more detail, please refer http://www.transwarp.io/en/transwarp/product-ArgoDB.html?categoryId=77

beeline is the client in Transwarp ArgoDB. It connects to the server by jdbc. The command is:

beeline -u jdbc:hive2://localhost:10000 --maxWidth=1000
(--maxWidth is a parameter to control the output width )


2. Cluster configure
There are 16 nodes in the cluster. All nodes are datanodes and workers.

Each worker is confiured with 4 executors, and each executor is configured with 16 vcores and 32G memory. 

The configure is in file:
SupportingFiles/Introduction/Transwarp-ArgoDB/hive-env.sh

export INCEPTOR_EXECUTOR_MEMORY=32000
export SPARK_CORES=16

The shuffle dir of executors is defined in SupportingFiles/Introduction/Transwarp-ArgoDB/ngmr-env.sh
export SPARK_LOCAL_DIR=/vdir/mnt/disk1/hadoop/ngmr/argodbcomputing1,/vdir/mnt/disk2/hadoop/ngmr/argodbcomputing1,/vdir/mnt/disk3/hadoop/ngmr/argodbcomputing1,/vdir/mnt/disk4/hadoop/ngmr/argodbcomputing1


3. Optimization options for SQL
It is defined in SupportingFiles/Introduction/Transwarp-ArgoDB/config

