How can we test expressions in hive

In late Hive, you can directly write query without "from table", such as 1. select 1 2. select UNIX_TIMESTAMP()

If you need to apply your function on some data, you can create a dual table using create table as select value.

You can try the query here http://demo.gethue.com/