Hi, The following variable freq fails to resolve: bash-4.1$ export freq=MNTH bash-4.1$ echo $freq MNTH bash-4.1$ hive -e "select ${env:freq} as dr from dual" Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties Hive history file=/hadoop1/hive_querylog/sumighos/hive_job_log_sumighos_201304302321_1867815625.txt FAILED: ParseException line 1:8 cannot recognize input near 'as' 'dr' 'from' in select clause bash-4.1$
Here dual is a table with 1 row. What am I am doing wrong? When I try to resolve freq - it is empty!! $ hive -S -e "select '${env:freq}' as dr from dual" $ Thanks, Sumit