Hi
I'm working with version v8.6.90 since the master version at this date have an Auth amplify issue.
The Fetch function on the map is buggy :
Here is the Chrome dev console output every time i change the fetch number :
App.tsx:159 [Timestream] {timestreamQuery: "SELECT↵ array_agg(measure_value::double) AS …P BY measureGroup, time↵ ORDER BY time DESC", error: ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf …}error: ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867
at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833
at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)
at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)$fault: "client"$metadata: {httpStatusCode: 400, requestId: "KCGYVRAMST5FQFVTWIADCWG7WQ", extendedRequestId: undefined, cfId: undefined, attempts: 1, …}name: "ValidationException"message: "line 4:18: Column 'source' does not exist"stack: "ValidationException: line 4:18: Column 'source' does not exist\n at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867\n at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833\n at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)\n at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)"__proto__: Objectconstructor: ƒ Error()message: ""name: "Error"toString: ƒ toString()__proto__: ObjecttimestreamQuery: "SELECT\n\t\t\t\t\t\t\tarray_agg(measure_value::double) AS objectValues,\n\t\t\t\t\t\t\tarray_agg(measure_name) AS objectKeys,\n\t\t\t\t\t\t\tarray_agg(source) AS objectSource,\n\t\t\t\t\t\t\ttime AS date\n\t\t\t\t\t\t\tFROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"\n\t\t\t\t\t\t\tWHERE deviceId='352656101085507' \n\t\t\t\t\t\t\tAND measureGroup IN (\n\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\tmeasureGroup\n\t\t\t\t\t\t\t\tFROM \"historicalDatadb40B23029-9EZu10DiXCG3\".\"historicalDatatableD9D795E1-Pdz72bsHpC5q\"\n\t\t\t\t\t\t\t\tWHERE deviceId='352656101085507' \n\t\t\t\t\t\t\t\tAND substr(measure_name, 1, 4) = 'gps.'\n\t\t\t\t\t\t\t\tGROUP BY measureGroup, time\n\t\t\t\t\t\t\t\tORDER BY time DESC\n\t\t\t\t\t\t\t\tLIMIT 14\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\tAND substr(measure_name, 1, 4) = 'gps.'\n\t\t\t\t\t\t\tGROUP BY measureGroup, time\n\t\t\t\t\t\t\tORDER BY time DESC"__proto__: Objectconstructor: ƒ Object()hasOwnProperty: ƒ hasOwnProperty()isPrototypeOf: ƒ isPrototypeOf()propertyIsEnumerable: ƒ propertyIsEnumerable()toLocaleString: ƒ toLocaleString()toString: ƒ toString()valueOf: ƒ valueOf()__defineGetter__: ƒ __defineGetter__()__defineSetter__: ƒ __defineSetter__()__lookupGetter__: ƒ __lookupGetter__()__lookupSetter__: ƒ __lookupSetter__()get __proto__: ƒ __proto__()set __proto__: ƒ __proto__()
(anonymous) @ App.tsx:159
Promise.catch (async)
query @ App.tsx:141
fetchHistory @ CatMap.tsx:70
(anonymous) @ HistoricalDataMap.tsx:32
setTimeout (async)
(anonymous) @ HistoricalDataMap.tsx:30
Ii @ react-dom.production.min.js:262
t.unstable_runWithPriority @ scheduler.production.min.js:18
$l @ react-dom.production.min.js:122
Oi @ react-dom.production.min.js:261
(anonymous) @ react-dom.production.min.js:261
D @ scheduler.production.min.js:16
k.port1.onmessage @ scheduler.production.min.js:12
23:24:16.613 ValidationException: line 4:18: Column 'source' does not exist
at https://my.cloudf ront.net/static/js/5.5f3e6fc2.chunk.js:2:493867
at https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2833
at Object.next (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:2938)
at r (https://my.cloudf ront.net/static/js/0.df04d68b.chunk.js:2:1676)
Thanks for Feedback