I want to do a query based on a logic condition to query between two tables.
select * from if(A>B, tableA, tableB) But "if" function in Hive cannot work within FROM above. Any idea how?
I want to do a query based on a logic condition to query between two tables.
select * from if(A>B, tableA, tableB) But "if" function in Hive cannot work within FROM above. Any idea how?