What about first create new connection for Hive DB and set the field names in the Hive DB as same as CSV field names and then replace the connection (CSV --> to Hive) and check. Hope this helps.
But that's what a manual process. We have few CSV's with field count over 350. Manually changing all these is time constraint job.
I'm more looking what other community users are solving this issue. Or they develop their workbooks all in lowercase field captions only.
That's a normal thing. You need maintain same column names in order to make it work. You can also try the option given in the below link.
Hope this helps.
1 of 1 people found this helpful
Connect you hive table in tableau and from data menu tab convert it to Custom SQL. Now edit the Custom SQL and aliases the fields as per your requirement. This is what I've used previously and it solved the case sensitive problem. Give a try and let us know if this help.
Thanks Mahfooj. Even I was thinking the same way.