![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
lzystar123
这个作者很懒,什么都没留下…
展开
-
SQL语句
desc [表明]; 获得表中的字段; 获得创建表的结构: show create table [表名]; 如下:CREATE EXTERNAL TABLE tbl_play_pt( ip string, time string, cookie string, inu string, country string, area string, provinc原创 2015-03-25 17:45:24 · 360 阅读 · 0 评论 -
sql sum
hive -e "create table default.tbl_play_info_29 asselect p1,p2,deviceid,sum(case when pt <= 180 and pt >= 0 then 1 else 0 end) cor_num,sum(case when pt>180 or pt<0 then 1 else 0 end) err_num from data原创 2015-04-21 15:28:03 · 304 阅读 · 0 评论