Unable to use variables with timestamps

[aretchless]

Is the issue already present in https://github.com/cloudera/hue/issues or discussed in the forum https://discourse.gethue.com?

No. I posted on gethue but did not get a response.

Describe the bug:

I’m unable to use a variable for a timestamp and would appreciate any advice. The screenshot below shows my trouble. I created a variable called ‘lineage_version’ in order to select from the ‘date_appended’ column of my table (underlined in red). This column’s type is timestamp. When I copy a value from the table (red circle in bottom right) and paste it into the variable box (red circle on left), the value gets truncated. This is not a problem with copy/paste, because the full value shows up briefly before I move the cursor out of the variable box. As a result, I get no matches when I search.

Steps to reproduce it?

See description. Unfortunately, my installation doesn't allow users to create tables.

Hue version or source? (e.g. open source 4.5, CDH 5.16, CDP 1.0...). System info (e.g. OS, Browser...).

It runs on CDP, but not sure of the version. Using Chrome web browser.

[aretchless]

Note: I found a workaround. If I cast the 'date_appended' column as STRING, then the variable works as expected.