Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

nvl and coalesce function not working, if the replacement value is a inner query, is there any way?

nvl and coalesce function not working, if the replacement value is a inner query, is there any way?

Explorer

Hi,

The below query gives error, could anybody throw some idea how to do it?

 

select NVL(T.VALUE,(SELECT COL_VALUE FROM MASTER_TABLE WHERE NAME= 'DEFAULT_VALUE') ) from TABLE2 T ;

 

Getting below error.

Error while compiling statement: FAILED: ParseException line 1:30 cannot recognize input near 'SELECT' 

 

Regaards,

Mano

 

 

 

2 REPLIES 2

Re: nvl and coalesce function not working, if the replacement value is a inner query, is there any w

Explorer

I dont think Cloudera community ever gives any reply :-(

Re: nvl and coalesce function not working, if the replacement value is a inner query, is there any w

Community Manager

Hey @Mano. I understand the frustration of waiting for an answer. Please keep in mind that this is a peer to peer forum at this time. Clouderans do reply when time allows but it is not their primary function. I'd be happy to discuss your experience further via private message if you would like. 



Cy Jervis, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum