Hi Mark,
We mostly do insert overwrite into local directory, and at that location
multiple files with output of that query are created and we use these files
our analysis. So, we want these files to be tab separated.
Limiting the number of records means limiting the length of a file, not
limiting
Chunky,
There may be another way to do this but to get tab separated output, I
usually create an external table that's tab separated and insert
overwrite into that table.
For limiting the number of records in the output, you can use the
limit clause in your query.
Mark
On Tue, Feb 19, 2013 at 10
