topic Re: display password as shown in example using spark scala in Data Engineering

display password as shown in example using spark scala

sannycse — Wed, 30 Mar 2022 18:51:13 GMT

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 — Wed, 30 Mar 2022 19:15:23 GMT

@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 — Mon, 25 Apr 2022 22:06:55 GMT

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.