Hi all, is there a possibility in pinot to create ...
# general
p
Hi all, is there a possibility in pinot to create a table from another table with some schema changes and import partial data to the newer one ?
m
Not at the moment. What's your use case?
p
We wanted to tie our client end queries based on user inputted fields during the data prep stage to pinot.
If there are any changes to the presto query, then modify the pinot table
m
Since Pinot is columnar, what's the issue with having a single table?
Or do you need the new table to have modified columns (as in transformations applied)?
p
Yes, new table could be anything, the schema be derived and transformation done in a previous layer based on user input
m
I see. At this point there isn't a way to do so. But you could file an issue, so we can track.
p
Sure thanks will file tomorrow
m
If you want to do it yourself, we can discuss if a minion task can be used.
p
Oh yes, I'm pretty much still thinking about the usecase. Once I've the definition clear I'll come back to it
m
Great, let us know when you are ready