I have put my first UDTF on GitHub - https://github.com/ope-nz/iotDBExtras
The first function I have developed is called UDTFDistinctCount. It returns the distinct values (similar to IoTDB-Quality UDTFDistinct) but it includes the count of each distinct values (as the time column). Example query; IoTDB> select distinct_count(temperature) from root.ln.wf01.wt01 +-----------------------------+---------------------------------------------+ | Time|distinct_count(root.ln.wf01.wt01.temperature)| +-----------------------------+---------------------------------------------+ |1970-01-01T12:00:00.020+12:00| 24.37| |1970-01-01T12:00:00.009+12:00| 24.12| |1970-01-01T12:00:00.016+12:00| 24.87| +-----------------------------+---------------------------------------------+ Or as digital time; +----+---------------------------------------------+ |Time|distinct_count(root.ln.wf01.wt01.temperature)| +----+---------------------------------------------+ | 20| 24.37| | 9| 24.12| | 16| 24.87| +----+---------------------------------------------+ Thanks Trevor Hart Ope Limited w: http://www.ope.nz/ m: +64212728039
