[PHOENIX-4436] Hive PhoenixStorageHandler doesn't work well with quoted namespace/table name.

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.13.0, 4.14.0
• Labels: HivePhoenix
• Assignee: Sergey Soldatov
• Reporter: Sergey Soldatov
• Created: 05/Dec/17 09:13
• Updated: 05/Dec/17 11:42

Description

With quoted schema name the table will be created, but not usable with an exception about '\' character. The reason is that job properties in Hive are stored using escaped java strings. So to correctly handle it we need to unescape.
For quoted name the table creation would fail because we are using table name in PK name prefixed by 'pk_'. So the PK name comes incorrect like 'pk_"table_name"'. I think that there is no reason to generate constraint pk name and we may use the constant.

Issue Links

• is duplicated by: PHOENIX-4420 org.apache.hive.service.cli.HiveSQLException: java.io.IOException: java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Unexpected char: '\'