I am trying to sample data in a Hive table via Hue in the Quickstart VM using the Block Sampling method. The query generates a parse exception when I use the row count basis but succeeds when the percentage basis is used. The Hive language manual indicates both methods are supported and, indeed, they both work when I try the queries in the Hortonworks sandbox VM.
Any assistance you could give would be much appreciated. Thanks in advance.
The queries I am using are:
select * from default.sample_07 tablesample(0.1 percent)
select * from default.sample_07 tablesample(50 rows)
OK FAILED: ParseException line 1:48 mismatched input 'rows' expecting KW_PERCENT near '50' in table split sample specification