Hello team, My team wants to make a table which ha...
# troubleshooting
y
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
Put all 3 time stamps in the datetimefieldspec. Specify the actual time column in table config.
y
What do you mean by “specify the actual time column in table config?” Does it mean we need to assign certain time like below?
I’ve just tried below schema, but it doesnt work still.
m
can you share the error message that you're seeing?
➕ 1
m
As Mark mentioned, if you can share more details on what issue/error you run into, that would be helpful.
y
We solved this problem by setting all datatypes in datetimefieldspec as long & adding granuality as milisec.
m
It should be able to support any granularity not just milli
👍 1