Does Hive have something equivalent to DUAL?

Best solution is not to mention table name.

select 1+1;

Gives the result 2. But poor Hive need to spawn map reduce to find this!

hadoop hive amazon-emr

hadoop hive amazon-emr

To create a dual like table in hive where there is one column and one row you can do the following:

create table dual (x int);insert into table dual select count(*)+1 as x from dual;

Test an expression:

select split('3,2,1','\\,') as my_new_array from dual;

Output:

["3","2","1"]

CodeHunter