RE: [EXTERNAL] Re: Some SimpleRecordSchema questions

2021-03-03 Thread Greene (US), Geoffrey N
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 =

Re: Count records where value match x

2021-03-03 Thread Jens M. Kofoed
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

AvroWriter - Executesql - Not retaining the datatype

2021-03-03 Thread KhajaAsmath Mohammed
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