display password as shown in example using spark scala

[sannycse]

Table has the following Columns:

First_Name, Last_Name, Department_Id,Contact_No, Hire_Date

Display the emplopyee First_name, Count of Characters in the firstname,password.

Password should be first 4 letters of first name in lower case and the date and month of Hire_date

Example:

First_Name: SANJEEV

Hire_Date: 25-02-2016

Then password should be SANJ2502

[Hubert-Dudek · Accepted solution]

@SANJEEV BANDRU​ ,

SELECT 
   CONCAT(substring(First_Name, 0, 2) , substring(Hire_Date, 0, 2), substring(Hire_Date, 3, 2)) as password
FROM
   table;

If Hire_date is timestamp you may need to add date_format()

[jose_gonzalez]

Hi @SANJEEV BANDRU​ ,

Just checking if you still need help or if @Hubert Dudek​ 's response help you to resolve your question? please let us know.