hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yang <teddyyyy...@gmail.com>
Subject how to treat an existing partition data file as a table?
Date Sun, 29 Sep 2013 20:39:09 GMT
we have a huge table, including browsing data for the past 5 years, let's
say.

now I want to take a few samples to play around with it. so I did
select * from mytable limit 10;
but it actually went full out and tried to scan the entire table. is there
a way to kind of create a "view" pointing to only one of the data files
used by the original table mytable ?
this way the total files to be scanned is much smaller.


thanks!
yang

Mime
View raw message