2 Replies Latest reply on May 8, 2015 8:55 AM by kiran.pinnamaneni

Tableau Hive Communication error with Multiple data sources

kiran.pinnamaneni May 8, 2015 7:26 AM

I installed ODBC Driver and tested Hive,Tableau connection.Its working fine with a data source with one table.But if i add another data source with another table which has same column "scoring_dt" to the same workbook, tableau adds aliases to column names which is understandable but throws below exception. Can anybody help understanding what's going wrong here?

[Hortonworks][HiveODBC] (35) Error from Hive: error code: '10002' error message: 'Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 4:35 Invalid column reference 'ctr_scores.scoring_dt''.

1. Re: Tableau Hive Communication error with Multiple data sources

venkatesh.sharma May 8, 2015 8:37 AM (in response to kiran.pinnamaneni)

can u please try

Tabelau Hive Communication Error
Like Show 1 Likes(1)

Actions
2. Re: Tableau Hive Communication error with Multiple data sources

kiran.pinnamaneni May 8, 2015 8:55 AM (in response to venkatesh.sharma)

Hi Venkatesh,

I am using the 64 bit driver, Hive Server2 connection. As i mentioned, i am able to connect and generate the reports with single data source. The error occurs only when i add more data sources.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Tableau Hive Communication error with Multiple data sources

1. Re: Tableau Hive Communication error with Multiple data sources

2. Re: Tableau Hive Communication error with Multiple data sources

Actions

More Like This