Thank you so much for your quick response.
I tried to use hdfs username and I was able to connect to the datasource, but I am getting error when I am trying to pull the column in the report.
Please let me know for any other inputs.
Has anyone found a resolution to this? I am facing the same issue when using a Live connection to Hortonworks Hive. Extracts work ok.
Idon't have a solution for this issue, but this Does not occur in tableau 9.3.
Windows 7 (64 bits)
Driver ODBC (HortonworksHiveODBC64) you can download in this link http://public-repo-1.hortonworks.com/HDP/hive-odbc/22.214.171.1241/windows/HortonworksHiveODBC64.msi
Sindhu Srinivas Not sure if you already found a resolution or not, but here is this thing which worked for me.
To recap,I noticed that I was using my login credentials as "A123****" and Tableau was establishing the connection and showing the data preview but threw 'ExecuteStatement finished with operation state: ERROR_STATE' error upon pulling the data.
I changed my login credentials to lowercase "a123***" and to my delight there was no ERROR_STATE error any more.
Upon further investigation I learned that this problem was related to Hadoop's Map Reduce Job execution requirement. To put it simply, the MR jobs needs a user directory (with exact case sensitive name) to store temp files which are generated as part of the execution process. So when we just preview the data, no such job kicks in and HIVE does not look for temp storage in the user directory but when we pull the data for dash-boarding / reporting purpose that is when HIVE actively seeks a exact math user name and throws the ERROR_STATE error if it fails to find one.
Hope this helps rest of the user base.