Re: 回复: hive 0.11 auto convert join bug report

2013-09-12 Thread Amit Sharma
Hi Navis, I was trying to look at this email thread as well as the jira to understand the scope of this issue. Does this get triggered only in cases of using aliases which end up mapping to the same value upon hashing? Or can this be triggered under other conditions as well? What if the aliases ar

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: Question on bucketed map join

2012-03-26 Thread Amit Sharma
Hi Bejoy, I am joining two tables which are both bucketed 64 ways and i want to do a bucketed map join on them. I set the flag set hive.optimize.bucketmapjoin = true;. The auto.convert.join is always false on our cluster. When i run the following query: select /*+ MAPJOIN(b) */ a.visitor_id FROM

Re: Hive Security

2012-01-31 Thread Amit Sharma
Toad uses JDBC only while connecting as a direct Hive Connection from Eclipse. In most other cases where a Hub is involved it uses Thrift. On the other hand in the current release of Toad for Cloud there is no way to specify what hive user you want to connect as and hence it always connects as the

Re: Hive Custom UDF - "hive.aux.jars.path" not working

2011-08-26 Thread Amit Sharma
/{URJARNAME}.jar* > > > > > > > > > > > > ** ** > > > > > > U r using CLI mode so after changing the value if u start > > shell that is > > > ok...and in another mode also we can start hive that is > > hiveserver

Re: Hive Custom UDF - "hive.aux.jars.path" not working

2011-08-23 Thread Amit Sharma
ve server > > ** ** > > Thanks, > > Chinna Rao Lalam > -- > > *From:* Amit Sharma [mailto:amitsharma1...@gmail.com] > *Sent:* Tuesday, August 23, 2011 3:35 AM > > *To:* user@hive.apache.org > *Subject:* Re: Hive Custom UDF - "hiv

Re: Hive Custom UDF - "hive.aux.jars.path" not working

2011-08-22 Thread Amit Sharma
, Aggarwal, Vaibhav wrote: > Did you restart the hive server after modifying the hive-site.xml settings? > > > I think you need to restart the server to pick up the latest settings in > the config file. > > ** ** > > Thanks > > Vaibhav > > ** ** >

Hive Custom UDF - "hive.aux.jars.path" not working

2011-08-22 Thread Amit Sharma
Hi, I build custom UDFS for hive and they seem to work fine when i explicitly register the jars using the "add jar " command or put in in the environment variable "HIVE_AUX_JARS_PATH". But if i add it as a configuration variable in the hive-site.xml file and try to register the function using "cr