Hadoop/Impala In-DB tool syntax for today's date

[Adam_Dooley]

I'm using an In-DB tool to connect to an Impala/Hadoop database.  On my Connect In-DB tool what is the syntax for today's date?  I can't get now() and unix_timestamp to work.

Thanks

[tcroberts]

Does 'current_timestamp()' work? What sort of error are you getting when using now() or unix_timestamp()?

[Adam_Dooley]

Current_timestamp() doesn't work either.  Actually it doesn't give an error, it just doesn't output any data to a Browse In-DB tool.  The only way I can get it to work is by keying in the date manually in format YYYY-MM-DD

[Adam_Dooley · Accepted solution]

Someone at my company helped me figure this out. 

The solution was:

 = to_date(from_unixtime(unix_timestamp()))

[tcroberts]

Wow, good to know. Any ideas why you need to do that to get it to show?

[Adam_Dooley]

I think it was because the field in Hadoop was formatted as a date (without any time details).  So the now() and unix_timestamp trials were too specific and running on the exact second the workflow was run.  So it was good SQL but didn't spit out any results, but the to_date piece made it possible.

[tcroberts]

Makes a lot of sense, thanks for sharing!