#!/bin/bash
###################
result_check=`cat /home/vmax-saltagent/sample/patrol/1.txt | grep result`
tableName_check=`cat /home/vmax-saltagent/sample/patrol/1.txt | grep tableName`
#echo $result_check
#echo $tableName_check
if [ -n "$result_check" ]; then
if [ -n "$tableName_check" ]; then
echo "1"
else
echo "0"
fi
else
echo "0"
fi
###################
###################
#登陆sparksql,并将test.sql脚本执行完成后结果存入1.txt,且控制台不输出信息
#坎坷,试了好多次,每次登陆sparksql都会弹出一堆登录信息,怎么也屏蔽不掉,最后简单的加个> /home/vmax-saltagent/sample/patrol/1.txt 2>&1,就轻松的被搞定了,输出到文件里面去了。然后再从文件中去捞取。因为特殊原因,一定要屏蔽除返回值的,所有信息。
s1=`java -cp /home/vmax-saltagent/sample/patrol/spark.beeline.jar org.apache.hive.beeline.BeeLine -f /home/vmax-saltagent/sample/patrol/test.sql -u jdbc:hive2://localhost:18000/ -n mr > /home/vmax-saltagent/sample/patrol/1.txt 2>&1`result_check=`cat /home/vmax-saltagent/sample/patrol/1.txt | grep result`
tableName_check=`cat /home/vmax-saltagent/sample/patrol/1.txt | grep tableName`
#echo $result_check
#echo $tableName_check
if [ -n "$result_check" ]; then
if [ -n "$tableName_check" ]; then
echo "1"
else
echo "0"
fi
else
echo "0"
fi