Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> non map-reduce for simple queries


Copy link to this message
-
Re: non map-reduce for simple queries
It supports table sampling also.

select * from src TABLESAMPLE (BUCKET 1 OUT OF 40 ON key);
select * from src TABLESAMPLE (0.25 PERCENT);

But there is no sampling option specifying number of bytes. This can be
done in another issue.

2012/7/31 Owen O'Malley <[EMAIL PROTECTED]>

> On Sat, Jul 28, 2012 at 6:17 PM, Navis류승우 <[EMAIL PROTECTED]> wrote:
>
> > I was thinking of timeout for fetching, 2000msec for example. How about
> > that?
> >
>
> Instead of time, which requires launching the query and letting it timeout,
> how about determining the number of bytes that would need to be fetched to
> the local box? Limiting it to 100 or 200 mb seems reasonable.
>
> -- Owen
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB