I am getting the following error message when I try to refresh my datasource in Tableau. I have gotten this error when I try to refresh in an existing workbook and when I try to connect in a new workbook.
Has anyone seen this error before?
An error occurred while communicating with the Other Databases (JDBC) data source 'ShowData'
Bad Connection: Tableau could not connect to the data source.
Error Code: B19090E0
[Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 10002,
SQL state: TStatus(statusCode:ERROR_STATUS,
infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement:
FAILED: SemanticException [Error 10002]: Line 1:20
Invalid column reference 'tableausql.fieldname':38:37, org.apache.hive.service.cli.operation.Operation
:toSQLException:Operation.java:335, org.apache.hive.service.cli.operation.SQLOperation:prepare:
SQLOperation.java:199, org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:260,
org.apache.hive.service.cli.operation.Operation:run:Operation.java:247,
org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:541,
org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:527,
org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:312,
org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:Thrif