hive 常用sql

show tables;

describe accesslog;

show partitions accesslog;

select count(1) from accesslog where dt='2017-05-26' and buildOriginalURL like "%getWechatQr.json%";