Hive, mail # user - Re: Storing result of a query in a variable - 2014-06-02, 21:03
Solr & Elasticsearch trainings in New York & San Fransisco [more info][hide]
 Search Hadoop and all its subprojects:

Switch to Threaded View
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