Does Tableau support Impala's date time field? I know it doesn't for Hive, but I wasn't able to find anything specific for Impala. I'm having a heck of a time using a date time field. It gives me some input error. For some tables, turning it into an extract works, but for others, it won't even let me turn it into an extract. Should we so the same thing like with Hive, were we need to have the date/times as strings than convert them over to dates in Tableau?
Details are below:
Some, with one table, we can connect but when we place a calculate field that acts on dates, we get:
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Error: Error: could not match input
Unable to properly calculate the domain for the field 'PoP - MONTH'. Displayed data may be incorrect.
On the other hand, while we can connect, any attempt to create an extract or even to put a date column (without calculations) on the graph, we get
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1:
SELECT YEAR(date ) AS yr_date_ok , SUM(p...
^
Encountered: DATE
Expected: ALL, AVG, CASE, CAST, COUNT, DISTINCT, DISTINCTPC, DISTINCTPCSA, FALSE, GROUP_CONCAT, IF, INTERVAL, MAX, MIN, NDV, NOT, NULL, SUM, TRUE, IDENTIFIER
CAUSED BY: Exception: Syntax error
I can connect live to an Impala DT field:
Use it in a viz, playing around with date parts as I do:
...and I was able to create an extract using a datepart function as a calculation:
