2015年7月20日
MySQL行列转换拼接
摘要： mysql> select TBL_ID,CREATE_TIME,LAST_ACCESS_TIME,TBL_NAME,TBL_TYPE from TBLS; +--------+-------------+------------------+----------------------+---------------+ | TBL_ID | CREATE_TIME | LAST_ACCESS_... 阅读全文
posted @ 2015-07-20 23:52 智能先行者 阅读(1445) 评论(0) 推荐(0)
MySQL字符串连接
摘要： mysql> select concat('Hadoop:','Hive:','Spark#','HBase;',TBL_TYPE,'{}',SD_ID) from TBLS; | Hadoop:Hive:Spark#HBase;MANAGED_TABLE{}6 | | Hadoop:Hive:Sp 阅读全文
posted @ 2015-07-20 23:37 智能先行者 阅读(499) 评论(0) 推荐(0)
Hive桶列BucketedTables
摘要： The CLUSTERED BY and SORTED BY creation commands do not affect how data is inserted into a table – only how it is read. This means that users must be ... 阅读全文
posted @ 2015-07-20 22:54 智能先行者 阅读(783) 评论(0) 推荐(0)