#!/bin/sh
source conf/drillTestConfig.properties

hadoop fs -mkdir -p /drill/testdata/tpch100_$1files
var=5150000
mul=`expr $1 / 5000`
echo $mul
size=`expr $var / $mul`
echo $size
#sed "s/$var/$size/g" "gendata.ddl" > gendata.ddl_temp && mv gendata.ddl_temp gendata.ddl
${DRILL_HOME}/bin/sqlline -n user1 -p mapr -u "jdbc:drill:schema=dfs.tpch100_$1files;drillbit=${DRILL_STORAGE_PLUGIN_SERVER}"  --run=${DRILL_TEST_DATA_DIR}/Datasources/metadata_caching/gendata.ddl
#sed "s/$size/$var/g" "gendata.ddl" > gendata.ddl_temp && mv gendata.ddl_temp gendata.ddl

# TODO: it seems that sqlline does not exit, if one of the queries failed.
if [ "$?" -eq 0 ]
then
        exit 0
else
        echo "ERROR: create table script failed. Rerun create_tables_parquet.ddl to debug failures."
        exit 1
fi