# I am the Watcher. I am your guide through this vast new twtiverse.
# 
# Usage:
#     https://watcher.sour.is/api/plain/users              View list of users and latest twt date.
#     https://watcher.sour.is/api/plain/twt                View all twts.
#     https://watcher.sour.is/api/plain/mentions?uri=:uri  View all mentions for uri.
#     https://watcher.sour.is/api/plain/conv/:hash         View all twts for a conversation subject.
# 
# Options:
#     uri     Filter to show a specific users twts.
#     offset  Start index for quey.
#     limit   Count of items to return (going back in time).
# 
# twt range = 1 1
# self = https://watcher.sour.is/conv/o72mgva
yue-fang-readfog
feeds.twtxt.net
View Thread
SQL 實用技巧 - 行列轉換**
在編寫大數據 SQL 的時候，有時需要進行行列的轉化什麼是行列轉化？如下圖，不同商品在不同月份的銷量數據，有時候我們希望數據和左側一樣的排列，但原始數據卻像右側一樣排列，此時我們需要把右側的列排列轉換成左側的行排列，反之亦然。下面以上面這個例子爲大家介紹一些行列轉換的方式行轉列---使用CASE WHEN適用場景：MySQL、Hive、Spark SQL把行轉換成列最簡單的方式就是使用CASE W ⌘ Read more