Just alias the column name.  With aggregations any output automatically gives a value of c + Index number.  In this case it is c0 as it's only one aggregate column.  An example of a query with the above output as count with the number under it is SELECT count)(*) as count from <TABLE_NAME> should give you the c0 column listed as count.  If you are looking to store the output as a variable as a local variable in you could do something like: count=`hive -S -e "select count(*) from <TABLE_NAME>;"` echo $count   ... View more

you can technically run an infinite loop with python and just produce a print statement.  this will send out data.   ... View more