#3 vc query now working for hive