Re: Help with query

2014-06-03 Thread Nitin Pawar
can you put your example with sample data and expected result output? On Fri, May 30, 2014 at 4:59 AM, Software Dev wrote: > We have a table with user entered queries, their IP. How could we > write a query that will count and order queries by their count having > a unique IP count > X. For exa

Re: Hive Avro union data access

2014-06-03 Thread Fastupload
Sathish, Curent version Hive ONLY support union type has two primitive/struct types, i.e.. {“name”: “alias_host”, “type”: [ “string”, “null” ]} , or {“name”: “alias_host”, “type”: [{“type”: “array”, “items”: “string”]}, “null”}. You can consider JSON string as a column type when the column has s

RE: alter table add more columns

2014-06-03 Thread Ricardo Birmele
Sorry for jumping in here…but could one of you be kind enough to point me to where I can get smarter on employing multiple partitions? Specifically, I’m not looking for SQL guidance, · Column layout (do the partition column(s) have to be in any particular place in the DDL…like being th

Hive 0.13/Hcatalog : Mapreduce Exception : java.lang.IncompatibleClassChangeError

2014-06-03 Thread Sundaramoorthy, Malliyanathan
Hi, I am using Hadoop 2.4.0 with Hive 0.13 + included package of HCatalog . Wrote a simple map-reduce job from the example and running the code below .. getting "Exception in thread "main" java.lang.IncompatibleClassChangeError: Found interface org.apache.hadoop.mapreduce.JobContext, but class w

Hive and Tez User Meetup

2014-06-03 Thread Owen O'Malley
We have a Hive and Tez User Meetup scheduled for Thursday afternoon in San Jose. The meetup is open to everyone. There are lots of working being done on Hive, come join us! http://www.meetup.com/Hadoop-Summit-Community-San-Jose/events/179084702/ Currently the schedule includes: * Hive 0.13 releas

Re: Storing result of a query in a variable

2014-06-03 Thread Mohammad Tariq
Hi Chhaya, Try this : var=`hive -S -e "YOUR_HIVE_QUERY;"` *Warm regards,* *Mohammad Tariq* *cloudfront.blogspot.com * On Tue, Jun 3, 2014 at 4:47 PM, Chhaya Vishwakarma < chhaya.vishwaka...@lntinfotech.com> wrote: > ./hive -e --hiveconf MY_VAR =`cat /tmp/result

RE: Storing result of a query in a variable

2014-06-03 Thread Chhaya Vishwakarma
./hive -e --hiveconf MY_VAR =`cat /tmp/result/00_0`; Is not working From: Sanjay Subramanian [mailto:sanjaysubraman...@yahoo.com] Sent: Tuesday, June 03, 2014 2:30 AM To: user@hive.apache.org Subject: Re: Storing result of a query in a variable Add -e option ./hive -e --hiveconf MY_VAR =`c