Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: Storing result of a query in a variable


Copy link to this message
-
Re: Storing result of a query in a variable
Add  -e option

./hive -e --hiveconf MY_VAR =`cat /tmp/result/000000_0`;
But u could use the following hdfs command as well

MY_VAR=$(hdfs dfs -cat /tmp/result/000000_0)

thanks

sanjay
________________________________
 From: Chhaya Vishwakarma <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Monday, June 2, 2014 12:06 AM
Subject: Storing result of a query in a variable
 
 
 
 
Hi ,
 
I have a query whose result I wanted to store in a variable
How can I do it ?
I tried
 
./hive -e  "use telecom;insert overwrite local directory '/tmp/result' select
avg( a from abc;"
 
./hive --hiveconf MY_VAR =`cat /tmp/result/000000_0`;
 
I am able to get average value in MY_VAR but it takes me in hive CLI which is not required
 
 
________________________________
 The contents of this e-mail and any attachment(s) may contain confidential or privileged information for the intended recipient(s). Unintended recipients are prohibited from taking action on the basis of information in this e-mail and using or disseminating the information, and must notify the sender and delete it from their system. L&T Infotech will not accept responsibility or liability for the accuracy or completeness of, or the presence of any virus or disabling code in this e-mail"
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB