Hi @xyz_chatter ,
After having conversation with internal team, as a workaround Product team suggested to give a try with ODBC connector with Hive driver and see if that helps.
I would also recommend you to please share your feedback/suggestion in ADF user voice forum: https://feedback.azure.com/forums/270578-azure-data-factory
All the feedback shared in this forum are actively monitored and reviewed by ADF engineering team. Also please do share the feedback link here once it is posted, as it would help other users to upvote and/or comment on the idea which would help to increase the feature request implementation.
Hope this helps.
----------
Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.