Hi team, can you help me understand why there is a...
# troubleshooting
g
Hi team, can you help me understand why there is a difference between Use Multi-Stage Engine and not using it, i have a 1 table with numOfDocs (350m) and totalDocs(1b - due to unnesting collections). When i query without multi-engine i get smaller number of segments processed than with multi-engine. There is only 1 realtime-table that has 1224(100 of which are consuming) segments, no retention period. What could be the reason for such differences?
m
Select * has a limit of 10 in single stage engine, you can add a larger limit
g
i thought the limit of 10 is always applied
Also in regards to column names, is it ok for them to have dots (.)? Asking because when using Multi-Stake i should add " to all names and for a non multi-stake it just doesn't work
i thought it might be better to rename the columns to snake case and remove the . as well