Re: weird alter table commands running on hive metastore

2014-12-07 Thread Viral Bajaria
Just so that this helps someone else... I found that the issue is with metastore running on a MariaDB 10.0 with TokuDB engine 7.1 TokuDB does not support foreign keys, it allows the execution of the ALTER TABLE statements, rebuilds the table for some reason but the foreign key constraint is not ap

回复: 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 Service Provider Comp

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