Incremetal Mode JDBC Query Question for Oracle DB

asked 2019-10-10 21:04:07 -0500

Youngjun John Seok gravatar image

updated 2019-10-10 21:14:14 -0500

  1. What I want is get data from Oracle DB to Hadoop FS using JDBC Query Consumer with incremental mode.

  2. Offset Data Explain

    • Type: DATE
    • NLS_DATE_FORMAT: RR/MM/DD
    • Column name: INS_DATE(below query)
    • Can't change NLS_DATE_FORMAT
  3. My Access

    • Query: SELECT * FROM Oracle DB WHERE (TO_TIMESTAMP(TO_CHAR(INS_DATE, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') > TO_TIMESTAMP('${OFFSET}', 'YYYY-MM-DD HH24:MI:SS')) ORDER BY INS_DATE ASC
    • Type Convert: DATE -> CHAR -> TIMESTAMP
    • Offset: 2017-01-01 00:00:00
  4. Problem

    • Validation & Preview is okay
    • But when running this query, error code is: First error: SQLState: 22008 Error Code: 1830 Message: ORA-01830
  5. Question

    • Way to solve above ploblem..
    • or Is any Oracle license or environment needed to use incremental mode from Oracle DB?
edit retag flag offensive close merge delete