Reply
Explorer
Posts: 7
Registered: ‎12-06-2017

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

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

 

 

 

Explorer
Posts: 7
Registered: ‎12-06-2017

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

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

Highlighted
Posts: 756
Kudos: 89
Solutions: 46
Registered: ‎04-06-2015

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

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 it as an accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Announcements