[ 
https://issues.apache.org/jira/browse/NIFI-2422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15399392#comment-15399392
 ] 

ASF GitHub Bot commented on NIFI-2422:
--------------------------------------

GitHub user mattyb149 opened a pull request:

    https://github.com/apache/nifi/pull/744

    NIFI-2422: Fix SelectHiveQL handling of Number types

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/mattyb149/nifi NIFI-2422

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/nifi/pull/744.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #744
    
----
commit 4ca6e3e173d262fbaa2aec360d1330296cf04a49
Author: Matt Burgess <mattyb...@apache.org>
Date:   2016-07-29T14:07:04Z

    NIFI-2422: Fix SelectHiveQL handling of Number types

----


> 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)

Reply via email to