[NIFI-2422] SelectHiveQL processor failed to process a 'select' query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.0.0, 1.0.0-Beta
• Assignee: Matt Burgess
• Reporter: Matt Burgess
• Created: 28/Jul/16 17:41
• Updated: 04/Aug/16 21:24
• Resolved: 29/Jul/16 19:39

Description

The following query configured in SelectHiveQL processor will generate ERRORs shown in the attached screenshot:
SELECT * FROM hiveql_test_table WHERE nifinode="node1"
However, I can run the above query successfully if I connect to the hive server directly.
The hive table schema is as follows:
0: jdbc:hive2://localhost:10000/hiveql_test_d> desc hiveql_test_table;
--------------------------------+

col_name

data_type

comment

--------------------------------+

id	int
nifinode	string
tvarchar	varchar(100)
tchar	char(50)
tboolean	boolean
tint	int
tfloat	float
tdouble	double
tdate	date

--------------------------------+
9 rows selected (0.416 seconds)

Issue Links

• links to: GitHub Pull Request #744