You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by DU DU <wi...@gmail.com> on 2015/02/09 20:22:52 UTC

Hive sample error in Hive 1.0.0

Hi folks,
I got following errors in Hive 1.0.0. However, I can run them successfully
in Hive 0.14.0.
Is this a big? Are there any workaround?

hive> SELECT name FROM employee_id_buckets TABLESAMPLE(10 PERCENT) a;
FAILED: SemanticException 1:49 Percentage sampling is not supported in
org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat. Error encountered
near token '10'

hive> SELECT name FROM employee_id_buckets TABLESAMPLE(3M) a;
FAILED: SemanticException 1:49 Total Length sampling is not supported in
org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat. Error encountered
near token '3M'

Thanks,
Will