Hi Wei,
Have you searched JIRA for issues that relate to the Phoenix-Hive
integration? There have been a few in the recent past around invalid
queries being generated, especially around column names.
On 4/14/18 7:39 PM, Lu Wei wrote:
## Version:
phoenix: 4.13.2-cdh5.11.2
hive:
## Version:
phoenix: 4.13.2-cdh5.11.2
hive: 1.1.0-cdh5.11.2
There is an ColumnNotFoundException when joining a hive internal table with an
Phoenix external table.
## Table1: phoenix external table "ext_tmp":
+---+++--+
| col_name | data_type |