Could not able to fetch data in datasource in Tableau Desktop,Throws below error

Question

How can I complete the action [Hortonworks][HiveODBC] (80) , it is throwing a syntax error

Error message from server: Error while compiling statement: FAILED: SemanticException Line 0:-1 Argument type mismatch 'TOK_NULL': 

Error Code: 9F80FB23 

 

Answer 1

check the query

The expression after ELSE should have the same type as those after THEN: "date" is expected but "timestamp" is found

For more information check the tableau training