java.lang.NoSuchFieldError: type

2012-04-03 Thread Roshan Pradeep
Hi All I configured Apache hadoop 1.0.1 and Hive 0.8.1 in my local linux box. Configured the HADOOP_HOME and just try to run the "SHOW TABLES;" on hive, but below error blocks me. I have nothing changed and all are standard installations provided in the download section. hive> SHOW TABLES; Excep

Question about org.apache.hadoop.hive.contrib.serde2.RegexSerDe

2012-04-03 Thread java8964 java8964
Hi, I have a question about the behavior of the class org.apache.hadoop.hive.contrib.serde2.RegexSerDe. Here is the example I tested using the Cloudra hive-0.7.1-cdh3u3 release. The above class did NOT do what I expect, any one knows the reason? user:~/tmp> more Test.javaimport java.io.*;impor

Re: Why BucketJoinMap consume too much memory

2012-04-03 Thread Amit Sharma
I am experiencing similar behavior in my queries. All the conditions for bucketed map join are met, and the only difference in execution when i set the hive.optimize.bucketmapjoin flag to true, is that instead of a single hash table, multiple hash tables are created. All the Hash Tables are still c

RE: Hive Queries Performance Tuning - Map side joins, Map side aggregations, Partitioning/Clustering

2012-04-03 Thread Ladda, Anand
Thanks Bejoy and Nitin. I've read through the join presentation by Namit Jain and Liyin Tang from Facebook and got some ideas on how to improve the join performance. * I understand how Map Joins work but wasn't clear on the workflow of bucketed map joins. Is having map join enabled a pr

RE: Hive Meta Information

2012-04-03 Thread Ladda, Anand
Thanks Thiruvel and Ed. Might be a dump question but how exactly do I get to to audit Hive metastore audit logs. I looked through the JIRA but there isn't a mention of the same. Also is there some variable/parameter I need to set/enable for the audit logging to be turned on -Original Messag

Re: Table Statistics In Hive

2012-04-03 Thread Nitin Pawar
I am not sure of this but just making a guess from what i have learned for getting row count i always run select count(1) from table desc extended table tells the entire table metadata information but nothing about the records inside the table On Mon, Apr 2, 2012 at 9:20 PM, Ladda, Anand wrote: