Manual Inserting of Records

1

Hi all,

I’m having problems manually inserting a record. My DB looks like this

> select * from SPIRIT_DATA
name: SPIRIT_DATA
time                date       jardin piscina rain solar
----                ----       ------ ------- ---- -----
1671749940047611445 2022-12-22 11452  0            41.73
1671839068765799665 2022-12-24 0      0       0.00 0.00
1671839262985976404 2022-12-24 0      0       0.00 0.00

I am trying to add a record manually but it’s giving a bad timestamp error

either

> insert date=2022-12-23 jardin=6613 piscina=0 rain=0.00 solar=49.38 1671836340
ERR: {"error":"unable to parse 'date=2022-12-23 jardin=6613 piscina=0 rain=0.00 solar=49.38 1671836340': bad timestamp"}

or

> insert SPIRIT_DATA,date=2022-12-23 jardin=6613 piscina=0 rain=0.00 solar=49.38 1671836340
ERR: {"error":"unable to parse 'SPIRIT_DATA,date=2022-12-23 jardin=6613 piscina=0 rain=0.00 solar=49.38 1671836340': bad timestamp"}

Where am I going wrong please ?

2

BUMP :slight_smile: Can anyone help please ?