Example of PostgreSQL VALUES() functionality in Cloudera Impala. Examples: https://issues.cloudera.org/browse/IMPALA-68 http://www.postgresql.org/docs/9.2/static/sql-values.html

values.sql

[impala1:21000] > 
select * 
from (values ('2013-06-01' as col1),
             ('2013-06-02'),
             ('2013-06-02'),
             ('2013-06-03'),
             ('2013-06-04'),
             ('2013-06-05')
      ) x;

Query finished, fetching results ...
+------------+
| col1       |
+------------+
| 2013-06-01 |
| 2013-06-02 |
| 2013-06-02 |
| 2013-06-03 |
| 2013-06-04 |
| 2013-06-05 |
+------------+
Returned 6 row(s) in 0.18s