[GitHub] [incubator-doris] wangqiuhao0912 commented on pull request #7459: add iot-function to doris

[GitBox <gi...@apache.org>]

wangqiuhao0912 commented on pull request #7459:
URL: https://github.com/apache/incubator-doris/pull/7459#issuecomment-1000087551


   > Hi @wangqiuhao0912 ， could you give an example of this function's usage?
   
   
   Hi @morningman ,this is create table sql  and usage:
   
   create table equipment_no_par(equipment varchar(32),
   ts bigint,
   code1 double)
   UNIQUE KEY(`equipment`,`ts`)
   DISTRIBUTED BY HASH(equipment) buckets 1;
   
   select equipment,udaf_iot_first(ts,code1) from equipment_no_par group by equipment;
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org