Dan Hill

08/13/2020, 3:38 AM
Does Pinot have a way to create an alias to a specific table? I'm thinking about the situation where I want to make a large change to a table and I'll need to recreate it. Can I use an alias and do the swap inside Pinot? Or would I want a layer outside of Pinot to convert this alias table name to a specific Pinot table?


08/13/2020, 3:39 AM
We don't have table level alias'ing in Pinot.
👍 1
One advantage of doing this outside of Pinot is that you can control how you move your traffic from old to new table (say A/B testing).

Dan Hill

08/13/2020, 3:41 AM
That makes sense.

Kishore G

08/13/2020, 3:51 AM
Btw, we do have plans for aliasing and supporting derived/virtual fields. There is an issue for that
Please add this requirement and upvote
Ah sorry, I read it as alias column
Table alias is something we were thinking in a different context. It added more complexity and we did not pursue
Agree with what Mayank said. for now, that’s the best solution