Regarding Hadoop Function

[saikiran_nemani]

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 

[ballardw]

---

@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.