That works hive -e " select * from  hiveDB.cardinal001"
that works hive -e "use hiveDB; select col1, col2  from (select * from cardinal001 where col2 > 500 order by col1 ) cardinal001;"
that doesn't work hive -e "select col1, col2  from (select * from hiveDB.cardinal001 where col2 > 500 order by col1 ) hiveDB.cardinal001;"
FAILED: ParseException line 1:97 missing EOF at '.' near 'hiveDB'