[NiFi] ORACLE, Impala Data Type 비교

 

---

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