system sh/stop_dnodes.sh






system sh/deploy.sh -n dnode1 -i 1
system sh/deploy.sh -n dnode2 -i 2
system sh/deploy.sh -n dnode3 -i 3
system sh/deploy.sh -n dnode4 -i 4

system sh/cfg.sh -n dnode1 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode2 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode3 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode4 -c numOfMPeers -v 1

system sh/cfg.sh -n dnode1 -c mgmtEqualVnodeNum -v 10
system sh/cfg.sh -n dnode2 -c mgmtEqualVnodeNum -v 10
system sh/cfg.sh -n dnode3 -c mgmtEqualVnodeNum -v 10
system sh/cfg.sh -n dnode4 -c mgmtEqualVnodeNum -v 10

system sh/cfg.sh -n dnode1 -c maxtablesPerVnode -v 2000
system sh/cfg.sh -n dnode2 -c maxtablesPerVnode -v 2000
system sh/cfg.sh -n dnode3 -c maxtablesPerVnode -v 2000
system sh/cfg.sh -n dnode4 -c maxtablesPerVnode -v 2000

system sh/cfg.sh -n dnode1 -c commitlog -v 0
system sh/cfg.sh -n dnode2 -c commitlog -v 0
system sh/cfg.sh -n dnode3 -c commitlog -v 0
system sh/cfg.sh -n dnode4 -c commitlog -v 0

print ========= start dnode1
system sh/exec.sh -n dnode1 -s start
sleep 3000
sql connect

sql create database db
sql use db
sql create table tb1(ts timestamp, i int, j float, k double)

print ================= step1

$i = 0
$timestamp = 1564641700000
while $i < 1000
  
  $val = 10 * $i
  $val = $val + 2
  $ts = $timestamp + 200
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 3
  $ts = $timestamp + 300
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 4
  $ts = $timestamp + 400
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 5
  $ts = $timestamp + 500
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 6
  $ts = $timestamp + 600
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 7
  $ts = $timestamp + 700
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 8
  $ts = $timestamp + 800
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 9
  $ts = $timestamp + 900
  sql insert into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 1
  $ts = $timestamp + 100
  sql import into tb1 values ( $ts , $val , $val , $val ) 
  
  $val = 10 * $i
  $val = $val + 0
  $ts = $timestamp + 0
  sql import into tb1 values ( $ts , $val , $val , $val ) 
  
  $timestamp = $timestamp + 1000
  $i = $i + 1
endw 

print ================= step2