mysql - basic sql query problems in hive for using hadoop -

guys facing problem basic command of sql. working on hadoop , hive software learning big data analysis. create table on hadoop file system name of cencus. open hive on terminal , performing simple sql query on , saving on external excel .csv file

hive -e 'select * cencus' > '/home/training/hackathon/out.csv 

it works fine , store table information external file

hive -e 'select * sencus education=children' > /home/training/hackathon/out.csv 

it’s not working show exception there no reduce operator tried lot of time change query to:

hive -e 'select * sencus education=''children'' > /home/training/hackathon/out.csv hive -e 'select * sencus education="children"' > /home/training/hackathon/out.csv 

but nothing working please suggest me need do?

i believe following query work.

hive -e 'select * sencus education="children";' > /home/training/hackathon/out.csv