Regarding Hadoop Function

saikiran_nemani — Tue, 27 Mar 2018 11:11:24 GMT

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

Re: Regarding Hadoop Function

ballardw — Tue, 27 Mar 2018 21:23:16 GMT

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

topic Re: Regarding Hadoop Function in SAS Enterprise Guide

Regarding Hadoop Function

Re: Regarding Hadoop Function