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