Impala get current time

Question

Hi. I am new to impala and I want to create a timestamp for a query. How can I get the current time and data using Impala?

Answer 1

You can get the current time using the below query:

select now()

The output will be something like this:

+-------------------------------+
| now()                         |
+-------------------------------+
| 2019-06-06 16:44:00.429109000 |
+-------------------------------+