you can write data into filesystem from query using "INSERT OVERWRITE
[LOCAL] DIRECTORY directory1 SELECT ... FROM ..."
more detail:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Writingdataintofilesystemfromqueries
2013/5/24 Sai Sai
> I have created an
I have created an external table called states under a database called test,
Then loaded the table successfully;
The i have tried:
Select * from states;
It successfully executes MR and displays the results in the console but
wondering where to look in hdfs to see these results.
I have looked un
