Title
#users-public
s

Sam Shiles

10/24/2022, 10:59 AM
Works:
CREATE TABLE 'reading' (
  deviceId STRING,
  readingTypeId SYMBOL,
  value FLOAT,
  readingDate TIMESTAMP
);
Does not work:
CREATE TABLE 'reading' (
  deviceId STRING,
  readingTypeId SYMBOL,
  value FLOAT,
  readingDate TIMESTAMP
) timestamp (readingDate) PARTITION BY DAY;
This worked fine on questdb 6.4.2 Let me know if I'm doing something wrong or whether I should raise a github issue