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 ... View more

I am getting the following error message when running a refresh. Do I have an invalid date field causing the issue?   Unable to complete action Not all extracts were refreshed An error occurred while refreshing outputtable [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 40000, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:7 cannot recognize input near '{' 'fn' 'TIMESTAMPADD' in select clause: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:ThriftCLIServi ... View more