You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by ch huang <ju...@gmail.com> on 2013/08/22 05:22:52 UTC

high gc time ,how do tuning?

hive> select page_url,concat_ws('&',
map_keys(UNION_MAP(MAP(first_category,'fcategory')))) as fcategorys ,
token,concat_ws('&',
map_keys(UNION_MAP(MAP(concat(original_category,',',weight),'dummy')))) as
r from media_visit_info group by page_url,token ;

# jstat -gcutil 28409 1000 10
  S0     S1     E      O      P     YGC     YGCT    FGC    FGCT     GCT
  0.00  91.67  72.40  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  72.67  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  72.67  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  73.43  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  73.92  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  74.19  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  74.19  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  74.19  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  74.21  60.62  98.19  48589   79.347    35   12.113   91.459
  0.00  91.67  74.85  60.62  98.19  48589   79.347    35   12.113   91.459
and hive-env.sh