HAWQ

MASTER

获取LOG位置

ps -ef | grep masterdd | grep -v grep | awk '{print $(NF-6)"/pg_log"}'

LOG关键字

cat xxx.csv | awk -F ',' '{print $17}' | sort -rn | uniq

"WARNING"
"LOG"
"ERROR"
"FATAL"
"PANIC"
 errCode
 ...

如何阅读

## 获取除了LOG外的其他信息的方向
grep -v LOG xxx.csv | grep "^$(date +%F)" | awk -F ',' '{print $4"^"$5 "^"$6"^"$10"^"$17"^"$19"^"$NF}' | sort -rn |uniq

## 获取详细信息
grep -v LOG xxx.csv | less

SEGMENT

获取LOG位置

ps -ef | grep segmentdd | grep -v grep | awk '{print $(NF-6)"/pg_log"}' 

LOG关键字

cat xxx.csv | awk -F ',' '{print $17}' | sort -rn | uniq

"WARNING"
"LOG"
"ERROR"
"FATAL"
"PANIC"
 errCode
 "Stack trace"
 ...

如何阅读

## 获取除了LOG外的其他信息的方向
grep -v LOG xxx.csv | grep "^$(date +%F)" | awk -F ',' '{print $4"^"$5 "^"$6"^"$10"^"$17"^"$19"^"$NF}' | sort -rn |uniq

## 获取详细信息
grep -v LOG xxx.csv | less