반응형
NiFI에서 ORACLE 데이터 수집할 때 정리한 내용입니다.
📁 Data Type
| ORACLE | Impala |
| CLOB | string |
| varchar | string |
| number(int) | decimal(20,0) |
| number(double) | decimal(20,3) |
| timestamp | timestamp |
| date | timestamp |
| binary_double | double |
◾ ExecuteSQLRecord
- Use Avro Logical Types: true
- Max Rows Per Flow File: 500000
- Fetch Size: 500000
◾ Impala DBCP
- Validation query: select 1
