how to generate plan file in hive test?

Hi all, How can generate plan files like those .q.xml files exist in ql/src/test/results/compiler/plan/** for checking my plan? Thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderpla

Re: inefficient execution plan in this case

Hi, I feel sorry leading you two focused on join stuffs, but ineffectives on union queries like below is the very hot spot I cared instead. create table tmp( type string, other_cols' definition) insert overwrite table tmp select * from( select 'class_a', other_cols from tbl whe

Re: Built - In Aggregate Function - Standard Deviation

Good catch. I just added that to wiki. Thanks Amr. Zheng On Sun, May 31, 2009 at 12:04 AM, Amr Awadallah wrote: > Zheng, > > is SQRT an undocumented builtin UDF? I couldn't see it in the lang manual > at: > > http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF > > hence why I did pow(x,0.

Re: Built - In Aggregate Function - Standard Deviation

Zheng, is SQRT an undocumented builtin UDF? I couldn't see it in the lang manual at: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF hence why I did pow(x,0.5) instead -- amr Hive does not support that right now, but Hive supports subquery so we can do: SELECT SQRT( (n*totalsqr - t