Hi,
I have an issue with oracle driver where the executesql processor is
converting all the datatypes to String. AvroWriter used internally by
executesql is writing all the fields as string type.
I want to limit the timestamp field from oracle to 23 characters.
2021-02-02 09:01:24.847756 to 2021
I figured it out. The issue was that I had an array of records. I couldn't
figure out the calls.
For posterity,
SimpleRecordSchema oneSchema = new SimpleRecordSchema(fieldList)
DataType oneValueType = RecordFieldType.RECORD.getRecordData(oneSchema)
DataType allValues = RecordFieldType.ARRAY.ge
Hi Mark
Thanks for pointing me in the direction of where clauses inside a count. I
found this which is working.
select count(case when queuedCountProcent > 50 then 1 else null end) as
count_queuedCountProcent,
count(case when queuedBytesProcent > 50 then 1 else null end) as
count_queuedB