4 ms·
I think these kinds of problems cause interviewee’s (under stress) to overthink the solution. “Load to a relational store and use sql” would be a reasonable an
by pjot 3y ago
I think these kinds of problems cause interviewee’s (under stress) to overthink the solution.
“Load to a relational store and use sql” would be a reasonable answer that, I’m sure, would be acceptable in most cases.
- gpderetta 3y agoIt would if I was the interviewer. But expect that the followup question would be how the SQL engine implements the query.
- AndyNemmity 3y agoHow isn't remotely relevant to being able to accomplish the task. I only know how certain SQL engines implement queries because I was tasked at that point to increase the speed of the queries, and went deep into the debugging level detail to understand the exact cost of each action. But I haven't done that in 7 years, and couldn't tell you much more than the tools used to figure it out. I cannot remotely understand the requirements people make up for our jobs that have nothing to do with doing our jobs.