PI46988: ANALYZE FAILS IN THE HIVE PARSER WHEN CREATE A PARTITION WITH A VALUE CONTAINING ONE OR MORE SINGLE QUOTES.

APAR status

• Closed as program error.

Error description

• Hive scenario:
  create table t1 (a int) partitioned by (b string);
  insert into table t1 partition (b="p'1") values (1);
  hive> select * from t1;
  OK
  1 p'1
  This also works: select * from t1 where b="p'1"
  
  Failure:
  hive> ANALYZE TABLE t1 PARTITION(b="p'1") COMPUTE STATISTICS
  for columns a;
  NoViableAltException(313@[323:1: atomExpression : ( ( KW_NULL
  )=> KW_NULL -> TOK_NULL | ( constant )=> constant |
  castExpression | caseExpression | whenExpression | (
  functionName LPAREN )=> function | tableOrColumn | LPAREN !
  expression RPAREN !);])
  at
  org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser$DFA
  32.specialStateTransition(HiveParser_IdentifiersParser.java)
  at org.antlr.runtime.DFA.predict(DFA.java:80)
  
  This is Hive defect and RTC defect 103470 has created to track
  this issue.
  

Local fix

• Delete the partition(s) with single quote(s) in the value.
  

Problem summary

• See Error Description
  

Problem conclusion

• This problem is fixed in Version 4.1.0.0 and later fix packs.
  Also tracked in JIRA HIVE-12489
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• NA
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R410 PSY

     UP