[HIVE-13312] TABLESAMPLE with PERCENT throws FAILED: SemanticException 1:68 Percentage sampling is not supported in org.apache.hadoop.hive.ql.io.HiveInputFormat. Error encountered near token '20'

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.2.1
• Component/s: CLI
• Assignee: Unassigned
• Reporter: Artem Ervits
• Created: 18/Mar/16 19:56
• Updated: 18/May/16 12:13

Description

FAILED: SemanticException 1:68 Percentage sampling is not supported in org.apache.hadoop.hive.ql.io.HiveInputFormat. Error encountered near token '20'
when I execute

SELECT * FROM tablename TABLESAMPLE(20 percent);

tried with ORC and TEXT tables. Confirmed with Gopal, a temporary workaround is

set hive.tez.input.format=${hive.input.format};