FAQ
The following query doesn't run with the error:
FAILED: Parse Error: line 3:0 mismatched input 'tablesample' expecting EOF

Am I doing something obviously wrong, or can you just not use
tablesample like this?

select * from (select user_agent, cookie, geoloc, flags from alogs_master
where ds='2010-11-26' and ch='595.00001' and flags[2]="H" and flags[1]="") t
tablesample(bucket 1 out of 100 on rand());


--Leo

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedNov 29, '10 at 12:09a
activeNov 29, '10 at 12:09a
posts1
users1
websitehive.apache.org

1 user in discussion

Leo Alekseyev: 1 post

People

Translate

site design / logo © 2021 Grokbase