Hi Mugil,
Druid stores it's segment data in it's own specific columnar format for query performance reasons, that to my knowledge is currently not read directly by any other products on the market.
Druid does provide a segment dump tool that will export the data to CSV, if you need to use the data in it's raw form:
https://druid.apache.org/docs/latest/operations/dump-segment.html
But I would recommend using one of the APIs for pulling the data via simple SELECTs . I've tested pulling millions of records through both the sync and async query APIs, as well as the new MSQ Task API ... they all work fine, you just need to find the one that works best for you.