I solved the problem.
Actually the user which you use to connect tableau to Hive is not hue but hdfs. so when choosing the user name you should use hdfs and not hue.
Even with hdfs it is showing same error plz help... very urgent
Has anyone found a resolution to this. From the posts above, using the hdfs user does not solve the issue...