ConradWen commented on issue #2006:
URL: https://github.com/apache/doris-website/issues/2006#issuecomment-2645784516
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;
“
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
