Desktop productivity for business analysts and programmers

Regarding Hadoop Function

Reply
Occasional Contributor
Posts: 12

Regarding Hadoop Function

CASE 

WHEN LEFT(je.product_id__c, 1) = 'C' THEN
RIGHT(je.product_id__c, Len(je.product_id__c) - 1)
ELSE je.product_id__c
END AS Product_ID

 

Please I want the code and what are the Functions used for Left,Right and Len in HADOOP 

Super User
Posts: 13,084

Re: Regarding Hadoop Function

Posted in reply to saikiran_nemani

@saikiran_nemani wrote:

CASE 

WHEN LEFT(je.product_id__c, 1) = 'C' THEN
RIGHT(je.product_id__c, Len(je.product_id__c) - 1)
ELSE je.product_id__c
END AS Product_ID

 

Please I want the code and what are the Functions used for Left,Right and Len in HADOOP 


 

This is a complete guess on my part as HADOOP can involve more than one DBMS.

 

I would start by trying standard SAS functions

Instead of LEFT try SUBSTR(je.product_id__c,1,1) to get the first character, LENGTH instead of LEN and SUBSTR(je.product_id__c, Length(je.product_id__c) - 1).

 

The SAS functions Left and Right justify variable values. If a variable contains "  text" (2 leading spaces) then Left(var) = "text" so that the non-blank text starts in the first position. The Right function moves trailing blanks to the start: Right ("text      ") = "     text".

So I suspect your code may have given you errors related to too many parameters for the Left and Right functions.

Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation