Re: hive sql tune

2014-12-29 Thread Stéphane Verlet
n I ask you that which compression codec do you use? > > > *发件人:* 老赵 > *发送时间:* 2014-12-08 13:12 > *收件人:* user > *主题:* hive sql tune > > Hello, > > I am working for a Telecommunicaton Service Provider Company,So I can > access the view logs of different users from a

回复: hive sql tune

2014-12-07 Thread david1990...@163.com
You metioned that 'The dataformat in src_click is org.apache.hadoop.mapred.TextInputFormat and has been compressed .' Can I ask you that which compression codec do you use? 发件人: 老赵 发送时间: 2014-12-08 13:12 收件人: user 主题: hive sql tune Hello, I am working for a Telecommunicaton Servic

hive sql tune

2014-12-07 Thread 老赵
Hello,I am working for a Telecommunicaton Service Provider Company,So I can access the view logs of different users from a specific area.Now I want to query the top 1000 PV sites.I wrote a UDF named : parse_top_domain to get the top domain of a host,like www1.google.com.hk -> google.com.hkand i