1.

Is There A Dual Table?

Answer»

You might be used to running queries against a single-row table named DUAL to try out EXPRESSIONS, built-in functions, and UDFS. IMPALA does not have a DUAL table. To achieve the same result, you can ISSUE a SELECTstatement without any table name:

select 2+2;
select substr('hello',2,1);
select POW(10,6);

You might be used to running queries against a single-row table named DUAL to try out expressions, built-in functions, and UDFs. Impala does not have a DUAL table. To achieve the same result, you can issue a SELECTstatement without any table name:

select 2+2;
select substr('hello',2,1);
select pow(10,6);


Discussion

No Comment Found

Related InterviewSolutions