you can write data into filesystem from query using "INSERT OVERWRITE
[LOCAL] DIRECTORY directory1 SELECT ... FROM ..."
2013/5/24 Sai Sai <[EMAIL PROTECTED]>
> I have created an external table called states under a database called
> 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 under all the dirs in filesystem for the below url but
> cannot see the results part file.
> Also if i would like the results to save to a specific file from a query
> how to do it?
> For Ex:
> Select * from states > myStates.txt ;
> Is there something like this.
blog: http:amutu.com/blog <http://amutu.com/blog>