Example Essentia Syntax

ess server reset

ess create database largecount

ess create table mytable "s,pkey:country s,+key:user s,+first:time s,+last:time i,+add:payment"

ess create vector countrytotals "s,pkey:country i,+add:usercount i,+add:payment"

ess create variable "i:totalusers"

ess drop database largecount

ess drop table mytable

ess drop vector countrytotals

ess drop variable

ess use largecount

ess server summary

ess server commit

ess udbd start

ess udbd stop

ess udbd status

ess server restart

ess select local
ess select s3://asi-public --credentials=/home/ec2-user/asi-public.csv
ess select blob://my_azure_container --account_name=my_account_name --account_key=my_account_key

ess summary

ess scan

ess category add myfavoritedata "*exampledata*gz" --dateformat "*MM-YY-DD*"

ess category delete myfavoritedata

ess category change comment myfavoritedata "This category deserves a comment"

ess ls "*"

ess ls -r --cat myfavoritedata "*"

ess stream myfavoritedata "2013-10-01" "2014-09-30" "aq_pp -f,+1,eok - -d %cols -eval i:usercount '0' -udb largecount -imp mytable -imp countrytotals" --debug --master --thread=4

ess exec "aq_udb -exp largecount:mytable" --debug --master

ess cluster create --number=4 --type=t2.micro

ess cluster terminate

ess cluster status

ess query 'select * from myfavoritedata:*:* where payment >= 50'
ess query "select * from purchase:2014-09-01:2014-09-15 where articleID>=46 limit 10"

ess redshift register MyRed

ess redshift stream myfavoritedata '*' '*' "aq_pp -f,+1,eok - -d %cols -eval i:usercount '0'" --debug --master --threads=2 -U bwaxer -d redcount -p mysecret

ess redshift status

ess -v
ess --version

ess cat path_to_data/exampledata.csv

ess lsa my_archive_file.zip

ess file get path_to_file/exampledata.csv

ess file put exampledata.csv --dest path_to_put_file/

ess file mkdir path_to_put_file/