hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonal Goyal <>
Subject Re: how to treat an existing partition data file as a table?
Date Mon, 30 Sep 2013 00:07:42 GMT
Is your table partitioned ?

Sent from my iPad

On Sep 30, 2013, at 2:09 AM, Yang <> wrote:

> 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

View raw message