hive后台启动_在后台执行HIVE查询

how to execute a HIVE query in background when the query looks like below

Select count(1) from table1 where column1='value1';

I am trying to write it using a script like below

#!/usr/bin/ksh

exec 1> /home/koushik/Logs/`basename $0 | cut -d"." -f1 | sed 's/\.sh//g'`_$(date +"%Y%m%d_%H%M%S").log 2>&1

ST_TIME=`date +%s`

cd $HIVE_HOME/bin

./hive -e 'SELECT COUNT(1) FROM TABLE1 WHERE COLUMN1 = ''value1'';'

END_TIME=`date +%s`

TT_SECS=$(( END_TIME - ST_TIME))

TT_HRS=$(( TT_SECS / 3600 ))

TT_REM_MS=$(( TT_SECS % 3600 ))

TT_MINS=$(( TT_REM_MS / 60 ))

TT_REM_SECS=$(( TT_REM_MS % 60 ))

printf "\n"

printf "Total time taken to execute the script="$TT_HRS:$TT_MINS:$TT_REM_SECS HH:MM:SS

printf "\n"

but getting error like

FAILED: SemanticException [Error 10004]: Line 1:77 Invalid table alias or column reference 'value1'

let me know exactly where I am doing mistake.

解决方案

I am able to resolve it replacing single quote with double quote. Now the modified statement looks like

./hive -e 'SELECT COUNT(1) FROM Table1 WHERE Column1 = "Value1";'