Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-5049

Fix handling of Phonenix datetime columns in QueryDatabaseTable and GenerateTableFetch

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.0
    • Fix Version/s: 1.7.0
    • Component/s: Core Framework
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                gardellajuanpablo Gardella Juan Pablo
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 24h
                  24h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified