You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (JIRA)" <ji...@apache.org> on 2016/07/28 17:42:20 UTC

[jira] [Created] (NIFI-2422) SelectHiveQL processor failed to process a 'select' query

Matt Burgess created NIFI-2422:
----------------------------------

             Summary: SelectHiveQL processor failed to process a 'select' query
                 Key: NIFI-2422
                 URL: https://issues.apache.org/jira/browse/NIFI-2422
             Project: Apache NiFi
          Issue Type: Bug
    Affects Versions: 1.0.0
            Reporter: Matt Burgess
            Assignee: Matt Burgess
             Fix For: 1.0.0


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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)