Skip to content

Instantly share code, notes, and snippets.

@emersonbarros

emersonbarros/insert-cql.sh

Created June 17, 2020 00:50
Show Gist options
  • Save emersonbarros/646ef84493c2a775bd3e6e15c14fc571 to your computer and use it in GitHub Desktop.
Save emersonbarros/646ef84493c2a775bd3e6e15c14fc571 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
insert-cql.sh
#!/bin/sh
for i in {1..10000000}
do
DATE=`date '+%Y-%m-%d %H:%M:%S'`
TEXT="TEXT VALUE"
#echo "Looping ... number $i"
echo "INSERT INTO test.bulk1 (partition, create_date, description, randon) VALUES (1, '$DATE', '$TEXT $RANDON', '$i');" >> result.txt
done
echo "exit;" >> result.txt
cat result.txt | ccm node1 cqlsh
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment