How to pass multiple parameter in hive script

Question

employee: Table data

I want to fetch records of year=2016 by running hive script sample.hql.

use octdb;
select * from '${hiveconf:table}' where year = '${hiveconf:year}';

[cloudera@quickstart ~]$ hive -hiveconf table='employee', year=2016 -f sample.hql

But i am getting error NoViableAltException(307@[]).......

Answer 1

You need to use the --hiveconf option twice:

hive --hiveconf table=employee --hiveconf year=2016 -f sample.hql