apache
Issue on docs window-function
Path:/zh-CN/docs/sql-manual/sql-functions/window-functions/window-function
create table stock_ticker (stock_symbol string, closing_price decimal(8,2), closing_date timestamp);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
In the table building statement" closing_date timestamp",doris' data type does not support timestamp. May mislead users.
The test data can be used as the following examples： ” create table stock_ticker ( closing_date dateTime, stock_symbol string, closing_price decimal(10, 0) ) duplicate key(closing_date) distributed by hash(closing_date) buckets 1 properties ( "replication_num"="1" );
insert into stock_ticker values ('2014-10-02 00:00:00','JDR',12.86), ('2014-10-03 00:00:00','JDR',12.89), ('2014-10-04 00:00:00','JDR',12.94), ('2014-10-05 00:00:00','JDR',12.55), ('2014-10-06 00:00:00','JDR',14.03), ('2014-10-07 00:00:00','JDR',14.75), ('2014-10-08 00:00:00','JDR',13.98), ('2014-10-08 00:00:00','TTD',16.98), ('2014-10-06 00:00:00','TTD',13.98), ('2014-10-07 00:00:00','TTD',12.98);
select * from stock_ticker; “
