All functionality can be executed directly with the SQLInterprator. No driver program is required.
- Create table with timeseries datatype:
create table name(id int, t timeseries); - Insert Data:
insert into name(t) values(20);where the timeseries data value is an integer. - Selecting Data:
select id,t from name;, - Selecting Date while using Predicates:
select id,t from name where t=20ORselect id,t from name where t='2023-03-02-20' - Aggregate Functions:
select sum(t) from namealso works with predicates likeselect sum(t) from name where t=20orselect sum(t) from name where t='2023-03-02-20'but will not work while selecting multiple fields ie:select id,sum(t) from name
Lexer.javaParser.javaSQLInterpretor.javaTableScan.javaBuffer.javaScan.javaRecordFile.javaRecordPage.javaTerm.javaTransaction.javaPage.javaTimeseriesConstant.javaRemoteMetaDataImpl.javaRemoteResultSetImpl.java
We collaborated equally on most tasks, with each team member contributing to various aspects of the project. Specifically, Lucas took the lead in implementing the querying and Aggregate Scan. On the other hand, Jacob played a crucial role in researching the correct implementation when using a Time Reference System.
The remaining programming aspects of the project were addressed together through pair programming sessions. We organized a few meetings to tackle the necessary steps for implementing the working datatype.
Occasionally when creating a table with multiple datatypes and a timeseries datatype where the field name is larger than 4, the table behaviours becomes unpredictable. The values get inserted correctly, but then get lost when attempting to retreive them. See image for details.
Notice that the id value '1' is not getting retreived properly.