Hi Pinot community, Can we copy data of one table to new table?

You can, by copying the segments across. I wrote a blog showing a small example of how to do this - https://www.markhneedham.com/blog/2021/12/06/apache-pinot-copy-segment-new-table/

@Mark Needham Can we transfer/copy data values from one column to other column of same datatype?

I don't think you can

Q2. How to replace values of mapped data, let say change all 'ROAD' values to 'TRUCK' for all values in a column?

don't think you can do that either -you'd need to re-ingest