Does Hive have something equivalent to DUAL?

hadoop hive amazon-emr
jbreed picture jbreed · Mar 20, 2012 · Viewed 33.4k times · Source

I'd like to run statements like

SELECT date_add('2008-12-31', 1) FROM DUAL

Does Hive (running on Amazon EMR) have something similar?

Answer

Harikrishnan Ck picture Harikrishnan Ck · Apr 24, 2015

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!

Related questions

How do you make a HIVE table out of JSON data?

I want to create a Hive table out of some JSON data (nested) and run queries on it? Is this even possible? I've gotten as far as uploading the JSON file to S3 and launching an EMR instance but I …

Read More
How do I increase Tez's container physical memory?

I've been running some hive scripts on an aws emr 4.8 cluster with hive 1.0 and tez 0.8. My configurations look like this: SET hive.exec.compress.output=true; SET mapred.output.compression.type=BLOCK; SET hive.exec.dynamic.partition = true; SET hive.…

Read More
HIVE External Table - Set Empty Strings to NULL

Currently I have a HIVE 0.7 instance on Amazon EMR. I am trying to create a duplicate of this instance on a new EMR cluster using Hive 0.11. In my 0.7 instance I have an external table that will set empty strings to …

Read More