Hive
東方海竹
宁可失败,不能平庸
展开
-
使用if或case when优化SQL
一、[基本查询语句展示优化]#根据type查询SELECT id,title,type FROM table WHERE type=1;SELECT id,title,type FROM table WHERE type=2;用if优化#if(expr,true,false)SELECT id,title,type,if(type=1,1,0) as type1,if(...原创 2016-03-29 21:32:12 · 2029 阅读 · 1 评论 -
Hive Quick Start
一、安装&启动brew install hivebrew install mysqlmysql.server start或者brew services start mysql (启动)brew services stop mysql (停止) mysql -u root -p CREATE DATABASE hive; use hive; create user 'hive原创 2017-05-05 17:24:19 · 796 阅读 · 0 评论