You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Gardella Juan Pablo (JIRA)" <ji...@apache.org> on 2018/04/11 04:40:00 UTC

[jira] [Updated] (NIFI-5049) Fix handling of Phonenix datetime columns in QueryDatabaseTable and GenerateTableFetch

     [ https://issues.apache.org/jira/browse/NIFI-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gardella Juan Pablo updated NIFI-5049:
--------------------------------------
    Summary: Fix handling of Phonenix datetime columns in QueryDatabaseTable and GenerateTableFetch  (was: Fixhandling of Phonenix datetime columns in QueryDatabaseTable and GenerateTableFetch)

> Fix handling of Phonenix datetime columns in QueryDatabaseTable and GenerateTableFetch
> --------------------------------------------------------------------------------------
>
>                 Key: NIFI-5049
>                 URL: https://issues.apache.org/jira/browse/NIFI-5049
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Core Framework
>    Affects Versions: 1.5.0
>            Reporter: Gardella Juan Pablo
>            Assignee: Matt Burgess
>            Priority: Major
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> QueryDatabaseAdapter does not work against Phoenix DB if it should convert TIMESTAMP. The error is described below:
> [https://stackoverflow.com/questions/45989678/convert-varchar-to-timestamp-in-hbase]
> Basically, it's required to use TO_TIMESTAMP(MAX_COLUMN) to make it work. 
> See [https://lists.apache.org/thread.html/%3CCA+kiFscJE8AY+UxT_D_vSt4QgZF4jxWoVBOYnJgztt4dSbSXWQ@mail.gmail.com%3E]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)