Hello team,
My team wants to make a table which has two 3 timestamp cols and few other string cols. While we construct this table schema, when we added two timestamp cols (unixtime milli) in dimension spec, topic couldnt consume the event. Could you please give us reason why?
m
Mayank
11/30/2021, 5:10 AM
Put all 3 time stamps in the datetimefieldspec. Specify the actual time column in table config.
y
yelim yu
11/30/2021, 5:13 AM
What do you mean by “specify the actual time column in table config?” Does it mean we need to assign certain time like below?
yelim yu
11/30/2021, 5:41 AM
I’ve just tried below schema, but it doesnt work still.
m
Mark Needham
11/30/2021, 10:29 AM
can you share the error message that you're seeing?
➕ 1
m
Mayank
11/30/2021, 2:33 PM
As Mark mentioned, if you can share more details on what issue/error you run into, that would be helpful.
y
yelim yu
12/01/2021, 8:51 AM
We solved this problem by setting all datatypes in datetimefieldspec as long & adding granuality as milisec.
m
Mayank
12/01/2021, 2:46 PM
It should be able to support any granularity not just milli